Get Open Orders with filters set to:

Order with no Tags assigned

   

entriesPerPage=100&pageNumber=1&filters={"ListFields":
[{"FieldCode":"GENERAL_INFO_TAG","Type":1,"Value":1},
{"FieldCode":"GENERAL_INFO_TAG","Type":1,"Value":2},
{"FieldCode":"GENERAL_INFO_TAG","Type":1,"Value":3},
{"FieldCode":"GENERAL_INFO_TAG","Type":1,"Value":4},
{"FieldCode":"GENERAL_INFO_TAG","Type":1,"Value":5},
{"FieldCode":"GENERAL_INFO_TAG","Type":1,"Value":6}]}&sorting=[]&fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=

   

Get Open Orders with filters set to:

Order Tracking number: 1234567


entriesPerPage=100&pageNumber=1&filters=
{"TextFields":
[{"FieldCode":"SHIPPING_INFORMATION_TRACKING_NUMBER","Type":0,"Text":"1234567"}]}&sorting=[]&fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=



Get Open Orders with filters set to:

Only Linked items in the order


entriesPerPage=100&pageNumber=1&filters={"ListFields":
[{"FieldCode":"STOCK_LEVEL","Value":-1,"Type":1}]}&sorting=[]&fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=



Get Open Orders with filters set to:

Order Locked: No

Order Status: Paid

Order Shipping Service: RM 24 - CRL

Default Location (Empty Guid)


entriesPerPage=100&pageNumber=1&
filters={"BooleanFields":[{"FieldCode":"GENERAL_INFO_LOCKED","Value":"false"}],
"ListFields":[{"FieldCode":"GENERAL_INFO_STATUS","Value":1},
{"FieldCode":"SHIPPING_INFORMATION_SERVICE","Value":"RM 24 - CRL"}]}&
sorting=[]&fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter= 

    

Get Open Orders with filters set to:

Customer Address Line 1 equals to: 22 George St

Customer Address Line 2 contains: Mayfair Court

Customer Address Line 3 starts with: Sunshine

Customer Company Name ends with: Views

    

entriesPerPage=100&pageNumber=1&
filters={"TextFields":[{"FieldCode":"CUSTOMER_ADDRESS_ADDRESS1","Type":0,"Text":"22 George St"},
{"FieldCode":"CUSTOMER_ADDRESS_ADDRESS2","Type":1,"Text":"Mayfair Court"},
{"FieldCode":"CUSTOMER_ADDRESS_ADDRESS3","Type":2,"Text":"Sunshine"},
{"FieldCode":"CUSTOMER_ADDRESS_COMPANY","Type":3,"Text":"Views"}]}
&sorting=[]&fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=

    

Get Open Orders within date range:

  

entriesPerPage=100&pageNumber=1&
filters={"DateFields":[{"FieldCode":"GENERAL_INFO_DATE","Type":"Range","DateFrom":"2016-08-16T23:00:00.000Z","DateTo":"2016-08-20T23:00:00.000Z"}]}
&sorting=[]&fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=

  


Get Open Order with filters and sorting set to:

Order Status: Paid

Sort Ascending By: Order Items Quantity

  

entriesPerPage=100&pageNumber=1&
filters={"ListFields":[{"FieldCode":"GENERAL_INFO_STATUS","Type":0,"Value":1}]}&
sorting=[{"Direction":0,"FieldCode":"ITEMS_QUANTITY"}]&
fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=

     


BooleanFields codes:

GENERAL_INFO_LABEL_PRINTED

GENERAL_INFO_INVOICE_PRINTED

GENERAL_INFO_PICK_LIST_PRINTED

GENERAL_INFO_PART_SHIPPED

GENERAL_INFO_LOCKED

GENERAL_INFO_PARKED

ITEMS_IMAGE


BooleanFields values:

true

false


ListFields codes:

GENERAL_INFO_SOURCE

GENERAL_INFO_SUBSOURCE

GENERAL_INFO_STATUS

GENERAL_INFO_TAG

SHIPPING_INFORMATION_SERVICE_ID

SHIPPING_INFORMATION_VENDOR

SHIPPING_INFORMATION_SERVICE

SHIPPING_INFORMATION_PACKAGING_GROUP

CUSTOMER_ADDRESS_COUNTRY

CUSTOMER_ADDRESS_COUNTRY_ZONE

TOTALS_CURRENCY

TOTALS_PAYMENT_METHOD

FOLDER

ITEMS_CATEGORY

STOCK_LEVEL


TextFields codes:

GENERAL_INFO_ORDER_ID

GENERAL_INFO_REFERENCE_NUMBER

GENERAL_INFO_EXTERNAL_REFERENCE_NUMBER

SHIPPING_INFORMATION_TRACKING_NUMBER

CUSTOMER_ADDRESS_ADDRESS1

CUSTOMER_ADDRESS_ADDRESS2

CUSTOMER_ADDRESS_ADDRESS3

CUSTOMER_ADDRESS_COMPANY

CUSTOMER_ADDRESS_FULL_NAME

CUSTOMER_ADDRESS_POSTCODE

CUSTOMER_ADDRESS_TOWN

CUSTOMER_ADDRESS_COUNTY

CUSTOMER_EMAIL

CUSTOMER_PHONE

ITEMS_SKU

ITEMS_ORIGINAL_SKU

ITEMS_TITLE

ITEMS_ORIGINAL_TITLE

ITEMS_BINRACK


TextFields Type:

Equals: 0

Contains: 1

Starts With: 2

Ends With: 3


Numeric Field Type:

Equal: 0
Greater: 1
Lower: 2


ListFields Type:

IS (equals): 0

IS NOT (not equal): 1


DateTimeField Type:

Range: 0,
OlderThan: 1
LastDays: 2


IntegerField codes:

GENERAL_INFO_NOTES

GENERAL_INFO_ITEMS_COUNT


Sorting Direction:

Ascending: 0

Descending: 1



ListFields Values:

STOCK_LEVEL

Unlinked: -1

Insufficient to fulfill all orders: 1

Reaching Minimum Level: 2

Out-of-stock: 3

Awaiting Stock: 4

Awaiting Stock - Oversold: 5

Approaching Minimum Level: 6

Sufficient Stock Level: 7

Optimal Stock Level: 8

Potentially Overstocking: 9

Overstocking: 10

No Minimum Level: 11


GENERAL_INFO_STATUS

Unpaid: 0

Paid: 1

Return: 2

Payment Pending: 3

Resend: 4 

Locked: 5

Parked: 6