When Bulk Uploading Shopify accepts products but I cannot find them aftewards

Shopify Discussion
1

I am not a beginner when it comes to bulk uploading products with a .CSV file, but I found myself stuck when trying to upload products on our new SHopify store.

  1. I downloaded the sample CSV from Shopify
  2. I filled the relevant fields with appropriate data
  3. I mapped (as best I could, see below) the import fields to my spreadsheet
  4. Executed… and the products seem to fall into a black hole. No trace of them anywhere.
  5. Additionally, I tried to upload the simplest of products as well. No variants, weight in grams, etc. but that too disappeared.

In addition, the sample CSV from shopify has field names that do not correspond to what the website gives after the upload. I can see this if I go to the “change the order of column headings” section.

Specifically: One of the required Columns is “Product Category”. I have it in my spreadsheet, but when I try to find it in the drop-down as below there is no option available. There is “Collection” which should be the same thing.

That tells me that the sample CSV is not really a good sample, but I would like someone to tell me I am not making this up.

2023-01-18_16-36-47.jpg
2023-01-18_16-36-47.jpg631×917 55.1 KB

In fact, I see several columns that are not present in the drop down and the field naming of the sample spreadsheet is different from what Shopify is looking for.

Should I create my own spreadsheet?

Is there a more up-to-date spreadsheet available somewhere?

Thank you.

2

Hi

The only required columns of the product csv import are handle and title so you can delete other columns if not needed.

A good start for column names for example is:

  • Handle
  • Title
  • Body (HTML)
  • Tags
  • Type
  • Published
  • Image Src
  • Variant Price

If you get this file set up you can then work on expanding into other fields you may need.

You will normally get an error if there is something wrong with the file. Also, try testing with 1 row initially and get it to work before moving onto larger files. This way you can work out if your file is set up correctly.

Thanks
Sam