FROM CACHE - en_header

Product Import Using CSV - adding collections column

5 0 1

I am import about 260 products using a csv.  I have everything ready to roll but I noticed I could assign each product to a respective collections.  I ready the help documentation so it all sounds easy enough, however, what "collection" value am I supposed to use.  The documentation says to use the collection name.  Does this mean the collection title or the collection handle?  



Replies 5 (5)
Shopify Staff
Shopify Staff
450 56 88

Hey there, @amneal!


Ryder here, from the Social Care Team at Shopify. Thanks for posting! That's a great question, and I'd be happy to clarify.


After exporting your CSV file and adding a new column titled "Collection", you can simply input the Collection titles for which products you'd like filtered in there. To test this out, I created a Collection with the name "Tester" and inserted a "Collection" column in between the Image Alt Text and Gift Card columns - but you can add it anywhere as this is the only column that won't break the format. I then wrote "Tester" in the fields for the products I wanted assigned to that Collection: 




After importing the CSV file back into the Products section (and checking off the "Replace any current products that have the same handle. Existing values will be used for any missing columns." option in the Import pop-up), the products were automatically filtered into the Tester Collection! 


I hope this helps clarify for you what information is required. If you have any trouble with this, or if there's anything else I can confirm, please let me know!



Ryder A. | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

New Member
1 0 0

Hi! I already made different collections on my website and I'm wondering how can I import(csv) each product to more than one existing collection.

Shopify Expert
4 0 3

Hi, here I found the beautiful solution.

Follow steps as below
1. Prepare product CSV with single collection name
2. Upload the CSV
3. After successfull import, Export all the products
4. Modify the new CSV with different collection name for all products
5. Upload the new CSV ( please make sure the override option to be selected. )


Cheears you will have both collections available in admin.

New Member
1 0 0


It seems I can't add my products into 'Smart Collections'.

So I'd previously created Collections and tried to follow your advice, 3iwebexperts. But with no joy. An error message appears when trying to import my CSV file, telling me that I can't import products into 'Smart Collections'. I wasn't even sure what these were until now. Apparently they collections populated by products with specific 'tags'.

Does anyone know if there is a workaround for this or whether I am doing something wrong?


9 0 4

How did you get the images uploaded and then correlated properly in your spreadsheet to each product? Was this initially a product export that you modified to re-import or are these new products you are adding?