Free CSV template
Shopify smart collections CSV template
A collection's details go on its first row, and every row carries one condition. Rows with the same Handle belong to the same collection.
Download the CSV template
Free, no sign-up. Opens in Excel, Numbers and Google Sheets.
The columns
| Column | Needed | What to put |
|---|---|---|
| Handle | Yes | The collection's handle. Repeat it on every condition row. |
| Title | For new collections | On the first row. |
| Must Match | Yes | all (products must match every condition) or any. |
| Rule: Product Column | Yes | What to test: Tag, Title, Type, Vendor, Price, Compare-at price, Weight, Inventory stock, Variant title. |
| Rule: Relation | Yes | is equal to, is not equal to, is greater than, is less than, starts with, ends with, contains, does not contain. |
| Rule: Condition | Yes | The value to compare with: summer, 20. |
What's in the file
Handle,Title,Must Match,Rule: Product Column,Rule: Relation,Rule: Condition summer-sale,Summer sale,all,Tag,is equal to,summer summer-sale,,,Price,is greater than,20 linen,Linen,any,Title,contains,linen
How to import it
- Replace the examples with your collections and conditions.
- In Bulkvane, open Import, choose Collections, add the file and choose Create and update.
- Click Check file: the preview shows each collection's conditions, old and new.
- Apply, then publish new collections to your sales channels in Shopify admin. They aren't published automatically.
Tips
- The conditions in the file replace a collection's conditions, so list all of them.
- Shopify's own names and symbols, such as “=” and “!=”, work for Rule: Relation too.
- Price and other number conditions can only use is equal to, is not equal to, is greater than or is less than.
Step by step: Collections: conditions and product lists. Every column is in the column reference.
Questions
Can I add SEO and an image too?
Yes. Add SEO Title, SEO Description, Body HTML, Sort Order and Image Src columns, with the values on each collection's first row.
Can I change a collection from smart to manual?
No, Shopify doesn't allow that. Create a new manual collection instead.
Preview every change.Undo any import for 30 days.
Install free