No products after positive confirmation of Product CSV import

Solved
Batcat
Tourist
6 0 1

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.

Accepted Solution (1)
Trevor
Community Moderator
Community Moderator
3342 452 912

This is an 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 

Trevor | Community Moderator @ Shopify
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

View solution in original post

Replies 10 (10)
Zqdo
Shopify Partner
803 32 60

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
Tourist
6 0 1

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
Shopify Partner
803 32 60

How many products are you trying to upload?

Batcat
Tourist
6 0 1

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

Zqdo
Shopify Partner
803 32 60

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

Batcat
Tourist
6 0 1

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
Shopify Partner
803 32 60

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

 

Does it work?

Batcat
Tourist
6 0 1

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
Community Moderator
Community Moderator
3342 452 912

This is an 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 

Trevor | Community Moderator @ Shopify
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

Batcat
Tourist
6 0 1

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