Why isn't my CSV file importing products to my store?

Technical Q&A
1

Hi guys,

I’m trying to import a CSV file as product to my store. Shopify launch the mensage “Products imported s” but the product does not appear in product list.

I cannot figue out what’s the problem. Can please anyone help me with this?

Thank you in advance

aaa.png
aaa.png1896×848 132 KB

bbb.png
bbb.png1920×880 122 KB

2

Hi @Base_Raising ,

Hyde here from Shopify.

Is the CSV file you’re using formatted according to Shopify’s CSV requirements? If not you can download a sample product CSV file here. Unless the first line of your product CSV file is the right column headers in the right order, you might not successfully import all the correct information.

Have a review of our help guide on importing products here and if you’re following it all correctly and still not having any success, please let me know and we can take a closer look at it together!

All the best, Hyde.

1 Like
3

Hi @Andrew_8 ,

Thank you for your response.

I used the CSV exported from one product in my shop and I mixed with another one. That’s wht I think column headers are right. I will paste below anyway in case you think is something missing.

Handle Title Body (HTML) Vendor Type Tags Published Option1 Name Option1 Value Option2 Name Option2 Value Option3 Name Option3 Value Variant SKU Variant Grams Variant Inventory Tracker Variant Inventory Policy Variant Fulfillment Service Variant Price Variant Compare At Price Variant Requires Shipping Variant Taxable Variant Barcode Image Src Image Position Image Alt Text Gift Card SEO Title SEO Description Google Shopping / Google Product Category Google Shopping / Gender Google Shopping / Age Group Google Shopping / MPN Google Shopping / AdWords Grouping Google Shopping / AdWords Labels Google Shopping / Condition Google Shopping / Custom Product Google Shopping / Custom Label 0 Google Shopping / Custom Label 1 Google Shopping / Custom Label 2 Google Shopping / Custom Label 3 Google Shopping / Custom Label 4 Variant Image Variant Weight Unit Variant Tax Code Cost per item Status

I aslo already follow that guide and I could not make it works. I will also leave here a link with the CSV file in case anyone can find any mistake.

https://drive.google.com/file/d/1KRBfEOCersjlg9gJUw0tk4_jNJy5CDZP/view?usp=sharing

Thank you in advance.

Baseraisign

4

Hi there,

Can anyone help me with this please?

Thank you in advance.

5

Problem solved,

It was due to I had 207 different varians. Just up to 100 allowed by Shopify.