9/12/2026, 12:00:41 AM
Order queries (orders and ordersCount) now recognize a new chargeback status value, “prevented,” which you can filter on similarly to accepted, lost, etc. Three new types—InventoryBinItem, InventoryBinItemConnection, and InventoryBinItemEdge—have been added to represent inventory items stored in a location bin, together with an inventoryBinItems connection field on InventoryBin. A union type “MarketableResource” was introduced that can be a Collection, Product, or Shop, and a new MarketedResource object that exposes this resource, with connections and edges to retrieve marketing activity resources. MarketingEvent objects now expose a marketedResources connection for the resources a marketing activity advertises, and the enum MarketingActivityUserErrorCode gained the value MARKED_RESOURCES_NOT_SUPPORTED_FOR_STOREFRONT_APP. The orders query argument “query” descriptions were updated to include the new “prevented” filter value, and the same updates were applied to the ordersCount query. The default sortKey for orders on the shop, customer, and company types remains ID; no substantive changes beyond the additional filter and new types. Developers should update their queries if they want to retrieve inventory bin details or filter orders by the prevented chargeback status, and handle the new marketing resource types in response data.
Returns a list of orders placed in the store, including data such as order status, customer, and line item details.
Use the orders query to build reports, analyze sales performance, or automate fulfillment workflows. The orders query supports pagination,
sorting, and filtering.
Returns the number of orders in the shop. You can filter orders using search syntax or a SavedSearch, and set a maximum count limit to control query performance.
Use the query argument to filter the count by criteria like order status, financial state, or fulfillment status. The response includes both the count value and its precision, indicating whether the count is exact or an estimate.
Note:
The count is limited to 10,000 orders by default. Use thelimitargument to adjust this value, or passnullfor no limit. Limited to a maximum of 10000 by default.
The quantity of an inventory item stored in a bin.
Note:
This object is available only in the unstable API version and to development stores
that have enabled the Physical inventory feature preview.
An auto-generated type for paginating through multiple InventoryBinItems.
An auto-generated type which holds one InventoryBinItem and a cursor during pagination.
A resource that a marketing activity can advertise.
A link between a marketing activity and a resource it advertises.
An auto-generated type for paginating through multiple MarketedResources.
An auto-generated type which holds one MarketedResource and a cursor during pagination.
ordersorders on CompanyThe list of the company's orders.
OrderConnection!first: Int - The first n elements from the paginated list.
after: String - The elements that come after the specified cursor.
last: Int - The last n elements from the paginated list.
before: String - The elements that come before the specified cursor.
reverse: Boolean - Reverse the order of the underlying list.
sortKey: OrderSortKeys - Sort the underlying list using a key. If your query is slow or returns an error, then try specifying a sort key that matches the field used in the search.
query: String - A filter made up of terms, connectives, modifiers, and comparators.
| name | type | description | acceptable_values | default_value | example_use |
|---|---|---|---|---|---|
| default | string | Filter by a case-insensitive search of multiple fields in a document. | - query=Bob Norman- query=title:green hoodie |
||
| cart_token | string | Filter by the cart token's unique value to track abandoned cart conversions or troubleshoot checkout issues. The token references the cart that's associated with an order. | - cart_token:abc123 |
||
| channel | string | Filter by the order attribution handle (Order.attribution.handle) field. The legacy channel information handle (ChannelInformation.channelDefinition.handle) field is deprecated but remains supported during the deprecation period. |
- channel:web- channel:web,pos |
||
| channel_id | id | Filter by the channel id field. |
- channel_id:123 |
||
| chargeback_status | string | Filter by the order's chargeback status. A chargeback occurs when a customer questions the legitimacy of a charge with their financial institution. | - accepted- charge_refunded- lost- needs_response- under_review- won |
- chargeback_status:accepted |
|
| checkout_token | string | Filter by the checkout token's unique value to analyze conversion funnels or resolve payment issues. The checkout token's value references the checkout that's associated with an order. | - checkout_token:abc123 |
||
| confirmation_number | string | Filter by the randomly generated alpha-numeric identifier for an order that can be displayed to the customer instead of the sequential order name. This value isn't guaranteed to be unique. | - confirmation_number:ABC123 |
||
| created_at | time | Filter by the date and time when the order was created in Shopify's system. | - created_at:'2020-10-21T23:39:20Z'- created_at:<now- created_at:<=2024 |
||
| credit_card_last4 | string | Filter by the last four digits of the payment card that was used to pay for the order. This filter matches only the last four digits of the card for heightened security. | - credit_card_last4:1234 |
||
| current_total_price | float | Filter by the current total price of the order in the shop currency, including any returns/refunds/removals. This filter supports both exact values and ranges. | - current_total_price:10- current_total_price:>=5.00 current_total_price:<=20.99 |
||
| customer_id | id | Filter orders by the customer id field. |
- customer_id:123 |
||
| delivery_method | string | Filter by the delivery methodType field. |
- shipping- pick-up- retail- local- pickup-point- none |
- delivery_method:shipping |
|
| discount_code | string | Filter by the case-insensitive discount code that was applied to the order at checkout. Limited to the first discount code used on an order. Maximum characters: 255. | - discount_code:ABC123 |
||
| string | Filter by the email address that's associated with the order to provide customer support or analyze purchasing patterns. | - email:example@shopify.com |
|||
| financial_status | string | Filter by the order displayFinancialStatus field. |
- paid- pending- authorized- partially_paid- partially_refunded- refunded- voided- expired |
- financial_status:authorized |
|
| fraud_protection_level | string | Filter by the level of fraud protection that's applied to the order. Use this filter to manage risk or handle disputes. | - fully_protected- partially_protected- not_protected- pending- not_eligible- not_available |
- fraud_protection_level:fully_protected |
|
| fulfillment_location_id | id | Filter by the fulfillment location id (Fulfillment.location.id) field. |
- fulfillment_location_id:123 |
||
| fulfillment_status | string | Filter by the displayFulfillmentStatus field to prioritize shipments or monitor order processing. |
- unshipped- shipped- fulfilled- partial- scheduled- on_hold- unfulfilled- request_declined |
- fulfillment_status:fulfilled |
|
| gateway | string | Filter by the paymentGatewayNames field. Use this filter to find orders that were processed through specific payment providers like Shopify Payments, PayPal, or other custom payment gateways. |
- gateway:shopify_payments |
||
| id | id | Filter by id range. |
- id:1234- id:>=1234- id:<=1234 |
||
| location_id | id | Filter by the location id that's associated with the order to view and manage orders for specific locations. For POS orders, locations must be defined in the Shopify admin under Settings > Locations. If no ID is provided, then the primary location of the shop is returned. |
- location_id:123 |
||
| metafields.{namespace}.{key} | mixed | Filters resources by metafield value. Format: metafields.{namespace}.{key}:{value}. Learn more about querying by metafield value. |
- metafields.custom.on_sale:true- metafields.product.material:"gid://shopify/Metaobject/43458085" |
||
| name | string | Filter by the order name field. |
- name:1001-A |
||
| payment_id | string | Filter by the payment ID that's associated with the order to reconcile financial records or troubleshoot payment issues. | - payment_id:abc123 |
||
| payment_provider_id | id | Filter by the ID of the payment provider that's associated with the order to manage payment methods or troubleshoot transactions. | - payment_provider_id:123 |
||
| po_number | string | Filter by the order poNumber field. |
- po_number:P01001 |
||
| processed_at | time | Filter by the order processedAt field. |
- processed_at:'2021-01-01T00:00:00Z' |
||
| reference_location_id | id | Filter by the ID of a location that's associated with the order, such as locations from fulfillments, refunds, or the shop's primary location. | - reference_location_id:123 |
||
| requested_order_edit_status | string | Filter by the order's displayRequestedEditStatus to track which orders have buyer-initiated requested order edits pending merchant action. |
- none- requested- resolved- declined |
- requested_order_edit_status:requested |
|
| return_status | string | Filter by the order's returnStatus to monitor returns processing and track which orders have active returns. |
- return_requested- in_progress- inspection_complete- returned- return_failed- no_return |
- return_status:in_progress |
|
| risk_level | string | Filter by the order risk assessment riskLevel field. |
- high- medium- low- none- pending |
- risk_level:high |
|
| sales_channel | string | Filter by the sales channel where the order was made to analyze performance or manage fulfillment processes. | - sales_channel: some_sales_channel |
||
| shipping_address_validation_result_summary | string | Filter by the validation status of the shipping address. Learn more about validating addresses. | - has_issues- no_issues- not_validated |
- shipping_address_validation_result_summary:no_issues |
|
| sku | string | Filter by the product variant sku field. Learn more about SKUs. |
- sku:ABC123 |
||
| source_identifier | string | Filter by the ID of the order placed on the originating platform, such as a unique POS or third-party identifier. This value doesn't correspond to the Shopify ID that's generated from a completed draft order. | - source_identifier:1234-12-1000 |
||
| source_name | string | Filter by the platform where the order was placed to distinguish between web orders, POS sales, draft orders, or third-party channels. Use this filter to analyze sales performance across different ordering methods. | - source_name:web- source_name:shopify_draft_order |
||
| status | string | Filter by the order's status to manage workflows or analyze the order lifecycle. | - open- closed- cancelled- not_closed |
- status:open |
|
| subtotal_line_items_quantity | string | Filter by the total number of items across all line items in an order. This filter supports both exact values and ranges, and is useful for identifying bulk orders or analyzing purchase volume patterns. | - subtotal_line_items_quantity:10- subtotal_line_items_quantity:5..20 |
||
| tag | string | Filter objects by the tag field. |
- tag:my_tag |
||
| tag_not | string | Filter by objects that don’t have the specified tag. | - tag_not:my_tag |
||
| test | boolean | Filter by test orders. Test orders are made using the Shopify Bogus Gateway or a payment provider with test mode enabled. | - test:true |
||
| total_weight | string | Filter by the order weight. This filter supports both exact values and ranges, and is to be used to filter orders by the total weight of all items (excluding packaging). It takes a unit of measurement as a suffix. It accepts the following units: g, kg, lb, oz. | - total_weight:10.5kg- total_weight:>=5g total_weight:<=20g- total_weight:.5 lb |
||
| updated_at | time | Filter by the date and time when the order was last updated in Shopify's system. | - updated_at:'2020-10-21T23:39:20Z'- updated_at:<now- updated_at:<=2024 |
||
| You can apply one or more filters to a query. Learn more about Shopify API search syntax. |
The list of the company's orders.
OrderConnection!first: Int - The first n elements from the paginated list.
after: String - The elements that come after the specified cursor.
last: Int - The last n elements from the paginated list.
before: String - The elements that come before the specified cursor.
reverse: Boolean - Reverse the order of the underlying list.
sortKey: OrderSortKeys - Sort the underlying list using a key. If your query is slow or returns an error, then try specifying a sort key that matches the field used in the search.
query: String - A filter made up of terms, connectives, modifiers, and comparators.
| name | type | description | acceptable_values | default_value | example_use |
|---|---|---|---|---|---|
| default | string | Filter by a case-insensitive search of multiple fields in a document. | - query=Bob Norman- query=title:green hoodie |
||
| cart_token | string | Filter by the cart token's unique value to track abandoned cart conversions or troubleshoot checkout issues. The token references the cart that's associated with an order. | - cart_token:abc123 |
||
| channel | string | Filter by the order attribution handle (Order.attribution.handle) field. The legacy channel information handle (ChannelInformation.channelDefinition.handle) field is deprecated but remains supported during the deprecation period. |
- channel:web- channel:web,pos |
||
| channel_id | id | Filter by the channel id field. |
- channel_id:123 |
||
| chargeback_status | string | Filter by the order's chargeback status. A chargeback occurs when a customer questions the legitimacy of a charge with their financial institution. | - accepted- charge_refunded- lost- needs_response- prevented- under_review- won |
- chargeback_status:accepted |
|
| checkout_token | string | Filter by the checkout token's unique value to analyze conversion funnels or resolve payment issues. The checkout token's value references the checkout that's associated with an order. | - checkout_token:abc123 |
||
| confirmation_number | string | Filter by the randomly generated alpha-numeric identifier for an order that can be displayed to the customer instead of the sequential order name. This value isn't guaranteed to be unique. | - confirmation_number:ABC123 |
||
| created_at | time | Filter by the date and time when the order was created in Shopify's system. | - created_at:'2020-10-21T23:39:20Z'- created_at:<now- created_at:<=2024 |
||
| credit_card_last4 | string | Filter by the last four digits of the payment card that was used to pay for the order. This filter matches only the last four digits of the card for heightened security. | - credit_card_last4:1234 |
||
| current_total_price | float | Filter by the current total price of the order in the shop currency, including any returns/refunds/removals. This filter supports both exact values and ranges. | - current_total_price:10- current_total_price:>=5.00 current_total_price:<=20.99 |
||
| customer_id | id | Filter orders by the customer id field. |
- customer_id:123 |
||
| delivery_method | string | Filter by the delivery methodType field. |
- shipping- pick-up- retail- local- pickup-point- none |
- delivery_method:shipping |
|
| discount_code | string | Filter by the case-insensitive discount code that was applied to the order at checkout. Limited to the first discount code used on an order. Maximum characters: 255. | - discount_code:ABC123 |
||
| string | Filter by the email address that's associated with the order to provide customer support or analyze purchasing patterns. | - email:example@shopify.com |
|||
| financial_status | string | Filter by the order displayFinancialStatus field. |
- paid- pending- authorized- partially_paid- partially_refunded- refunded- voided- expired |
- financial_status:authorized |
|
| fraud_protection_level | string | Filter by the level of fraud protection that's applied to the order. Use this filter to manage risk or handle disputes. | - fully_protected- partially_protected- not_protected- pending- not_eligible- not_available |
- fraud_protection_level:fully_protected |
|
| fulfillment_location_id | id | Filter by the fulfillment location id (Fulfillment.location.id) field. |
- fulfillment_location_id:123 |
||
| fulfillment_status | string | Filter by the displayFulfillmentStatus field to prioritize shipments or monitor order processing. |
- unshipped- shipped- fulfilled- partial- scheduled- on_hold- unfulfilled- request_declined |
- fulfillment_status:fulfilled |
|
| gateway | string | Filter by the paymentGatewayNames field. Use this filter to find orders that were processed through specific payment providers like Shopify Payments, PayPal, or other custom payment gateways. |
- gateway:shopify_payments |
||
| id | id | Filter by id range. |
- id:1234- id:>=1234- id:<=1234 |
||
| location_id | id | Filter by the location id that's associated with the order to view and manage orders for specific locations. For POS orders, locations must be defined in the Shopify admin under Settings > Locations. If no ID is provided, then the primary location of the shop is returned. |
- location_id:123 |
||
| metafields.{namespace}.{key} | mixed | Filters resources by metafield value. Format: metafields.{namespace}.{key}:{value}. Learn more about querying by metafield value. |
- metafields.custom.on_sale:true- metafields.product.material:"gid://shopify/Metaobject/43458085" |
||
| name | string | Filter by the order name field. |
- name:1001-A |
||
| payment_id | string | Filter by the payment ID that's associated with the order to reconcile financial records or troubleshoot payment issues. | - payment_id:abc123 |
||
| payment_provider_id | id | Filter by the ID of the payment provider that's associated with the order to manage payment methods or troubleshoot transactions. | - payment_provider_id:123 |
||
| po_number | string | Filter by the order poNumber field. |
- po_number:P01001 |
||
| processed_at | time | Filter by the order processedAt field. |
- processed_at:'2021-01-01T00:00:00Z' |
||
| reference_location_id | id | Filter by the ID of a location that's associated with the order, such as locations from fulfillments, refunds, or the shop's primary location. | - reference_location_id:123 |
||
| requested_order_edit_status | string | Filter by the order's displayRequestedEditStatus to track which orders have buyer-initiated requested order edits pending merchant action. |
- none- requested- resolved- declined |
- requested_order_edit_status:requested |
|
| return_status | string | Filter by the order's returnStatus to monitor returns processing and track which orders have active returns. |
- return_requested- in_progress- inspection_complete- returned- return_failed- no_return |
- return_status:in_progress |
|
| risk_level | string | Filter by the order risk assessment riskLevel field. |
- high- medium- low- none- pending |
- risk_level:high |
|
| sales_channel | string | Filter by the sales channel where the order was made to analyze performance or manage fulfillment processes. | - sales_channel: some_sales_channel |
||
| shipping_address_validation_result_summary | string | Filter by the validation status of the shipping address. Learn more about validating addresses. | - has_issues- no_issues- not_validated |
- shipping_address_validation_result_summary:no_issues |
|
| sku | string | Filter by the product variant sku field. Learn more about SKUs. |
- sku:ABC123 |
||
| source_identifier | string | Filter by the ID of the order placed on the originating platform, such as a unique POS or third-party identifier. This value doesn't correspond to the Shopify ID that's generated from a completed draft order. | - source_identifier:1234-12-1000 |
||
| source_name | string | Filter by the platform where the order was placed to distinguish between web orders, POS sales, draft orders, or third-party channels. Use this filter to analyze sales performance across different ordering methods. | - source_name:web- source_name:shopify_draft_order |
||
| status | string | Filter by the order's status to manage workflows or analyze the order lifecycle. | - open- closed- cancelled- not_closed |
- status:open |
|
| subtotal_line_items_quantity | string | Filter by the total number of items across all line items in an order. This filter supports both exact values and ranges, and is useful for identifying bulk orders or analyzing purchase volume patterns. | - subtotal_line_items_quantity:10- subtotal_line_items_quantity:5..20 |
||
| tag | string | Filter objects by the tag field. |
- tag:my_tag |
||
| tag_not | string | Filter by objects that don’t have the specified tag. | - tag_not:my_tag |
||
| test | boolean | Filter by test orders. Test orders are made using the Shopify Bogus Gateway or a payment provider with test mode enabled. | - test:true |
||
| total_weight | string | Filter by the order weight. This filter supports both exact values and ranges, and is to be used to filter orders by the total weight of all items (excluding packaging). It takes a unit of measurement as a suffix. It accepts the following units: g, kg, lb, oz. | - total_weight:10.5kg- total_weight:>=5g total_weight:<=20g- total_weight:.5 lb |
||
| updated_at | time | Filter by the date and time when the order was last updated in Shopify's system. | - updated_at:'2020-10-21T23:39:20Z'- updated_at:<now- updated_at:<=2024 |
||
| You can apply one or more filters to a query. Learn more about Shopify API search syntax. |
ordersorders on CustomerA list of the customer's orders.
OrderConnection!first: Int - The first n elements from the paginated list.
after: String - The elements that come after the specified cursor.
last: Int - The last n elements from the paginated list.
before: String - The elements that come before the specified cursor.
reverse: Boolean - Reverse the order of the underlying list.
sortKey: OrderSortKeys - Sort the underlying list using a key. If your query is slow or returns an error, then try specifying a sort key that matches the field used in the search.
query: String - A filter made up of terms, connectives, modifiers, and comparators.
| name | type | description | acceptable_values | default_value | example_use |
|---|---|---|---|---|---|
| default | string | Filter by a case-insensitive search of multiple fields in a document. | - query=Bob Norman- query=title:green hoodie |
||
| cart_token | string | Filter by the cart token's unique value to track abandoned cart conversions or troubleshoot checkout issues. The token references the cart that's associated with an order. | - cart_token:abc123 |
||
| channel | string | Filter by the order attribution handle (Order.attribution.handle) field. The legacy channel information handle (ChannelInformation.channelDefinition.handle) field is deprecated but remains supported during the deprecation period. |
- channel:web- channel:web,pos |
||
| channel_id | id | Filter by the channel id field. |
- channel_id:123 |
||
| chargeback_status | string | Filter by the order's chargeback status. A chargeback occurs when a customer questions the legitimacy of a charge with their financial institution. | - accepted- charge_refunded- lost- needs_response- under_review- won |
- chargeback_status:accepted |
|
| checkout_token | string | Filter by the checkout token's unique value to analyze conversion funnels or resolve payment issues. The checkout token's value references the checkout that's associated with an order. | - checkout_token:abc123 |
||
| confirmation_number | string | Filter by the randomly generated alpha-numeric identifier for an order that can be displayed to the customer instead of the sequential order name. This value isn't guaranteed to be unique. | - confirmation_number:ABC123 |
||
| created_at | time | Filter by the date and time when the order was created in Shopify's system. | - created_at:'2020-10-21T23:39:20Z'- created_at:<now- created_at:<=2024 |
||
| credit_card_last4 | string | Filter by the last four digits of the payment card that was used to pay for the order. This filter matches only the last four digits of the card for heightened security. | - credit_card_last4:1234 |
||
| current_total_price | float | Filter by the current total price of the order in the shop currency, including any returns/refunds/removals. This filter supports both exact values and ranges. | - current_total_price:10- current_total_price:>=5.00 current_total_price:<=20.99 |
||
| customer_id | id | Filter orders by the customer id field. |
- customer_id:123 |
||
| delivery_method | string | Filter by the delivery methodType field. |
- shipping- pick-up- retail- local- pickup-point- none |
- delivery_method:shipping |
|
| discount_code | string | Filter by the case-insensitive discount code that was applied to the order at checkout. Limited to the first discount code used on an order. Maximum characters: 255. | - discount_code:ABC123 |
||
| string | Filter by the email address that's associated with the order to provide customer support or analyze purchasing patterns. | - email:example@shopify.com |
|||
| financial_status | string | Filter by the order displayFinancialStatus field. |
- paid- pending- authorized- partially_paid- partially_refunded- refunded- voided- expired |
- financial_status:authorized |
|
| fraud_protection_level | string | Filter by the level of fraud protection that's applied to the order. Use this filter to manage risk or handle disputes. | - fully_protected- partially_protected- not_protected- pending- not_eligible- not_available |
- fraud_protection_level:fully_protected |
|
| fulfillment_location_id | id | Filter by the fulfillment location id (Fulfillment.location.id) field. |
- fulfillment_location_id:123 |
||
| fulfillment_status | string | Filter by the displayFulfillmentStatus field to prioritize shipments or monitor order processing. |
- unshipped- shipped- fulfilled- partial- scheduled- on_hold- unfulfilled- request_declined |
- fulfillment_status:fulfilled |
|
| gateway | string | Filter by the paymentGatewayNames field. Use this filter to find orders that were processed through specific payment providers like Shopify Payments, PayPal, or other custom payment gateways. |
- gateway:shopify_payments |
||
| id | id | Filter by id range. |
- id:1234- id:>=1234- id:<=1234 |
||
| location_id | id | Filter by the location id that's associated with the order to view and manage orders for specific locations. For POS orders, locations must be defined in the Shopify admin under Settings > Locations. If no ID is provided, then the primary location of the shop is returned. |
- location_id:123 |
||
| metafields.{namespace}.{key} | mixed | Filters resources by metafield value. Format: metafields.{namespace}.{key}:{value}. Learn more about querying by metafield value. |
- metafields.custom.on_sale:true- metafields.product.material:"gid://shopify/Metaobject/43458085" |
||
| name | string | Filter by the order name field. |
- name:1001-A |
||
| payment_id | string | Filter by the payment ID that's associated with the order to reconcile financial records or troubleshoot payment issues. | - payment_id:abc123 |
||
| payment_provider_id | id | Filter by the ID of the payment provider that's associated with the order to manage payment methods or troubleshoot transactions. | - payment_provider_id:123 |
||
| po_number | string | Filter by the order poNumber field. |
- po_number:P01001 |
||
| processed_at | time | Filter by the order processedAt field. |
- processed_at:'2021-01-01T00:00:00Z' |
||
| reference_location_id | id | Filter by the ID of a location that's associated with the order, such as locations from fulfillments, refunds, or the shop's primary location. | - reference_location_id:123 |
||
| requested_order_edit_status | string | Filter by the order's displayRequestedEditStatus to track which orders have buyer-initiated requested order edits pending merchant action. |
- none- requested- resolved- declined |
- requested_order_edit_status:requested |
|
| return_status | string | Filter by the order's returnStatus to monitor returns processing and track which orders have active returns. |
- return_requested- in_progress- inspection_complete- returned- return_failed- no_return |
- return_status:in_progress |
|
| risk_level | string | Filter by the order risk assessment riskLevel field. |
- high- medium- low- none- pending |
- risk_level:high |
|
| sales_channel | string | Filter by the sales channel where the order was made to analyze performance or manage fulfillment processes. | - sales_channel: some_sales_channel |
||
| shipping_address_validation_result_summary | string | Filter by the validation status of the shipping address. Learn more about validating addresses. | - has_issues- no_issues- not_validated |
- shipping_address_validation_result_summary:no_issues |
|
| sku | string | Filter by the product variant sku field. Learn more about SKUs. |
- sku:ABC123 |
||
| source_identifier | string | Filter by the ID of the order placed on the originating platform, such as a unique POS or third-party identifier. This value doesn't correspond to the Shopify ID that's generated from a completed draft order. | - source_identifier:1234-12-1000 |
||
| source_name | string | Filter by the platform where the order was placed to distinguish between web orders, POS sales, draft orders, or third-party channels. Use this filter to analyze sales performance across different ordering methods. | - source_name:web- source_name:shopify_draft_order |
||
| status | string | Filter by the order's status to manage workflows or analyze the order lifecycle. | - open- closed- cancelled- not_closed |
- status:open |
|
| subtotal_line_items_quantity | string | Filter by the total number of items across all line items in an order. This filter supports both exact values and ranges, and is useful for identifying bulk orders or analyzing purchase volume patterns. | - subtotal_line_items_quantity:10- subtotal_line_items_quantity:5..20 |
||
| tag | string | Filter objects by the tag field. |
- tag:my_tag |
||
| tag_not | string | Filter by objects that don’t have the specified tag. | - tag_not:my_tag |
||
| test | boolean | Filter by test orders. Test orders are made using the Shopify Bogus Gateway or a payment provider with test mode enabled. | - test:true |
||
| total_weight | string | Filter by the order weight. This filter supports both exact values and ranges, and is to be used to filter orders by the total weight of all items (excluding packaging). It takes a unit of measurement as a suffix. It accepts the following units: g, kg, lb, oz. | - total_weight:10.5kg- total_weight:>=5g total_weight:<=20g- total_weight:.5 lb |
||
| updated_at | time | Filter by the date and time when the order was last updated in Shopify's system. | - updated_at:'2020-10-21T23:39:20Z'- updated_at:<now- updated_at:<=2024 |
||
| You can apply one or more filters to a query. Learn more about Shopify API search syntax. |
A list of the customer's orders.
OrderConnection!first: Int - The first n elements from the paginated list.
after: String - The elements that come after the specified cursor.
last: Int - The last n elements from the paginated list.
before: String - The elements that come before the specified cursor.
reverse: Boolean - Reverse the order of the underlying list.
sortKey: OrderSortKeys - Sort the underlying list using a key. If your query is slow or returns an error, then try specifying a sort key that matches the field used in the search.
query: String - A filter made up of terms, connectives, modifiers, and comparators.
| name | type | description | acceptable_values | default_value | example_use |
|---|---|---|---|---|---|
| default | string | Filter by a case-insensitive search of multiple fields in a document. | - query=Bob Norman- query=title:green hoodie |
||
| cart_token | string | Filter by the cart token's unique value to track abandoned cart conversions or troubleshoot checkout issues. The token references the cart that's associated with an order. | - cart_token:abc123 |
||
| channel | string | Filter by the order attribution handle (Order.attribution.handle) field. The legacy channel information handle (ChannelInformation.channelDefinition.handle) field is deprecated but remains supported during the deprecation period. |
- channel:web- channel:web,pos |
||
| channel_id | id | Filter by the channel id field. |
- channel_id:123 |
||
| chargeback_status | string | Filter by the order's chargeback status. A chargeback occurs when a customer questions the legitimacy of a charge with their financial institution. | - accepted- charge_refunded- lost- needs_response- prevented- under_review- won |
- chargeback_status:accepted |
|
| checkout_token | string | Filter by the checkout token's unique value to analyze conversion funnels or resolve payment issues. The checkout token's value references the checkout that's associated with an order. | - checkout_token:abc123 |
||
| confirmation_number | string | Filter by the randomly generated alpha-numeric identifier for an order that can be displayed to the customer instead of the sequential order name. This value isn't guaranteed to be unique. | - confirmation_number:ABC123 |
||
| created_at | time | Filter by the date and time when the order was created in Shopify's system. | - created_at:'2020-10-21T23:39:20Z'- created_at:<now- created_at:<=2024 |
||
| credit_card_last4 | string | Filter by the last four digits of the payment card that was used to pay for the order. This filter matches only the last four digits of the card for heightened security. | - credit_card_last4:1234 |
||
| current_total_price | float | Filter by the current total price of the order in the shop currency, including any returns/refunds/removals. This filter supports both exact values and ranges. | - current_total_price:10- current_total_price:>=5.00 current_total_price:<=20.99 |
||
| customer_id | id | Filter orders by the customer id field. |
- customer_id:123 |
||
| delivery_method | string | Filter by the delivery methodType field. |
- shipping- pick-up- retail- local- pickup-point- none |
- delivery_method:shipping |
|
| discount_code | string | Filter by the case-insensitive discount code that was applied to the order at checkout. Limited to the first discount code used on an order. Maximum characters: 255. | - discount_code:ABC123 |
||
| string | Filter by the email address that's associated with the order to provide customer support or analyze purchasing patterns. | - email:example@shopify.com |
|||
| financial_status | string | Filter by the order displayFinancialStatus field. |
- paid- pending- authorized- partially_paid- partially_refunded- refunded- voided- expired |
- financial_status:authorized |
|
| fraud_protection_level | string | Filter by the level of fraud protection that's applied to the order. Use this filter to manage risk or handle disputes. | - fully_protected- partially_protected- not_protected- pending- not_eligible- not_available |
- fraud_protection_level:fully_protected |
|
| fulfillment_location_id | id | Filter by the fulfillment location id (Fulfillment.location.id) field. |
- fulfillment_location_id:123 |
||
| fulfillment_status | string | Filter by the displayFulfillmentStatus field to prioritize shipments or monitor order processing. |
- unshipped- shipped- fulfilled- partial- scheduled- on_hold- unfulfilled- request_declined |
- fulfillment_status:fulfilled |
|
| gateway | string | Filter by the paymentGatewayNames field. Use this filter to find orders that were processed through specific payment providers like Shopify Payments, PayPal, or other custom payment gateways. |
- gateway:shopify_payments |
||
| id | id | Filter by id range. |
- id:1234- id:>=1234- id:<=1234 |
||
| location_id | id | Filter by the location id that's associated with the order to view and manage orders for specific locations. For POS orders, locations must be defined in the Shopify admin under Settings > Locations. If no ID is provided, then the primary location of the shop is returned. |
- location_id:123 |
||
| metafields.{namespace}.{key} | mixed | Filters resources by metafield value. Format: metafields.{namespace}.{key}:{value}. Learn more about querying by metafield value. |
- metafields.custom.on_sale:true- metafields.product.material:"gid://shopify/Metaobject/43458085" |
||
| name | string | Filter by the order name field. |
- name:1001-A |
||
| payment_id | string | Filter by the payment ID that's associated with the order to reconcile financial records or troubleshoot payment issues. | - payment_id:abc123 |
||
| payment_provider_id | id | Filter by the ID of the payment provider that's associated with the order to manage payment methods or troubleshoot transactions. | - payment_provider_id:123 |
||
| po_number | string | Filter by the order poNumber field. |
- po_number:P01001 |
||
| processed_at | time | Filter by the order processedAt field. |
- processed_at:'2021-01-01T00:00:00Z' |
||
| reference_location_id | id | Filter by the ID of a location that's associated with the order, such as locations from fulfillments, refunds, or the shop's primary location. | - reference_location_id:123 |
||
| requested_order_edit_status | string | Filter by the order's displayRequestedEditStatus to track which orders have buyer-initiated requested order edits pending merchant action. |
- none- requested- resolved- declined |
- requested_order_edit_status:requested |
|
| return_status | string | Filter by the order's returnStatus to monitor returns processing and track which orders have active returns. |
- return_requested- in_progress- inspection_complete- returned- return_failed- no_return |
- return_status:in_progress |
|
| risk_level | string | Filter by the order risk assessment riskLevel field. |
- high- medium- low- none- pending |
- risk_level:high |
|
| sales_channel | string | Filter by the sales channel where the order was made to analyze performance or manage fulfillment processes. | - sales_channel: some_sales_channel |
||
| shipping_address_validation_result_summary | string | Filter by the validation status of the shipping address. Learn more about validating addresses. | - has_issues- no_issues- not_validated |
- shipping_address_validation_result_summary:no_issues |
|
| sku | string | Filter by the product variant sku field. Learn more about SKUs. |
- sku:ABC123 |
||
| source_identifier | string | Filter by the ID of the order placed on the originating platform, such as a unique POS or third-party identifier. This value doesn't correspond to the Shopify ID that's generated from a completed draft order. | - source_identifier:1234-12-1000 |
||
| source_name | string | Filter by the platform where the order was placed to distinguish between web orders, POS sales, draft orders, or third-party channels. Use this filter to analyze sales performance across different ordering methods. | - source_name:web- source_name:shopify_draft_order |
||
| status | string | Filter by the order's status to manage workflows or analyze the order lifecycle. | - open- closed- cancelled- not_closed |
- status:open |
|
| subtotal_line_items_quantity | string | Filter by the total number of items across all line items in an order. This filter supports both exact values and ranges, and is useful for identifying bulk orders or analyzing purchase volume patterns. | - subtotal_line_items_quantity:10- subtotal_line_items_quantity:5..20 |
||
| tag | string | Filter objects by the tag field. |
- tag:my_tag |
||
| tag_not | string | Filter by objects that don’t have the specified tag. | - tag_not:my_tag |
||
| test | boolean | Filter by test orders. Test orders are made using the Shopify Bogus Gateway or a payment provider with test mode enabled. | - test:true |
||
| total_weight | string | Filter by the order weight. This filter supports both exact values and ranges, and is to be used to filter orders by the total weight of all items (excluding packaging). It takes a unit of measurement as a suffix. It accepts the following units: g, kg, lb, oz. | - total_weight:10.5kg- total_weight:>=5g total_weight:<=20g- total_weight:.5 lb |
||
| updated_at | time | Filter by the date and time when the order was last updated in Shopify's system. | - updated_at:'2020-10-21T23:39:20Z'- updated_at:<now- updated_at:<=2024 |
||
| You can apply one or more filters to a query. Learn more about Shopify API search syntax. |
inventoryBinItemsA paginated list of the inventory items stored in this bin and their quantities.
MARKETED_RESOURCES_NOT_SUPPORTED_FOR_STOREFRONT_APPmarketedResourcesThe resources that this marketing activity advertises, in the order they were added.
ordersorders on ShopA list of the shop's orders.
OrderConnection!first: Int - The first n elements from the paginated list.
after: String - The elements that come after the specified cursor.
last: Int - The last n elements from the paginated list.
before: String - The elements that come before the specified cursor.
reverse: Boolean - Reverse the order of the underlying list.
sortKey: OrderSortKeys - Sort the underlying list using a key. If your query is slow or returns an error, then try specifying a sort key that matches the field used in the search.
query: String - A filter made up of terms, connectives, modifiers, and comparators.
| name | type | description | acceptable_values | default_value | example_use |
|---|---|---|---|---|---|
| default | string | Filter by a case-insensitive search of multiple fields in a document. | - query=Bob Norman- query=title:green hoodie |
||
| cart_token | string | Filter by the cart token's unique value to track abandoned cart conversions or troubleshoot checkout issues. The token references the cart that's associated with an order. | - cart_token:abc123 |
||
| channel | string | Filter by the order attribution handle (Order.attribution.handle) field. The legacy channel information handle (ChannelInformation.channelDefinition.handle) field is deprecated but remains supported during the deprecation period. |
- channel:web- channel:web,pos |
||
| channel_id | id | Filter by the channel id field. |
- channel_id:123 |
||
| chargeback_status | string | Filter by the order's chargeback status. A chargeback occurs when a customer questions the legitimacy of a charge with their financial institution. | - accepted- charge_refunded- lost- needs_response- under_review- won |
- chargeback_status:accepted |
|
| checkout_token | string | Filter by the checkout token's unique value to analyze conversion funnels or resolve payment issues. The checkout token's value references the checkout that's associated with an order. | - checkout_token:abc123 |
||
| confirmation_number | string | Filter by the randomly generated alpha-numeric identifier for an order that can be displayed to the customer instead of the sequential order name. This value isn't guaranteed to be unique. | - confirmation_number:ABC123 |
||
| created_at | time | Filter by the date and time when the order was created in Shopify's system. | - created_at:'2020-10-21T23:39:20Z'- created_at:<now- created_at:<=2024 |
||
| credit_card_last4 | string | Filter by the last four digits of the payment card that was used to pay for the order. This filter matches only the last four digits of the card for heightened security. | - credit_card_last4:1234 |
||
| current_total_price | float | Filter by the current total price of the order in the shop currency, including any returns/refunds/removals. This filter supports both exact values and ranges. | - current_total_price:10- current_total_price:>=5.00 current_total_price:<=20.99 |
||
| customer_id | id | Filter orders by the customer id field. |
- customer_id:123 |
||
| delivery_method | string | Filter by the delivery methodType field. |
- shipping- pick-up- retail- local- pickup-point- none |
- delivery_method:shipping |
|
| discount_code | string | Filter by the case-insensitive discount code that was applied to the order at checkout. Limited to the first discount code used on an order. Maximum characters: 255. | - discount_code:ABC123 |
||
| string | Filter by the email address that's associated with the order to provide customer support or analyze purchasing patterns. | - email:example@shopify.com |
|||
| financial_status | string | Filter by the order displayFinancialStatus field. |
- paid- pending- authorized- partially_paid- partially_refunded- refunded- voided- expired |
- financial_status:authorized |
|
| fraud_protection_level | string | Filter by the level of fraud protection that's applied to the order. Use this filter to manage risk or handle disputes. | - fully_protected- partially_protected- not_protected- pending- not_eligible- not_available |
- fraud_protection_level:fully_protected |
|
| fulfillment_location_id | id | Filter by the fulfillment location id (Fulfillment.location.id) field. |
- fulfillment_location_id:123 |
||
| fulfillment_status | string | Filter by the displayFulfillmentStatus field to prioritize shipments or monitor order processing. |
- unshipped- shipped- fulfilled- partial- scheduled- on_hold- unfulfilled- request_declined |
- fulfillment_status:fulfilled |
|
| gateway | string | Filter by the paymentGatewayNames field. Use this filter to find orders that were processed through specific payment providers like Shopify Payments, PayPal, or other custom payment gateways. |
- gateway:shopify_payments |
||
| id | id | Filter by id range. |
- id:1234- id:>=1234- id:<=1234 |
||
| location_id | id | Filter by the location id that's associated with the order to view and manage orders for specific locations. For POS orders, locations must be defined in the Shopify admin under Settings > Locations. If no ID is provided, then the primary location of the shop is returned. |
- location_id:123 |
||
| metafields.{namespace}.{key} | mixed | Filters resources by metafield value. Format: metafields.{namespace}.{key}:{value}. Learn more about querying by metafield value. |
- metafields.custom.on_sale:true- metafields.product.material:"gid://shopify/Metaobject/43458085" |
||
| name | string | Filter by the order name field. |
- name:1001-A |
||
| payment_id | string | Filter by the payment ID that's associated with the order to reconcile financial records or troubleshoot payment issues. | - payment_id:abc123 |
||
| payment_provider_id | id | Filter by the ID of the payment provider that's associated with the order to manage payment methods or troubleshoot transactions. | - payment_provider_id:123 |
||
| po_number | string | Filter by the order poNumber field. |
- po_number:P01001 |
||
| processed_at | time | Filter by the order processedAt field. |
- processed_at:'2021-01-01T00:00:00Z' |
||
| reference_location_id | id | Filter by the ID of a location that's associated with the order, such as locations from fulfillments, refunds, or the shop's primary location. | - reference_location_id:123 |
||
| requested_order_edit_status | string | Filter by the order's displayRequestedEditStatus to track which orders have buyer-initiated requested order edits pending merchant action. |
- none- requested- resolved- declined |
- requested_order_edit_status:requested |
|
| return_status | string | Filter by the order's returnStatus to monitor returns processing and track which orders have active returns. |
- return_requested- in_progress- inspection_complete- returned- return_failed- no_return |
- return_status:in_progress |
|
| risk_level | string | Filter by the order risk assessment riskLevel field. |
- high- medium- low- none- pending |
- risk_level:high |
|
| sales_channel | string | Filter by the sales channel where the order was made to analyze performance or manage fulfillment processes. | - sales_channel: some_sales_channel |
||
| shipping_address_validation_result_summary | string | Filter by the validation status of the shipping address. Learn more about validating addresses. | - has_issues- no_issues- not_validated |
- shipping_address_validation_result_summary:no_issues |
|
| sku | string | Filter by the product variant sku field. Learn more about SKUs. |
- sku:ABC123 |
||
| source_identifier | string | Filter by the ID of the order placed on the originating platform, such as a unique POS or third-party identifier. This value doesn't correspond to the Shopify ID that's generated from a completed draft order. | - source_identifier:1234-12-1000 |
||
| source_name | string | Filter by the platform where the order was placed to distinguish between web orders, POS sales, draft orders, or third-party channels. Use this filter to analyze sales performance across different ordering methods. | - source_name:web- source_name:shopify_draft_order |
||
| status | string | Filter by the order's status to manage workflows or analyze the order lifecycle. | - open- closed- cancelled- not_closed |
- status:open |
|
| subtotal_line_items_quantity | string | Filter by the total number of items across all line items in an order. This filter supports both exact values and ranges, and is useful for identifying bulk orders or analyzing purchase volume patterns. | - subtotal_line_items_quantity:10- subtotal_line_items_quantity:5..20 |
||
| tag | string | Filter objects by the tag field. |
- tag:my_tag |
||
| tag_not | string | Filter by objects that don’t have the specified tag. | - tag_not:my_tag |
||
| test | boolean | Filter by test orders. Test orders are made using the Shopify Bogus Gateway or a payment provider with test mode enabled. | - test:true |
||
| total_weight | string | Filter by the order weight. This filter supports both exact values and ranges, and is to be used to filter orders by the total weight of all items (excluding packaging). It takes a unit of measurement as a suffix. It accepts the following units: g, kg, lb, oz. | - total_weight:10.5kg- total_weight:>=5g total_weight:<=20g- total_weight:.5 lb |
||
| updated_at | time | Filter by the date and time when the order was last updated in Shopify's system. | - updated_at:'2020-10-21T23:39:20Z'- updated_at:<now- updated_at:<=2024 |
||
| You can apply one or more filters to a query. Learn more about Shopify API search syntax. |
A list of the shop's orders.
OrderConnection!first: Int - The first n elements from the paginated list.
after: String - The elements that come after the specified cursor.
last: Int - The last n elements from the paginated list.
before: String - The elements that come before the specified cursor.
reverse: Boolean - Reverse the order of the underlying list.
sortKey: OrderSortKeys - Sort the underlying list using a key. If your query is slow or returns an error, then try specifying a sort key that matches the field used in the search.
query: String - A filter made up of terms, connectives, modifiers, and comparators.
| name | type | description | acceptable_values | default_value | example_use |
|---|---|---|---|---|---|
| default | string | Filter by a case-insensitive search of multiple fields in a document. | - query=Bob Norman- query=title:green hoodie |
||
| cart_token | string | Filter by the cart token's unique value to track abandoned cart conversions or troubleshoot checkout issues. The token references the cart that's associated with an order. | - cart_token:abc123 |
||
| channel | string | Filter by the order attribution handle (Order.attribution.handle) field. The legacy channel information handle (ChannelInformation.channelDefinition.handle) field is deprecated but remains supported during the deprecation period. |
- channel:web- channel:web,pos |
||
| channel_id | id | Filter by the channel id field. |
- channel_id:123 |
||
| chargeback_status | string | Filter by the order's chargeback status. A chargeback occurs when a customer questions the legitimacy of a charge with their financial institution. | - accepted- charge_refunded- lost- needs_response- prevented- under_review- won |
- chargeback_status:accepted |
|
| checkout_token | string | Filter by the checkout token's unique value to analyze conversion funnels or resolve payment issues. The checkout token's value references the checkout that's associated with an order. | - checkout_token:abc123 |
||
| confirmation_number | string | Filter by the randomly generated alpha-numeric identifier for an order that can be displayed to the customer instead of the sequential order name. This value isn't guaranteed to be unique. | - confirmation_number:ABC123 |
||
| created_at | time | Filter by the date and time when the order was created in Shopify's system. | - created_at:'2020-10-21T23:39:20Z'- created_at:<now- created_at:<=2024 |
||
| credit_card_last4 | string | Filter by the last four digits of the payment card that was used to pay for the order. This filter matches only the last four digits of the card for heightened security. | - credit_card_last4:1234 |
||
| current_total_price | float | Filter by the current total price of the order in the shop currency, including any returns/refunds/removals. This filter supports both exact values and ranges. | - current_total_price:10- current_total_price:>=5.00 current_total_price:<=20.99 |
||
| customer_id | id | Filter orders by the customer id field. |
- customer_id:123 |
||
| delivery_method | string | Filter by the delivery methodType field. |
- shipping- pick-up- retail- local- pickup-point- none |
- delivery_method:shipping |
|
| discount_code | string | Filter by the case-insensitive discount code that was applied to the order at checkout. Limited to the first discount code used on an order. Maximum characters: 255. | - discount_code:ABC123 |
||
| string | Filter by the email address that's associated with the order to provide customer support or analyze purchasing patterns. | - email:example@shopify.com |
|||
| financial_status | string | Filter by the order displayFinancialStatus field. |
- paid- pending- authorized- partially_paid- partially_refunded- refunded- voided- expired |
- financial_status:authorized |
|
| fraud_protection_level | string | Filter by the level of fraud protection that's applied to the order. Use this filter to manage risk or handle disputes. | - fully_protected- partially_protected- not_protected- pending- not_eligible- not_available |
- fraud_protection_level:fully_protected |
|
| fulfillment_location_id | id | Filter by the fulfillment location id (Fulfillment.location.id) field. |
- fulfillment_location_id:123 |
||
| fulfillment_status | string | Filter by the displayFulfillmentStatus field to prioritize shipments or monitor order processing. |
- unshipped- shipped- fulfilled- partial- scheduled- on_hold- unfulfilled- request_declined |
- fulfillment_status:fulfilled |
|
| gateway | string | Filter by the paymentGatewayNames field. Use this filter to find orders that were processed through specific payment providers like Shopify Payments, PayPal, or other custom payment gateways. |
- gateway:shopify_payments |
||
| id | id | Filter by id range. |
- id:1234- id:>=1234- id:<=1234 |
||
| location_id | id | Filter by the location id that's associated with the order to view and manage orders for specific locations. For POS orders, locations must be defined in the Shopify admin under Settings > Locations. If no ID is provided, then the primary location of the shop is returned. |
- location_id:123 |
||
| metafields.{namespace}.{key} | mixed | Filters resources by metafield value. Format: metafields.{namespace}.{key}:{value}. Learn more about querying by metafield value. |
- metafields.custom.on_sale:true- metafields.product.material:"gid://shopify/Metaobject/43458085" |
||
| name | string | Filter by the order name field. |
- name:1001-A |
||
| payment_id | string | Filter by the payment ID that's associated with the order to reconcile financial records or troubleshoot payment issues. | - payment_id:abc123 |
||
| payment_provider_id | id | Filter by the ID of the payment provider that's associated with the order to manage payment methods or troubleshoot transactions. | - payment_provider_id:123 |
||
| po_number | string | Filter by the order poNumber field. |
- po_number:P01001 |
||
| processed_at | time | Filter by the order processedAt field. |
- processed_at:'2021-01-01T00:00:00Z' |
||
| reference_location_id | id | Filter by the ID of a location that's associated with the order, such as locations from fulfillments, refunds, or the shop's primary location. | - reference_location_id:123 |
||
| requested_order_edit_status | string | Filter by the order's displayRequestedEditStatus to track which orders have buyer-initiated requested order edits pending merchant action. |
- none- requested- resolved- declined |
- requested_order_edit_status:requested |
|
| return_status | string | Filter by the order's returnStatus to monitor returns processing and track which orders have active returns. |
- return_requested- in_progress- inspection_complete- returned- return_failed- no_return |
- return_status:in_progress |
|
| risk_level | string | Filter by the order risk assessment riskLevel field. |
- high- medium- low- none- pending |
- risk_level:high |
|
| sales_channel | string | Filter by the sales channel where the order was made to analyze performance or manage fulfillment processes. | - sales_channel: some_sales_channel |
||
| shipping_address_validation_result_summary | string | Filter by the validation status of the shipping address. Learn more about validating addresses. | - has_issues- no_issues- not_validated |
- shipping_address_validation_result_summary:no_issues |
|
| sku | string | Filter by the product variant sku field. Learn more about SKUs. |
- sku:ABC123 |
||
| source_identifier | string | Filter by the ID of the order placed on the originating platform, such as a unique POS or third-party identifier. This value doesn't correspond to the Shopify ID that's generated from a completed draft order. | - source_identifier:1234-12-1000 |
||
| source_name | string | Filter by the platform where the order was placed to distinguish between web orders, POS sales, draft orders, or third-party channels. Use this filter to analyze sales performance across different ordering methods. | - source_name:web- source_name:shopify_draft_order |
||
| status | string | Filter by the order's status to manage workflows or analyze the order lifecycle. | - open- closed- cancelled- not_closed |
- status:open |
|
| subtotal_line_items_quantity | string | Filter by the total number of items across all line items in an order. This filter supports both exact values and ranges, and is useful for identifying bulk orders or analyzing purchase volume patterns. | - subtotal_line_items_quantity:10- subtotal_line_items_quantity:5..20 |
||
| tag | string | Filter objects by the tag field. |
- tag:my_tag |
||
| tag_not | string | Filter by objects that don’t have the specified tag. | - tag_not:my_tag |
||
| test | boolean | Filter by test orders. Test orders are made using the Shopify Bogus Gateway or a payment provider with test mode enabled. | - test:true |
||
| total_weight | string | Filter by the order weight. This filter supports both exact values and ranges, and is to be used to filter orders by the total weight of all items (excluding packaging). It takes a unit of measurement as a suffix. It accepts the following units: g, kg, lb, oz. | - total_weight:10.5kg- total_weight:>=5g total_weight:<=20g- total_weight:.5 lb |
||
| updated_at | time | Filter by the date and time when the order was last updated in Shopify's system. | - updated_at:'2020-10-21T23:39:20Z'- updated_at:<now- updated_at:<=2024 |
||
| You can apply one or more filters to a query. Learn more about Shopify API search syntax. |