Skip to content

NewSchedule your Black Friday sale: prices drop at the start and go back by themselves. See how

Bulkvane

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

ColumnNeededWhat to put
HandleYesThe collection's handle. Repeat it on every condition row.
TitleFor new collectionsOn the first row.
Must MatchYesall (products must match every condition) or any.
Rule: Product ColumnYesWhat to test: Tag, Title, Type, Vendor, Price, Compare-at price, Weight, Inventory stock, Variant title.
Rule: RelationYesis equal to, is not equal to, is greater than, is less than, starts with, ends with, contains, does not contain.
Rule: ConditionYesThe 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
Example rows. Replace them with your own before you import.

How to import it

  1. Replace the examples with your collections and conditions.
  2. In Bulkvane, open Import, choose Collections, add the file and choose Create and update.
  3. Click Check file: the preview shows each collection's conditions, old and new.
  4. 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