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.
How to Filter Products for Export
Follow these steps to export products based on specific conditions.
Step 1: Open Product Export
- Open Shopify Admin.
- Go to Apps → Migrato.
- Open the Export section.
- Select Products as the entity you want to export.
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.
Step 3: Add Product Filters
Open the Filters section and click Add New Filter.
- Select the product field you want to filter.
- Select the required condition.
- Enter or select the value.
- Add additional filters if required.
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.
Step 5: Start the Export
Once the filters have been configured:
- Review the selected fields.
- Review the filter conditions.
- Confirm the export settings.
- Start the export.
Migrato will process the export based on the selected filter conditions.
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 |
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.
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.
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
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.
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.
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.
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.
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.
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.