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?  



Shopify Staff
Shopify Staff
301 39 51

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 Team at Shopify
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Click Accept as Solution 
 - To learn more visit the Shopify Help Center or the Shopify Blog

1 Like
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 Partner
1 0 1

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.

1 Like