SerializableDictionary(Of String, String)

Fields

Field Name  Data Type  Description
Keys String () List of Keys – includes date range, customer name, order number, or SKU
Values String () List of Values

Filter Keys

SKU – Returns orders containing the Product ID

Company – Filters by Company ID

Companies – Filters by a list of Company IDs. Can be separated by comma, semicolon, pipe or empty space.

DateFrom and DateTo – Can filter the range of orders in specific time frame

Invoice – Filters orders by invoice status.

  • -1 – All invoice statuses
  • 0 – not-printed invoices
  • 1 – printed invoices

ShipFromWarehouseID – filters by SellerCloud Warehouse ID.

Channel – Filters by SellerCloud channel ID. -1 will return all channels. List of channels can be found here. This list does not include any channels integrated by plugins – they all count as Website channels.

Location – Filters by location

  • -1 – All locations
  • 1 – Domestic
  • 2 – International

BackOrderStatus – Filters by Back Order Status.

  • -1 – All orders
  • 1 – Orders with Back Order Status
  • 2 – Orders without Back Order Status

ExportedStatus– Filters orders by exported status

  • -1 – All statuses
  • 1 – Orders with exported status
  • 2 – Orders with not-exported status

CustomerName – Filters by customer name

OrderNo – Filters by SellerCloud Order ID

Rush – Will return only Rush Orders

CusNote – Will return orders with or without customer notes

  • -1 – All orders
  • 0 – Orders without customer notes
  • 1 – Orders with customer notes

MultiItems – returns orders based on the number of products

  • -1 – All Orders
  • 1 – Orders with single item
  • 2 – Multi-item orders

MultiPackage – returns orders based on the number of packages

  • -1 – All orders
  • 1 – Single package orders
  • 0 – Multiple package orders

Gift – Will return orders marked as Gift Orders

  • -1 – All orders
  • 1 – Gift Orders
  • 0 – Non-Gift Orders

Wrap – Returns Gift Wrap orders

  • -1 – All orders
  • 1 – Wrap orders
  • 0 – Non-Wrap orders

OrderNoRangeEnd – Returns orders with IDs up to this number

ShippedBy – Filters by shipping user ID

ReadyForPickup – Filters by pickup status

  • -1 – All orders
  • 1 – Pickup only
  • 0 – Non-Pickup only

ShipCarrierNew – Filters by ship carrier. Send ALL for all carriers.

ShipServiceNew – Filters by shipping service. Send ALL for all services.

FilterKit – Filters orders with kit items. 1 or 0

LocNotesOp – Works with the LocNotes filter.

  • 0 – means the note is different than the LocNotes
  • 1 – matches the location note as string
  • 2 – looks for notes that start with this string

LocNotes – Filters by Location note. Works with LocNotesOp filter

SortForScanShip – Sorts for scan and ship. 1 or 0

ScanShipSortDate – Works with SortForScanShip filter. 1 or 0. Will sort single items first then multi items alphabetically.

CustomerServiceStatus – Filters by customer services status

Picklist – Includes orders related to specified Picklist ID

CompanyName – Can filter by company name instead of ID

ExclusiveSku – filters by exclusive SKU.

OrderGroupID – Filters by Order group ID

ProductGroupID – Filters by product group ID

SavedSearch – Filters by Saved Search ID. Very useful as you can apply all the needed filters in the interface, save them and then just use that saved search.

OrderUserID – Filters by Order User ID

DownloadedFlag – Filters orders by downloaded status

  • -1 – All orders
  • 1 – downloaded
  • 0 – not downloaded

ReturnProductInfo – Includes product info. 1 or 0

ReadyToShip – Filters orders by Ready To Ship status.

DollarAmount – Filters by dollar amount. See next filter for more info.

DollarAmountOperation – Works with the filter DollarAmount

  • >= – Greater or Equal
  • <= – Less or Equal

AmazonPrime – Only Amazon Prime Orders

PaymentStatus – Filters by payment status

  • 10 – No Payment
  • 20 – Authorized
  • 30 – Charged
  • 40 – Uncleared
  • 50 – Partially Refunded
  • 60 – Full Refund
  • 70 – Partial Payment
  • 80 – eBay Paid
  • 99 – Payment Error

ShippingStatusKind – Filters by shipping status

  • -1 – All orders
  • 0 – Unknown
  • 1 – Unshipped
  • 2 – Partially Shipped
  • 3 – Fully Shipped
  • 4 – Ready For Pickup

IsConfirmed – Returns orders based on their Confirmed Status. 1 or 0

IncludeDS – Include DropShip status. 1 or 0

PickingStatus – Filters based on order picking status

  • 0 – None
  • 1 – Partially Picked
  • 2 – Fully Picked
  • 3 – Over Picked

ConfirmationLabelPrinted – Filters based on confirmation label printed

  • -1 – All orders
  • 0 – Not printed only
  • 1 – Printed only