Have your say in Community Polls: What was/is your greatest motivation to start your own business?

Re: Product CSV Import not updating existing products

Solved

Product CSV Import not updating existing products

grizzlysupply
Visitor
2 0 1

We updated our descriptions so I uploaded a CSV file with all of our products and their updated descriptions via the CSV file import option on the product page with the hope of updating only our product descriptions. The only cells changed in the CSV from our original bulk import were the descriptions. I received an email saying that the import was successful. However, the information, specifically the descriptions, that I changed in the CSV did not change on Shopify. 

 

How do I correctly change all of the 150+ descriptions without having to change them manually?

Accepted Solution (1)

Ablestar_Daniel
Shopify Partner
136 23 45

This is an accepted solution.

Getting the product import/export in the Shopify Admin can be a little tricky and it's hard to see what's been changed. I'd recommend trying to test on a single product first and seeing if you can get that to work:

 

Preparing the spreadsheet

Remove all columns from your spreadsheet except for these three:

  • Handle
  • Title
  • Body (HTML)

Make sure the column names match exactly and add the information for a single product, your spreadsheet should look like this:

 

Screenshot 2024-01-31 at 11.06.13 AM.png

 

Upload the spreadsheet

On the products page of the Shopify Admin click on Import and when you upload the file make sure the 'Overwrite products with matching handles' box is checked:

Screenshot 2024-01-31 at 11.01.22 AM.png

 

The complete the import and check to see if the description has changed. If it hasn't changed could you attach the CSV file you're using and I can take a look to figure out what's not working.

 

Best,

Daniel

Founder @ Ablestar ✦
Manage product data, spreadsheets, Google Shopping data, and metafields with Ablestar Bulk Product Editor. Use previews, undos, and automations to be confident your product data is correct.
Please don't forget to Like and Mark Solution to the post that helped you. Thanks!

View solution in original post

Replies 2 (2)

Ablestar_Daniel
Shopify Partner
136 23 45

This is an accepted solution.

Getting the product import/export in the Shopify Admin can be a little tricky and it's hard to see what's been changed. I'd recommend trying to test on a single product first and seeing if you can get that to work:

 

Preparing the spreadsheet

Remove all columns from your spreadsheet except for these three:

  • Handle
  • Title
  • Body (HTML)

Make sure the column names match exactly and add the information for a single product, your spreadsheet should look like this:

 

Screenshot 2024-01-31 at 11.06.13 AM.png

 

Upload the spreadsheet

On the products page of the Shopify Admin click on Import and when you upload the file make sure the 'Overwrite products with matching handles' box is checked:

Screenshot 2024-01-31 at 11.01.22 AM.png

 

The complete the import and check to see if the description has changed. If it hasn't changed could you attach the CSV file you're using and I can take a look to figure out what's not working.

 

Best,

Daniel

Founder @ Ablestar ✦
Manage product data, spreadsheets, Google Shopping data, and metafields with Ablestar Bulk Product Editor. Use previews, undos, and automations to be confident your product data is correct.
Please don't forget to Like and Mark Solution to the post that helped you. Thanks!
grizzlysupply
Visitor
2 0 1

Uploading the file with limited columns worked! Thanks so much for the help!