When you export Products from Shopify, you can set the filter to export only products that exist in any of the collections that you put in the filter box.
You can filter Collections by IDs, Handles or Titles.
To filter by several Collections, split them with a comma.
If you want to export only products that don’t match any of the listed SKUs, you can apply that filter now.
Apply the filter by SKU, choose the “not equal to any of”, and put the SKU numbers split by a comma in the filter box.
For an example: SKU-1, SKU-2, SKU-3
You can filter products export by Collection.
Put the collection Title, ID or collection Handle in the filter box – you will export only products that belong to this collection.
You can get the collection ID from the URL when you open the Collection page in the Admin. Or you can get the collection Handle from the SEO part in the Admin, or from the collection page URL on your store public site. Also, you can get collection ID or Handle by exporting Collections – then you can see those in the exported file.
You can filter Products by Vendor in finer detail:
- Vendor equals any of several vendors, split by comma
- Vendor not equal to any of several vendors, split by comma
You can filter Products – to export only those, which contain fragments of SKU.
To filter by several fragments, split them by comma.
In this example, if you have the filter set to “SKU-1, AAA”, then it will export only those Shopify Products, where any part of their SKU contains “SKU-1” or “AAA”.
To export all Products, where SKU is empty – set the filter by SKU, and leave the search box empty.
You can apply the filter when exporting to any format, including Excel, Google Shopping Data Feed, Amazon.
When exporting from Shopify, you can filter Products by Price with the following conditions:
- less than
- less than or equal to
- greater than
- greater than or equal to
When doing the export, it will look into all your product prices and will include in the export only those products, where the price of the product or at least one of its variants will match your given criteria.
When exporting Customers, you can filter by Customer registration date interval.
It helps when you have very many customers, but you want to export by specific registration date.
You can filter Shopify Products by many titles – put them in filter split by , (comma), and it will export only products that contain any of those titles.
You can filter export of Products by Handle, Title, Vendor, Type, and Tags.
Also you can filter Orders export by date.
Use those filters to make your exports smaller and a lot faster, if you need only certain items exported.
When exporting, all the base rows like Title, Vendor, Tags, etc. are filled also for duplicated rows, so that you can filter and group them easier in Excel.