Searching in Centra

Last updated October 31st at 9:23am

About this article

In most of the places in Centra you, will find a search-field. Depending on where it is located, you can search for different criteria. Usually, the most common fields are searched through by just typing directly in the box. For example in 'Customers' / 'Accounts', you can just search for a piece of a name, but if you want to see customers created on a specific date or customers with a specific amount of placed orders, you need to use the Search Types explained below.

In this article, you will learn new ways to search more efficiently in Centra. You will also find a list of what you can search on for each section.

Searching in Centra

The parameters you are able to search by, are often the same name as the column header. If you want to be sure of the search parameter for a specific header, you can click on the header and the parameter's name will show up in the search-field.

When searching in Centra, you can combine multiple parameters to get more narrow results. For instance under 'Orders' in the DIRECT TO CONSUMER or _WHOLESALE you can search for country:”Sweden” payment:”Paypal” to see all orders from Sweden that has been paid with Paypal. You can even use the same search parameter multiple times. You can also use multiple values for one search parameter, for instance you can search for order:1111,2222,3333,4444 to find the orders with these order ID’s.

Centra also allows you to make inverted searches which returns results that don’t match the search query. For instance under 'Orders' in the DIRECT TO CONSUMER or _WHOLESALE you can search for unshipped:!0 to find all orders which don’t have 0 unshipped products, or in other words to find all orders that have unshipped products.

If a search returns 0 results, this might have to do with an incorrectly spelled search parameter. If an invalid search parameter has been used, the : between the parameter and the value will be removed. For instance, if you search for order:207755, the search result will show 0 matches and the : will be removed in the search-field as shown below since order is spelled incorrectly.

Search Types

• Date

  The Date-type can be used to search for a specific date or intervals between dates. Dates use the format YYYYMMDD or YYMMDD, both formats work the same. If you want to search for orders that have been created, for instance, the 15th of April 2015, you can use created:20150415. If you, however, want to search for all orders created during April, you can use created:20150401-20150430. You can also make inverted searches with dates.

• Value

  The Value-type is used when the search parameter takes a numeric value, for instance the total cost of an order or amount of products on an order. It’s possible to use both interval and inverted searches for this search type.

• Text

  If the search parameter takes a Text-type, it’s generally a good idea to put the value inside “”. For instance, a customer search for customer:Firstname Lastname combined with another search parameter will most likely result in an error and return the wrong results. It’s therefore recommended to use customer:”Firstname Lastname” instead, as this will not cause problems if combining with other search parameters.

Using Text-type searches doesn’t require the result to be an exact match with whole sentences or words. For instance if you search for customer:fre, all customers with “fre” in their name will be returned as a result, like Fred or Alfredo.

• Status

  Whenever there is a coloured box in a listing, that indicates the status for the object in the list. Each status have their own number that can be used as search values:

0 – Yellow / White

1 – Green

2 – Red

These statuses are also placed as selectors with a description of all statuses, which is placed above the search-field as seen below.

• Yes / No

  Some search parameters just contain ‘Yes’ or ‘No’, which states if the search parameter is true or false. For instance under 'Orders' in the DIRECT TO CONSUMER or _WHOLESALE you can search for eu:yes, which will return all orders that are placed in European countries. Searching for eu:no will return all orders that are placed in non-European countries.

Search types per section

Below you will find a table with all parameters in the most common sections. The table includes a short description of each parameter, what type it is and examples of how a search parameter can be used. Some parameters are specific for Retail and Wholesale, so the parameters for each section are divided into Common attributes aswell as Retail / Wholesale specific.

General searching parameters

Sales / Orders

Sales / Shipments

Catalog / Products

Customers / Registered

Search by attribute element

To search products by elements of attributes, you have to use the specific Search Key of the element. To find this Search Key follow the steps below:

1. Go to 'More' of the general section in the main menu to the left and click 'Attributes'
2. Find your attribute and open it in edit mode. Check (or add) a value in the text field to the right (Element value). Remember the name of this field (Element name). In the example below, Element names are "Color name", "Hex code" and the Element values are "Basic grey" and "#c4c4c4"
3. From the attributes list view switch to 'Attribute types' view:
4. Find the Element of your attribute, which you want to search for. The value in the last column is the Search Key
5. Copy this Search Key
6. Now go to the view, where you would like to perform the search (e.g. 'Products') and paste the Search Key into the search bar and the attribute Element value (from step 2) separated by colon. So in the example above if we were to search for all products with "Hex code #c4c4c4" we should type the following in the search bar __sh_swatch_color_hex:#c4c4c4__
7. Hit 'Search' button or press 'Enter'