Advanced Search Overview & How-To

ChannelApe’s advanced search is intended to allow you to step into your data like with no other system. You can search by orders or products and this is where you should go to create and re-run lists for your channel page. A list is the term we use to define the saved search critieria for an advanced search.  They can be saved so the lists can be used throughout Channel Ape, most notably on your dashboard.

 

If you would like to look up a single order or product, use the quick search bar at the top.  This will be much more efficient than using the advanced search.  The advanced search is much more powerful, but takes a little longer to use.

Do not let the advanced search’s size alarm you.  A search can be as simple as a few clicks, or as complex as selecting a value in every category.

Step-by-step guide


There are 3 purposes of Advanced Search: (Letters are examples)

  1. Running a single query that you want to only see once without saving.
    1. I want to see a list of orders that have a particular product on them.
    2. I want to see all my products within a price range
  2. Saving a re-usable query that you’ll use for make rules on specific channels like Amazon or Shopify.
    1. I only want to push products to Amazon that have a price > $20
    2. I want to push all my products to Shopify, except for a few SKUs
  3. Saving a re-usable query that you can add to your dashboard.
    1. When I log into ChannelApe, I’d like to see all my orders from each channel (Amazon, Shopify)
    2. When I log into ChannelApe, I’d like to see cancelled orders

 

Overview Of Field Types


The following types of fields are available:

  • Numeric Minimum / Maximum
  • Time Minimum / Maximum
  • Select (dropdown)
  • User Input

 

TYPE
DESCRIPTION
Min / Max

(Numeric)

Enter either minimum, maximum or both.
EX: To query for all prices between 10 and 20 dollars, you’d enter 10 in the minimum and 20 in the maximum.
Min / Max

(Time)

Time fields compare the minimum or maximum time something happened. Time fields take an absolute or variable value.

Absolute values like 2013/11/06 will work when you want to query on exact dates. Time may also be supplied: 2013/08/22 18:30:00

Variable values are dynamically calculated times. Every time the advanced search is run, the time is calculated. Times can only be adjusted into the past. A value like “now -7d” would set the date to 7 days ago. These are perfect for your dashboard. There can be space between each time group (now – 3 d).

You must always include the word now if you are not using an absolute (exact) value. Time groups must be supplied in decreasing order (y, m, w, d, h).

Possible Time Variables:

y = years (none – 99)

= months (none – 999)

w = weeks (none – 999)

= days (none – 999)

h = hours (none – 999)

Examples:

2013-01-01 18:00:00

now -1y

now -1m 2w 6h

Select

(Dropdown)

These are fields where there are absolute values where you can select only 1 value.
User Input These are fields that require your input like an order number or buyer e-mail address. Most of these input fields will accept a comma separated list of values. For example, if a user want to match 3 skus, they can be entered as a comma separated list (SKU1, SKU2, SKU3).
Match YES: When you set match to yes, you are matching whatever fields you filled in.

ex: Vendor = Nike with Match = Yes would only return products with a Vendor of Nike.

NO:

ex: Vendor = Nike with Match = No would only return products with a Vendor that is NOT Nike.

Columns to Return

Space is limited on your monitor, so we give the option to the user to get back only the data they need.  This is especially useful when making searches that will be used on the dashboard.  An example of the usefulness is searching for cancelled orders; you may not need to see that status in the result, because they will all be cancelled.  When searching for products that are vended by ‘Vendor AAA’, returning the vendor could be redundant.  All return columns are optional, but at least one must be selected.

Running a Single Query


1.Click search in the menu.

2. Next select some information you want to search by.

search-fields

 

3. Select Match to yes or no