INTEGRATION

Filters by the name you have configured in the eCommerce Integrations.

ITEMCOUNT

Filters by the number of items in the order.

ORDERDATE

Filters by the order date.

ORDERGROUP

Filters by the order group set within the platform.

ORDERWEIGHT

Filters by the weight of the order.

CONTENTDESCRIPTION

Filters by the Content Description.

SKUS

Filters by SKU ID's.

TAGS

Filters by Order Tags.

DESTINATIONCOUNTRY

Filters by Destination Countries.

DESTINATIONADDRESS1

Filters by Destination Address on line 1

DESTINATIONSTATE

Filters by Destination State

DESTINATIONZIP

Filters by Destination Zip Code

DESTINATIONZIPPLUS4

Filters by Destination +4 Zip Code

USPSZONE

Filters by USPS zones.

CUSTOMER_NOTES

Filters by the customer notes.

XPS_NOTES

Filters by XPS Ship notes.

SHIPPINGSERVICESELECTED

Filters by the shipping service selected.

ORDERPRICE

Filters by the Order Price

COUNTIN

Filters by the number of items/values in combination with another filter type such as SKU’s

ITEMATTRIBUTES

Filters by the item attributes.

=

This will pull anything that matches your search.

!=

This will exclude anything that you type in with this.

>

This will do greater than, usually done with an item count.

<

This will do less than, usually done with an item count.

LIKE

This is used in order to search for something without it being case sensitive.

IN

This is a keyword that should precede a quoted comma-separated list inside of brackets. ['a','b','c']

NOT

This is used to exclude something.

[]

Brackets are used for an array or list.

()

Parentheses are used to determine the order of operation for the grouping of logic statements.

AND

This will allow you to filter by 2 factors instead of just one but is an exact match. Note you need () in order for this to work.

OR

This will allow you to filter by 2 factors but will search for one or the other doesn't have to match both to get the orders. Note you need () in order for this to work.

%

This is a wildcard symbol, it is used to find partial matches of what you are looking for. So if you have SKUs broken out by color but don't want to look for each color, you could use the % symbol to have it pull all SKUs with the base name.) For the query, you will want to put the % at the beginning and end of whatever you are looking for so that it will look for the word.

INTEGRATION = 'woocommerce'

Selects orders from the integration named "woocommerce"

INTEGRATION like '%cart%'

Selects orders that have the word "cart" anywhere in the integration name.

('quadpak' IN SKUS)

Selects orders that have the word "quadpack" in the SKU Name.

%1212% IN SKUS

Selects orders with "1212" in the SKU.

'Expedited Shipping' IN TAGS

Selects orders with the order tag name "Expedited Shipping"

'%shoes%' like XPS_NOTES

Selects orders with the word "Shoes" in the XPS Ship notes.

'%mittens%' like CUSTOMER_NOTES

Selects orders with the word "mittens" in the Customer notes.

(ORDERWEIGHT > 4) AND ('multipack' IN CONTENTDESCRIPTION)

Select orders with a weight greater than 4 lbs and where "multipak" is in the Content Description.

(ITEMCOUNT > 2) AND (ORDERGROUP = 'manufacturing')

Selects orders that have an item count of more than 2 and are in the "manufacturing" order group.

SHIPPINGSERVICESELECTED IN ['rush', 'expedited', 'two-day']

Selects orders that have the shipper service selected upon checking that have the words rush, expedited, or two-day in the name.

(USPSZONE != '4') OR (TAGCOUNT >= 1)

Selects orders that are not in USPS Zone 4 and also have one or more tags assigned to the orders.

DESTINATIONADDRESS1 like '%Main Street%'

Selects orders that have the word "Main Street" on address line 1

DESTINATIONSTATE = 'CA'

Selects orders going to the state CA (California)

DESTINATIONZIP = '00601'

Selects orders that have the zip code "00601

DESTINATIONZIPPLUS4 = '09498-0048'

Selects orders that have the zip code "09498-0048"

DESTINATIONCOUNTRY IN ['US', 'FR', 'DE', 'UK']

Selects orders where the sender address is in one of the following countries: US, France, Germany, United Kingdom.

'%color:black%' IN ITEMATTRIBUTES

Selects orders that have color as field attribute name and black in the field for the attribute value.

ORDERDATE > '2020-01-11 22:07:55' (DATE FORMAT : YYYY-MM-DD HH:mm:ss)

Selects orders that were created after 2020-01-11 at 10:07 PM

NOT (INTEGRATION IN ['baseballCardsEbay', lawnOrnamentsEbay'])

Selects orders not in the Integrations named "baseballCardsEbay"or "lawnOrnamentsEbay"

ORDERPRICE >= 10

Selects orders with an order price greater than or equal to $10.00

('quadpak' IN SKUS) OR ('pak' COUNTIN SKUS >= 4) OR ('%9%' COUNTIN SKUS = 1)

Selects orders that have the word "quadpack" in the SKU Name, or the word “pak” 4 or more times, or any SKU that has a 9 in it is equal to 1