Filter Orders
Migrato allows you to export specific Shopify orders by applying filters before starting an export. This is especially useful when working with a large number of orders and you only want to export orders that match specific criteria.
You can filter orders using order information such as ID, name, dates, tags, status, payment status, fulfillment status, discount code, payment gateway, source, customer information, billing and shipping country, line-item information, fulfillment dates, and refund dates.
How to Filter Orders for Export
Follow these steps to export orders based on specific conditions.
Step 1: Open Order Export
- Open Shopify Admin.
- Go to Apps → Migrato.
- Open the Export section.
- Select Orders as the entity you want to export.
Step 2: Select Order Fields
Select the order fields and information you want to include in the export file.
Choose the required fields based on your order export requirements.
Step 3: Add Order Filters
Open the Filters section and click Add New Filter.
- Select the order field you want to use for filtering.
- Select the condition available for the selected field.
- Enter or select the required filter value.
- Add additional filters if required.
Migrato provides filters for order-level, customer, billing, shipping, line-item, fulfillment, and refund information.
Step 4: Review the Filters
Review all selected filter conditions before starting the export.
For example, you can create an order export using:
-
Status = Open
-
Payment Status = Paid
-
Shipping: Country Code = US
You can also filter orders using information such as:
-
Order ID or Name
-
Created At, Updated At, or Processed At
-
Tags
-
Payment Gateway
-
Discount Code
-
Fulfillment Status
-
Customer Tax Exempt status
-
Billing or Shipping Country Code
-
Line Item SKU, Title, Name, Vendor, or Variant Title
-
Fulfillment dates
-
Refund dates
Tip: When using multiple filters, review each condition carefully to make sure the resulting export contains the orders you need.
Step 5: Start the Export
Once the filters have been configured:
- Review the selected order fields.
- Review all filter conditions.
- Confirm the export settings.
- Start the export.
Migrato will process the order export based on the selected filter conditions.
Only orders matching the configured filter criteria will be included in the resulting export.
Note: The available filter conditions depend on the selected order field. For the complete list of supported order filters and conditions, refer to Available Order Filters and Filter Conditions.
Available Order Filters
The available filters depend on the order fields supported by Migrato and the conditions available for each selected field.
| Filter | Description | Available Conditions |
|---|---|---|
| ID | Filter orders using their Shopify order ID. Multiple IDs can be entered where supported. | Equals to any of; Not equal to any of |
| Name | Filter orders based on the order name or order number. | Equals to any of; Not equal to any of; Contains any; Contains none |
| Created At | Filter orders based on the date and time when the order was created. | On or after; On or before; Date range; Relative date |
| Updated At | Filter orders based on the date and time when the order was last updated. | On or after; On or before; Date range; Relative date |
| Processed At | Filter orders based on the date and time when the order was processed. | On or after; On or before; Date range; Relative date |
| Tags | Filter orders based on their assigned order tags. | Equals to any of; Not equal to any of |
| Status | Filter orders based on their Shopify order status. | Equals to any of; Not equal to any of |
| Payment Status | Filter orders based on the payment status of the order. | Equals to any of; Not equal to any of |
| Fulfillment Status | Filter orders based on the fulfillment status of the order. | Equals to any of; Not equal to any of |
| Discount Code | Filter orders based on the discount code applied to the order. | Equals to any of; Not equal to any of; Contains any; Contains none |
| Payment Gateway | Filter orders based on the payment gateway used for the order. | Equals to any of; Not equal to any of; Contains any; Contains none |
| Source | Filter orders based on the source associated with the order. | Equals to any of; Not equal to any of; Contains any; Contains none |
| Customer: Tax Exempt | Filter orders based on whether the associated customer is tax exempt. | Yes; No |
| Billing: Country Code | Filter orders based on the billing address country code. | Equals to any of; Not equal to any of |
| Shipping: Country Code | Filter orders based on the shipping address country code. | Equals to any of; Not equal to any of |
| Line: Type | Filter orders based on the type of an order line item. | Equals to any of; Not equal to any of; Contains any; Contains none |
| Line: Title | Filter orders based on the title of an order line item. | Equals to any of; Not equal to any of; Contains any; Contains none |
| Line: Name | Filter orders based on the name of an order line item. | Equals to any of; Not equal to any of; Contains any; Contains none |
| Line: Variant Title | Filter orders based on the variant title associated with an order line item. | Equals to any of; Not equal to any of; Contains any; Contains none |
| Line: Vendor | Filter orders based on the vendor associated with an order line item. | Equals to any of; Not equal to any of; Contains any; Contains none |
| Line: SKU | Filter orders based on the SKU of an order line item. | Equals to any of; Not equal to any of; Contains any; Contains none |
| Fulfillment: Created At | Filter orders based on the creation date of the associated fulfillment. | On or after; On or before; Date range; Relative date |
| Fulfillment: Updated At | Filter orders based on the last update date of the associated fulfillment. | On or after; On or before; Date range; Relative date |
| Refund: Created At | Filter orders based on the creation date of an associated refund. | On or after; On or before; Date range; Relative date |
Note: The filter fields above are based on the Order Filter dropdown options provided in Migrato. The exact condition options for each field should match the conditions configured in the current Migrato implementation.
Filter Conditions
Migrato provides different conditions depending on the selected order field.
After selecting a filter field, Migrato displays the conditions available for that particular field.
The available conditions depend on the type of field selected. For example, date-based fields such as Created At, Updated At, Processed At, Fulfillment: Created At, Fulfillment: Updated At, and Refund: Created At may provide date-related conditions, while text-based fields may provide text or matching conditions.
Text-Based Conditions
| Condition | Description |
|---|---|
| Equals to any of | Exports orders where the selected field matches any of the specified values. |
| Not equal to any of | Exports orders where the selected field does not match any of the specified values. |
| Contains any | Exports orders where the selected field contains any of the specified values. |
| Contains none | Exports orders where the selected field does not contain any of the specified values. |
| Contains | Exports orders where the selected field contains the specified text. |
| Does not contain | Exports orders where the selected field does not contain the specified text. |
Date-Based Conditions
| Condition | Description |
|---|---|
| On or after | Exports orders where the selected date field is on or after the specified date. |
| On or before | Exports orders where the selected date field is on or before the specified date. |
| Date range | Exports orders where the selected date field falls within the specified date range. |
| Relative date | Exports orders based on a relative time period, such as the last few days, weeks, or months. |
Date-based conditions can be used with supported fields such as Created At, Updated At, Processed At, Fulfillment:created At, Fulfillment:Updated At, and Refund:created At.
Status Conditions
| Condition | Description |
|---|---|
| Status value | Exports orders that match the selected order status. |
| Payment status value | Exports orders that match the selected payment status. |
| Fulfillment status value | Exports orders that match the selected fulfillment status. |
Status-related conditions can be used with supported order status fields such as Status, Payment Status, and Fulfillment Status.
Note: The available status values depend on the selected status field and the values supported by the current Migrato implementation.
Boolean Conditions
| Condition | Description |
|---|---|
| Yes | Exports orders where the selected setting is enabled or true. |
| No | Exports orders where the selected setting is disabled or false. |
Boolean conditions can be used with supported Yes/No or true/false fields, such as Customer: Tax Exempt.
Numeric Conditions
| Condition | Description |
|---|---|
| Equals | Exports orders where the numerical value exactly matches the specified value. |
| Less than | Exports orders where the numerical value is lower than the specified value. |
| Less than or equal to | Exports orders where the numerical value is lower than or equal to the specified value. |
| Greater than | Exports orders where the numerical value is higher than the specified value. |
| Greater than or equal to | Exports orders where the numerical value is higher than or equal to the specified value. |
| Between | Exports orders where the numerical value falls between the specified minimum and maximum values. |
Numeric conditions can be used with supported numerical order fields.
Note: The exact conditions available for each order filter depend on the selected field and the current Migrato implementation.
Order Filter Examples
Example 1: Export Orders by Order ID
To export specific orders, select:
ID
Enter the order ID or IDs according to the available condition.
For example:
1234567890
9876543210
Migrato will include the orders matching the selected ID criteria.
Example 2: Export Orders by Order Status
You can filter orders based on their order status.
Select: Status
Then select the appropriate condition and status value available in Migrato.
This can be useful when you need to export a specific group of orders based on their current status.
Example 3: Export Orders by Payment Status
To export orders based on their payment status:
- Select Payment Status.
- Select the required condition.
- Select or enter the payment status value.
This can be useful when exporting orders based on their payment state.
Example 4: Export Orders by Fulfillment Status
To export orders based on fulfillment status:
Fulfillment Status
Select the required condition and value.
This can help you export orders that require fulfillment-related processing or reporting.
Example 5: Export Orders by Created Date
You can filter orders using the Created At field.
For example: Created At → [Available Date Condition]
Select the required date or date range according to the options provided by Migrato.
This is useful when exporting orders created during a specific period.
Example 6: Export Orders by Payment Gateway
To export orders processed through a specific payment gateway:
- Select Payment Gateway.
- Select the appropriate condition.
- Enter or select the required payment gateway.
Example 7: Export Orders by Discount Code
To export orders that use a particular discount code:
- Select Discount Code.
- Select the appropriate condition.
- Enter the discount code.
For example: SUMMER20
Example 8: Export Orders by Billing Country
You can filter orders according to the customer’s billing country.
Select: Billing: Country Code
For example: US
This can be useful when exporting orders for a specific country or region.
Example 9: Export Orders by Shipping Country
To export orders based on their shipping destination:
Shipping: Country Code
For example: IN
Example 10: Export Orders by Line Item SKU
You can filter orders based on the SKU of products included in the order.
Select: Line: SKU
Enter the required SKU value according to the available condition.
This can be useful when identifying orders containing a particular product or variant.
Example 11: Export Orders by Line Item Vendor
To export orders containing products from a specific vendor:
Line: Vendor
Enter or select the required vendor value.
Example 12: Export Orders by Fulfillment Date
You can filter orders using fulfillment dates.
Select either:
-
Fulfillment: Created At
-
Fulfillment: Updated At
Then apply the required date condition.
Example 13: Export Orders by Refund Date
To identify orders associated with refunds created during a particular period:
Refund: Created At
Select the required date condition and date value.
Screenshot: Migrato – Filter Orders by Refund Date
Using Multiple Order Filters
Migrato allows you to apply multiple filters to create a more targeted order export.
For example, you could combine:
-
Status
-
Payment Status
-
Shipping: Country Code
-
Line: SKU
This allows you to narrow the export to orders that match multiple requirements.
Tip: Before starting the export, review all selected filters carefully to make sure the resulting order dataset meets your requirements.
Important Notes
-
The available filter fields are based on the current Migrato Order Export functionality.
-
Filter conditions are displayed based on the selected field.
-
Date-related filters should be configured using the date conditions provided by Migrato.
-
Line-item filters can be useful for finding orders containing specific products, variants, SKUs, or vendors.
-
Multiple filters can be applied to narrow down the exported order data.
-
Always review the filters before starting a large export.