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
| Column | Needed | What to put |
|---|---|---|
| Handle | Yes | The collection's handle. Repeat it on every product row. |
| Title | For new collections | On the first row. |
| Product: Handle | Yes, or Product: ID | One 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
How to import it
- Replace the examples with your collections and product handles.
- In Bulkvane, open Import, choose Collections, add the file and choose Create and update.
- Click Check file: the preview lists the products each collection gains.
- 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