Centra

Support Center

Searching in Centra

Last Updated: Dec 12, 2016 04:14PM CET

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 / Registered, 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 Sales / Orders 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 Sales / Orders 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 orrder: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 / Sales 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 searchng parameters

Description Search parameter Search type Example
Set amount of search
results per page
limit value limit:400
 

Sales / Orders

Specific attribute Description Search parameter Search type Example
Common attributes Order status status status status:1
  Order ID order value order:123456
  Order comment comment text comment:"wrong billing address"
  Orders with products from a collection collection text collection:"171"
  Order with products from a brand brand text brand:"Awesome Jeans"
  Shipping method shipping text shipping:"UPS Standard"
  Amount of unshipped products unshipped value unshipped:!0
  Order waiting waiting yes / no waiting:yes
  Order on hold hold yes / no hold: yes
  Allocated products allocated value allocated:0
  Amount of products on order pcs value pcs:1-5
  Total order cost total value total:1500
  Total order cost ex VAT totalex value total:1200
  Internal order internal yes / no internal:yes
  Payment type payment text payment:"Credit Card"
  Market market text market:"Retail"
  Pricelist pricelist text pricelist:"Retail - USD"
  Currency currency text currency:"USD"
  Store store text store:"Retail"
  Order created created date created:20160101-20160130
         
Wholesale Specific Backorder backorder yes / no backorder:yes
  Preorder preorder yes / no preorder:yes
  Preferred shipping date ship date ship:20160505
  Delivery window delwin text delwin:"AW16"
  Order with demand demand value demand:!0

Sales / Shipments

Specific attribute Description Search parameter Search type Example
Common attributes Paid paid yes / no paid:yes
  Good to go gtg yes / no gtg:no
  Shipped shipped yes / no shipped:no
  Shipment number shipment text shipment:123456-1
  Shipment method shipping text shipping:"Postnord"
  Shipment country country text country:"Sweden"
  Shipment city city text city:"Stockholm"
  Store store text store:"Retail"
  Amount of invoices invoices value invoices:!0
  Amount of products in shipment pcs value pcs:1-5
  Total shipment cost ex VAT totalex value totalex:1200
  Total shipment cost total value total:1500
  Shipment created created date created:20160101-20160131
  Shipment payment captured captured date captured:20160301
         
Retail specific Customer name name text name:"Firstname Lastname"
         
Wholesale specific Account name account text account:"Young & Skilled"
  Account ID accountid value accountid:12345
  Buyers name buyer text buyer:"Firstname Lastname"
  Sales representative salesrep text salesrep:"Firstname Lastname #1"
    po text  

Catalog / Products

Specific attribute Description Search parameter Search type Example
Common attributes Brand brand text brand:"The Best Brand"
  Product name product text product:"Super Nice Jeans"
  SKU ku text sku:"12345-M"
  Variant names variants text variants:"Burnt Red"
  Amount of variants for product variant value variant:1-5
  Media connected to product media value media:!0
  Available stock for product stock value stock:0
  Collection collection text collection:"117M"
  Folder ID folderid value folder:17
  Last modified modified date modified:20160101-20160130

Customers / Registered

Specific attribute Description Search parameter Search type Example
Common attributes Status status status status:1
  Registered customer registered yes / no registered:yes
  Customer name customer text customer:"Firstname Lastname"
  City city text city:"Stockholm"
  Country country text country:"Sweden"
  Amount of orders orders value orders:!0
  Last placed order lastorder date lastorder:20150915-20151225
  Total value of orders placed total value total:5200
  Store store text store:"Retail"
  Created created date created:20150101-20151231

Contact Us

support@youngskilled.com
http://assets1.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete