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

Filter Products

Migrato allows you to export specific Shopify products by applying filters before starting an export. This is especially useful when your store contains a large product catalog and you only need to export products that meet specific criteria.

You can filter products using information such as Product ID, Handle, Title, Vendor, Product Type, Tags, Status, Collections, Variant SKU, Variant Price, Variant Inventory Quantity, Barcode, and date-related fields.

You can also combine multiple filters to create a more targeted product export.

Migrato – Product Export Filters
Migrato – Product Export Filters

How to Filter Products for Export

Follow these steps to export products based on specific conditions.

Step 1: Open Product Export

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

Step 2: Select Product Fields

Select the product fields and information you want to include in the export file.

You can select the required fields based on your export requirements.

Migrato – Product Export – Select Fields
Migrato – Product Export – Select Fields

Step 3: Add Product Filters

Open the Filters section and click Add New Filter.

  1. Select the product field you want to filter.
  2. Select the required condition.
  3. Enter or select the value.
  4. Add additional filters if required.
Migrato – Product Export – Add Product Filter
Migrato – Product Export – Add Product Filter

Step 4: Review the Filters

Review all the selected filter conditions before starting the export.

For example, you can create an export using:

  • Vendor = Vendor A
  • Status = Active
  • Variant Inventory Quantity < 10

This allows you to export only the products matching the selected criteria.

Migrato – Product Export – Multiple Filters
Migrato – Product Export – Multiple Filters

Step 5: Start the Export

Once the filters have been configured:

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

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

Migrato – Product Export – Start Export
Migrato – Product Export – Start Export

The available filters depend on the product fields supported by Migrato and the columns selected for the export.

Available Product Filters

Filter Description Available Conditions
ID Filter products using their Shopify product ID. Multiple IDs can be entered where supported. Equals to any of; Not equal to any of
Handle Filter products based on their product handle. Equals to any of; Contains any; Contains none
Title Filter products based on their product title. Equals to any of; Contains any; Contains none
Body HTML Filter products based on text contained in the product description. Contains; Does not contain
Vendor Filter products based on the product vendor. Equals to any of; Not equal to any of; Contains any; Contains none
Type Filter products based on their product type. Equals to any of; Contains any
Tags Filter products based on product tags. Equals to any of; Not equal to any of
Created At Filter products based on when they were created. On or after; On or before; Date range; Relative date
Updated At Filter products based on when they were last updated. On or after; On or before; Date range; Relative date
Status Filter products based on their Shopify product status. Active; Draft; Archived
Published At Filter products based on when they were published. On or after; On or before; Date range; Relative date
Published Filter products based on their publication status. Yes; No
Collection Filter products based on the collections they belong to. Equals to any of; Not equal to any of
Variant ID Filters products based on the Shopify ID of their variants. This is useful when you need to export products associated with specific variants. Equals to any of; Not equal to any of
Variant SKU Filter products based on the SKU of their variants. Equals to any of; Contains any; Contains none
Variant Barcode Filter products based on variant barcodes. Equals to any of; Not equal to any of; Contains none
Variant Taxable Filters products based on whether their variants are configured as taxable in Shopify. Yes; No
Variant Weight Filter products based on the weight of their variants. Equals; Less than; Less than or equal to; Greater than; Greater than or equal to; Between
Variant Price Filter products based on variant price. Equals; Less than; Less than or equal to; Greater than; Greater than or equal to; Between
Variant Inventory Quantity Filter products based on the inventory quantity of their variants. Equals; Less than; Less than or equal to; Greater than; Greater than or equal to; Between
Available Product Filter Options
Available Product Filter Options
i

Note: The exact filters and conditions available in your Migrato account may vary depending on the current app version and supported Shopify data fields.

Filter Conditions

Migrato provides different conditions depending on the selected product field.

Text-Based Conditions

Condition Description
Equals to any of Exports products where the selected field matches any of the specified values.
Not equal to any of Exports products where the selected field does not match any of the specified values.
Contains any Exports products where the selected field contains any of the specified values.
Contains none Exports products where the selected field does not contain any of the specified values.
Contains Exports products where the selected field contains the specified text.
Does not contain Exports products where the selected field does not contain the specified text.

