No products after positive confirmation of Product CSV import

[Batcat]

After a successfull product csv import, I still can't see any products in the store. This is a new store from scratch on a Basic plan. Theme: Pipeline.

[Zqdo]

When you download the CSV onto your computer, what does the data look like?

Can you see all data in table format such as Title, Category, Tags, etc?

[Batcat]

File is saved as a csv. When I open it in excel I see the data in columns. If I open it in text, I see csv format with ,

thanks for your help.

[Zqdo]

How many products are you trying to upload?

[Batcat]

Testing 2 products with each 2 variants (4 x 6)making it 48 different skus.

[Zqdo]

You've checked to make sure that there's no missing headers, fulfillment service titles, and all prices are filled?

[Batcat]

All mandatory fields are filled. I haven’t changed any headers from the downloaded file from shopify. Price is 0.0. Could this be it?

[Zqdo]

It's possible. Test out adding a price and see if you can see the product.

Does it work?

[Batcat]

Changed pricing. Re-imported. Received confirmation for import. Still no product showing. I've attached the product file.  Please let me know if you see something. thanks for your help.

[Trevor · Accepted solution]

@Batcat CSV's can be sensitive in that, if you have values in places you shouldn't, then it can cause the import to fail. On that, you would receive an email that outlines what failed and why product's didn't import. 

Your CSV includes these errors in the email: 

• Line 2-25: Validation failed: /store/samara-and-co/products/8004434493725 is not a valid image file type.
• Line 26-49: Validation failed: /store/samara-and-co/products/7984244850973 is not a valid image file type.

Addressing that first - The URL you included in the "image source" and "variant image" columns are private admin links that would be inaccessible when importing your CSV. You'd need to use publicly accessible URL's so the system can download the images. 

If these images are in Content/Files then you can update the links accordingly by copy and pasting the URL's that appear in that area of the admin. 

To touch on other areas of the CSV that need to be updated

• Image position - You have "1" in every cell, this will break the system and needs to be numbered accordingly for each product. 
• Option 1/2/3 names - You only need titles in the parent row (ie the first row of each product). You do not need added values for every variant row. 

I made those changes and removed the image URL's which allows the products to import successfully 

[Batcat]

Thank you!
Looking good now - had a wrong link for images. all changed for the cdn link which works now.

[innovateQ1]

if the "inage position" column has no values, would the import still be successful please? 🙂 

[Parloudesign]

Dear batcat I have the same problem. Can you help out?