Our first app, Migrato, is live on the Shopify App Store - free plan, no credit card. Take a look
Home / Documentation / Filter Orders
Orders Import/Export

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.

Migrato – Order Export Filters
Migrato – Order Export Filters

How to Filter Orders for Export

Follow these steps to export orders based on specific conditions.

Step 1: Open Order Export

  1. Open Shopify Admin.
  2. Go to Apps → Migrato.
  3. Open the Export section.
  4. Select Orders as the entity you want to export.
Migrato – Order Export – Select Orders
Migrato – Order Export – Select Orders

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.

Migrato – Order Export – Select Fields
Migrato – Order Export – Select Fields

Step 3: Add Order Filters

Open the Filters section and click Add New Filter.

  1. Select the order field you want to use for filtering.
  2. Select the condition available for the selected field.
  3. Enter or select the required filter value.
  4. Add additional filters if required.

Migrato provides filters for order-level, customer, billing, shipping, line-item, fulfillment, and refund information.

Migrato – Order Export – Add Order Filter
Migrato – Order Export – Add Order Filter

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
Migrato – Order Export – Multiple Filters
Migrato – Order Export – Multiple Filters
i

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:

  1. Review the selected order fields.
  2. Review all filter conditions.
  3. Confirm the export settings.
  4. Start the export.

Migrato will process the order export based on the selected filter conditions.

Migrato – Order Export – Start Export
Migrato – Order Export – Start Export

Only orders matching the configured filter criteria will be included in the resulting export.

i

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
Migrato – Available Order Filter Fields
Migrato – Available Order Filter Fields
i

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.

Migrato – Order Filter Conditions
Migrato – Order Filter 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.

i

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.

i

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 – Filter Orders by ID
Migrato – Filter Orders by ID

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.

Migrato – Filter Orders by Status
Migrato – Filter Orders by Status

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:

  1. Select Payment Status.
  2. Select the required condition.
  3. Select or enter the payment status value.
Migrato – Filter Orders by Payment Status
Migrato – Filter Orders by Payment Status

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.

Migrato – Filter Orders by Fulfillment Status
Migrato – Filter Orders by Fulfillment Status

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.

Migrato – Filter Orders by Created At
Migrato – Filter Orders by Created At

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:

  1. Select Payment Gateway.
  2. Select the appropriate condition.
  3. Enter or select the required payment gateway.
Migrato – Filter Orders by Payment Gateway
Migrato – Filter Orders by Payment Gateway

Example 7: Export Orders by Discount Code

To export orders that use a particular discount code:

  1. Select Discount Code.
  2. Select the appropriate condition.
  3. Enter the discount code.

For example: SUMMER20

Migrato – Filter Orders by Discount Code
Migrato – Filter Orders by Discount Code

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

Migrato – Filter Orders by Billing Country
Migrato – Filter Orders by Billing Country

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

Migrato – Filter Orders by Shipping Country
Migrato – Filter Orders by Shipping Country

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.

Migrato – Filter Orders by Line Item SKU
Migrato – Filter Orders by Line Item SKU

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.

Migrato – Filter Orders by Line Item Vendor
Migrato – Filter Orders by Line Item Vendor

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.

Migrato – Filter Orders by Fulfillment Date
Migrato – Filter Orders by Fulfillment Date

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.

Migrato – Multiple Order Filters
Migrato – Multiple Order Filters
i

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.

Ready to run this on your own store?

Migrato's free plan handles 25 items per job - enough to follow any page in these docs end to end before you pay anything.

Free plan forever No credit card 2-minute setup Uninstall anytime