What are the various filter options?
Different web shop platforms generate different order objects. In principle, you can filter all content from that order object using the following statements:
- eq (EN:equals)
- neq (EN:not equals)
- in (EN: in)
- nin (EN: not in)
- lt (EN: less than)
- lte (EN: less than or equals)
- gt (EN: greater than)
- gte (EN: greater than or equals)
Examples
The following filter can be applied to a Shopify web shop:
{
"financial_status": {
"eq": "paid"
},
"shipping_address": {
"country_code": {
"neq": "DE"
}
}
}This means that only orders with the status “paid” will be received if the shipping address does not contain the country code “DE” (Germany).
In the filter below, we exclude several countries with the statement ‘NIN’ (not in):
{
"financial_status": {
"eq": "paid"
},
"shipping_address": {
"country_code": {
"nin": ["DE", "US"]
}
}
}
When this filter is applied, orders from Germany and the United States will not be received in Webship Online.
Below you can download the complete order objects (completed with fictitious data) for each web shop platform in a JSON format. This will tell you which filters are available and how you can build them:
How to apply filters?
Last but not least, you can apply these filters by navigating to “Shops” in Webship Online and selecting the desired web shop. You can then choose “advanced” (instead of “status”) under “order filters”.