Date-Based Conditions

Condition Description
On or after Exports products created, updated, or published on or after the selected date.
On or before Exports products created, updated, or published on or before the selected date.
Date range Exports products whose relevant date falls within the selected date range.
Relative date Exports products based on a relative time period, such as the last few days, weeks, or months.

Status Conditions

Condition Description
Active Exports products with an Active status.
Draft Exports products with a Draft status.
Archived Exports products with an Archived status.

Boolean Conditions

Condition Description
Yes Exports products where the selected setting is enabled or true.
No Exports products where the selected setting is disabled or false.

Numeric Conditions

Condition Description
Equals Exports products where the numerical value exactly matches the specified value.
Less than Exports products where the numerical value is lower than the specified value.
Less than or equal to Exports products where the numerical value is lower than or equal to the specified value.
Greater than Exports products where the numerical value is higher than the specified value.
Greater than or equal to Exports products where the numerical value is higher than or equal to the specified value.
Between Exports products where the numerical value falls between the specified minimum and maximum values.

Product Filter Examples

Example 1: Export Products by Product ID

To export specific products, use the ID filter.

Select:

ID → Equals to any of

Enter the required product IDs.

For example:

47372723, 75276438, 82837828

Migrato will export products matching the specified product IDs.

Migrato – Filter Products by Product ID
Migrato – Filter Products by Product ID

Example 2: Export Products by Vendor

To export products belonging to one or more specific vendors:

Vendor → Equals to any of

For example:

Vendor A, Vendor B

Migrato will export products matching the selected vendors.

Migrato – Filter Products by Vendor
Migrato – Filter Products by Vendor

Example 3: Export Products by Status

You can filter products according to their Shopify status.

For example:

Status → Active

This exports products with an Active status.

You can also select:

  • Draft
  • Archived
Migrato – Filter Products by Status
Migrato – Filter Products by Status

Example 4: Export Products Created Within a Date Range

To export products created during a specific period:

Created At → Date range

For example:

January 23, 2026 → February 12, 2026

Migrato will export products that were created within the selected date range.

Migrato – Created At Date Range Filter
Migrato – Created At Date Range Filter

Example 5: Export Recently Updated Products

You can use the Updated At filter to export recently modified products.

For example:

Updated At → Relative date → Last 30 Days

This is useful when you regularly need to export products that have been recently updated.

Migrato – Updated At Relative Date Filter
Migrato – Updated At Relative Date Filter

Example 6: Export Products Based on Variant Price

To export products based on variant pricing:

Variant Price → Greater than → 50

Migrato will export products whose variant price meets the selected condition.

Migrato – Variant Price Filter
Migrato – Variant Price Filter

Example 7: Export Products with Low Inventory

You can use Variant Inventory Quantity to identify products based on inventory levels.

For example:

Variant Inventory Quantity → Less than → 10

This can be useful for creating an export of products with low inventory.

Migrato – Variant Inventory Quantity Filter
Migrato – Variant Inventory Quantity Filter

Using Multiple Product Filters

Migrato allows you to combine multiple filters to create a more targeted product export.

For example, you can combine:

  • Vendor → Equals to any of → Vendor A
  • Status → Active
  • Variant Inventory Quantity → Less than → 10

This allows you to export active products from a specific vendor with low inventory.

Migrato – Multiple Product Filters
Migrato – Multiple Product Filters
i

Tip: Before starting the export, review each filter carefully to make sure the conditions will return the products you need.

Important Notes

  • Filters are applied to the product data before the export is processed.
  • You can use multiple filters to narrow down the export results.
  • Use the appropriate condition based on the field type, such as text, date, numeric, or status.
  • When using product IDs, SKUs, handles, or other exact values, make sure the entered values match the data in your Shopify store.
  • For large catalogs, we recommend reviewing the filters carefully before running the export.
  • If you are unsure about the expected results, perform a small test export first.

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