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 manual collections CSV template

A collection's details go on its first row, and every row lists one product by its handle. Rows with the same collection Handle belong together.
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 product row.
TitleFor new collectionsOn the first row.
Product: HandleYes, or Product: IDOne product per row.

What's in the file

Handle,Title,Product: Handle
staff-picks,Staff picks,classic-tee
staff-picks,,linen-shirt
staff-picks,,rain-jacket
Example rows. Replace them with your own before you import.

How to import it

  1. Replace the examples with your collections and product handles.
  2. In Bulkvane, open Import, choose Collections, add the file and choose Create and update.
  3. Click Check file: the preview lists the products each collection gains.
  4. Apply, then publish new collections to your sales channels in Shopify admin.

Tips

  • Listed products are added to the collection. In Replace mode, the list becomes the collection's whole product list, and products not in the file are removed.
  • Import products before the collections that list them, so their handles can be found.

Step by step: Collections: conditions and product lists. Every column is in the column reference.

Questions

How do I remove products from a manual collection?

Import the full list you want with Replace mode: products not in the file are removed. Undo puts them back.

Can I set the sort order?

Yes. Add a Sort Order column on the first row, such as Manually or Best selling.

Preview every change.Undo any import for 30 days.

Install free