Upload Bulk Products to Multiple Manual Categories

Shopify Discussion
, ,
1

Hello. I want to ask how can I make to upload bulk products to different manual categories.

I attach a modified csv file taken from the Shopify link:

https://help.shopify.com/en/manual/products/import-export/using-csv#csv-files

I attach file here with 2 rows only to make the example. I added to the end the column " Collection" as described in the tutorial to both rows. In one row in “Collection” column the value “Col A” and in the to other row " Col B" . With this I pretend to do is upload that product to 2 different categories.

Then the questions about this:

1.-Is the right way to do as the file I attach here? To add the product to a second collection I need to add the whole row of the first collection for that product with all the columns filled like they are but just change to " Col B" ? Or is incorrect what I did in the file I attach and that will replace the product to " Col B" and it will remove from " Col A". I ask this because my idea is put all the products that require to go to multiple collections like that, just copy the previous row with first category and change to the new category, meaning if I have a product that will go to 10 categories I will create 10 rows for that product and just changing" Collection" column value. It’s important because I have thousands of products and if this is incorrect I will create a mess. Also considering that if I have thousands of products that means thousands of rows in the csv and the total number of rows will be multiply that thousands of rows by the number of extra categories I want to add, resulting this in a big but big csv file.

2.-Exactly what columns are mandatory to put the product in 2 categories?

3.-Any other technique to do?

2

Or how can I upload a product to multiple manual categories without using apps from shopify store.

3

Hi :waving_hand:
Usually how I would handle bulk product uploads/ assigning to collections is to base the collection rules on tags (not manual). Then when you upload the products apply the correct tags to assign the products to the correct collections. Tags are just easy to manipulate in bulk.
It is possible without an app but we use https://matrixify.app/ for this process as it makes things way easier in general for handling bulk uploads.

4

Yes I detected that the csv I attached does the job but it only upload Col A and it skips Col B if I split the file to upload Col A and other file for Col B both work the problem is I have 500+ categories and upload 500 files I don;t find a solution yet because shopify accepts one file at once.

Yes I see that app the problem is I don’t have sales yet. I’m starting to check and we pretended to upload products and see if works but that app and others they want even to charge high fees monthly if you have certain number of products or categories. If I don’t sell as expected they will charge me $200 or maybe more monthly. That is a lot.

Now I’m fighting to see how to upload a batch of hundred of files and it will work.

5

Hi @alexesc ,

I don’t think there is a way to do this simply without an app. The easiest way is to do it with MassCat app . Simply copy and paste the list of SKUs for the products you want to add in the app and then select the collections. It will bulk add the products to the selected manual collections.

Hope this helps!