Articles on: Import/Export/Update Your Store Data

Product Export Filters

Export From Shopify


#FilterPossible Conditions/ColumnsDescription
1SKUequals to any of / not equal to any ofExport products where at least one variant’s SKU matches the specified condition. You can enter multiple SKU values separated by commas to include products with any matching variant SKU.
2SEO URLequals to any of / starts with any ofEnter the product Handle to export a specific product.
3Namecontains any of / equals to any of / matches pattern / contains none ofExport products with Titles that contain specific text. Use the “Matches pattern” condition to include wildcard symbols for flexible matching: * (any characters), ? (a single character).
4Brandequals any of / not equal to any of / contains none of / contains any ofEnter specific Brand names to export matching products, separated by commas.
5Product Typeequals to any of / contains any of / is empty / is not emptyFilter products by multiple Type values, separated by commas.
6Tagscontains any of / contains all of / contains none of / equals to any of / equals to all of / not equal to any of / starts with any of / is empty / is not empty / matches patternExport products that match all, any, or none of the specified tags.
7StatusActive / Draft / ArchiveFilter products by their status in Shopify. You can select multiple statuses. If all options are selected, the filter will not affect the export (equivalent to no filter applied).
8PublishedYes / NoExport only products based on their publication status — Published or Unpublished.
9Categoriesequals to any of / not equal to any ofAllows you to export products based on their assigned Categories.
10Created Aton or after / on or before / date range / relative dateExport products Created in Shopify within a specific date range. You can also use the relative date condition to export products created during the last full time period.
11Updated Aton or after / on or before / date range / relative dateExport products Updated in Shopify within a specific date range. You can also use the relative date condition to export products created during the last full time period.
12Parent SKUequals to any of / not equal to any ofExport products where at least one variant’s Parent SKU matches the specified condition. You can enter multiple SKU values separated by commas to include products with any matching variant SKU.
13Product IDequals to any of / not equal to any ofEnter specific Product IDs you want to export, separated by commas.
14Published Aton or after / on or before / date range / relative dateExport products Published in Shopify within a specific date range. You can also use the relative date condition to export products created during the last full time period.


Export From WooCommerce


#FilterPossible Conditions/ColumnsDescription
1SKUequals to any of / not equal to any ofExport products where at least one variant’s SKU matches the specified condition. You can enter multiple SKU values separated by commas to include products with any matching variant SKU.
2Brandequals any of / not equal to any of / contains none of / contains any ofEnter specific Brand names to export matching products, separated by commas.
3Product Typeequals to any of / contains any of / is empty / is not emptyFilter products by multiple Type values, separated by commas.
4Tagscontains any of / contains all of / contains none of / equals to any of / equals to all of / not equal to any of / starts with any of / is empty / is not empty / matches patternExport products that match all, any, or none of the specified tags.
5StatusActive / Draft / ArchiveFilter products by their status in Shopify. You can select multiple statuses. If all options are selected, the filter will not affect the export (equivalent to no filter applied).
6Categoriesequals to any of / not equal to any ofAllows you to export products based on their assigned Categories.
7Product IDequals to any of / not equal to any ofEnter specific Product IDs you want to export, separated by commas.
8Metafield Namespaceequals any of / not equal to any ofFilters the Products export by Product level Metafields.
9Metafield Keyequals any of / not equal to any ofFilters the Products export by Product level Metafields.
10Metafield Valueequals any of / not equal to any of / contains any of / contains all of / contains none of / is empty / is not empty / matches patternFilters the Products export by Product level Metafields.

Updated on: 05/06/2025

Was this article helpful?

Share your feedback

Cancel

Thank you!