Retrieves a list of orders, given the provided paging, filtering, and sorting.
Search Orders runs with these defaults, which you can override:
createdDate is sorted in DESC order.cursorPaging.limit is 100.Note: Search Orders does not return orders with status: "INITIALIZED", regardless of the filter applied. To retrieve an order with status: "INITIALIZED", use Get Order.
To learn how to query or search orders, see API Query Language.
| Property | Capabilities | Filters |
|---|---|---|
channelInfo.type | Search: ✗ Sort: ASC, DESC | $eq, $in, $ne, $nin |
fulfillmentStatus | Search: ✗ Sort: ASC, DESC | $eq, $in, $ne, $nin |
paymentStatus | Search: ✗ Sort: ASC, DESC | $eq, $in, $ne, $nin |
shippingInfo.region.name | Search: ✗ Sort: ASC, DESC | $eq, $in, $ne, $nin |
shippingInfo.title | Search: ✗ Sort: ASC, DESC | $eq, $in, $ne, $nin |
status | Search: ✗ Sort: ASC, DESC | $eq, $in, $ne, $nin |
_createdDate | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $lt, $lte, $gt, $gte |
_updatedDate | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $lt, $lte, $gt, $gte |
balanceSummary.authorized.amount | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte |
balanceSummary.pending.amount | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte |
balanceSummary.pendingRefund.amount | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte |
billingInfo.contactDetails.firstName | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte |
billingInfo.contactDetails.lastName | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte |
businessLocation._id | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte |
businessLocation.name | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte |
buyerInfo.email | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte |
number | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $lt, $lte, $gt, $gte |
priceSummary.total.amount | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte |
purchasedDate | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $lt, $lte, $gt, $gte |
shippingInfo.logistics.deliveryTime | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte |
shippingInfo.logistics.deliveryTimeSlot.from | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $lt, $lte, $gt, $gte |
shippingInfo.logistics.deliveryTimeSlot.to | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $lt, $lte, $gt, $gte |
taxInfo.totalExempt.amount | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte |
taxInfo.totalTax.amount | Search: ✗ Sort: ASC, DESC | $eq, $ne, $exists, $in, $any, $begins, $gt, $lt, $lte, $gte |
archived | Search: ✗ Sort: ✗ | $eq, $ne, $exists, $in, $any |
seenByAHuman | Search: ✗ Sort: ✗ | $eq, $ne, $exists, $in, $any |
_id | Search: ✗ Sort: ✗ | $eq, $in, $ne, $nin |
buyerInfo.contactId | Search: ✗ Sort: ✗ | $eq, $in, $ne, $nin |
buyerInfo.memberId | Search: ✗ Sort: ✗ | $eq, $in, $ne, $nin |
channelInfo.externalOrderId | Search: ✗ Sort: ✗ | $eq, $in, $ne, $nin |
checkoutId | Search: ✗ Sort: ✗ | $eq, $in, $ne, $nin |
createdBy.userId | Search: ✗ Sort: ✗ | $eq, $in, $ne, $nin |
lineItems.subscriptionInfo._id | Search: ✗ Sort: ✗ | $eq, $in, $ne, $nin |
lineItems.catalogReference.appId | Search: ✗ Sort: ✗ | $hasAll, $hasSome |
lineItems.catalogReference.catalogItemId | Search: ✗ Sort: ✗ | $hasAll, $hasSome |
lineItems.locations._id | Search: ✗ Sort: ✗ | $hasAll, $hasSome |
fulfillmentStatusesAggregate.statuses | Search: ✗ Sort: ASC, DESC | $hasAll, $hasSome |
lineItems.productName.original | Search: ✗ Sort: ASC, DESC | $hasAll, $hasSome |
This method may require higher-level permissions than the caller has, based on their identity and roles and permissions. In these cases, you can ensure the method is called with the required level of authorization by using one of the following:
Search options.
This method doesn't return any custom errors, but may return standard errors. Learn more about standard Wix errors.