Get Open Orders with filters set to:
Order with no Tags assigned
Get Open Orders with filters set to:
Order Tracking number: 1234567
Get Open Orders with filters set to:
Only Linked items in the order
Get Open Orders with filters set to:
Order Locked: No
Order Status: Paid
Order Shipping Service: RM 24 - CRL
Default Location (Empty Guid)
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
Get Open Orders within date range:
Get Open Order with filters and sorting set to:
Order Status: Paid
Sort Ascending By: Order Items Quantity
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_LEVELUnlinked: -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
Unpaid: 0
Paid: 1
Return: 2
Payment Pending: 3
Resend: 4
Locked: 5
Parked: 6