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

Dear Shopify

Dear Shopify

danny27404
Shopify Partner
1 0 0

Please can you have a update feature on products where we can just upload a csv and only update the column matching the handle. I have 7,500+ products and to re upload the csv takes over 6 hours to update products. The amount your charging us to use your service this simple feature should be accessible to all not to a app that charges monthly to use.

Reply 1 (1)

Ablestar_Daniel
Shopify Partner
136 23 45

Hi @danny27404,

I can't speak for Shopify but one thing that might help speed up the updates is removing the columns that you're not making changes to (especially any image columns). If you're updating a product attribute the only column you need is the Handle and then the columns you want to update.

 

For example, the following spreadsheet will update the Title and Vendor for the matching product if you import it in the Shopify admin with the "Overwrite products with matching handles" option selected:

Screenshot 2024-07-26 at 2.15.57 PM.png

To update variant fields you'll need the following columns at a minimum to match the correct variant: Handle, Title, Option1 Value, Option2 Value, Option3 Value, Variant Price

 

Removing the extra columns will reduce the chance of errors (since there's no way to see what was changed after the fact) and speed up the process. At a minimum I'd suggest removing the images columns if you're updating your data with a spreadsheet, since those take longer to process, and also testing any changes like this with 1-2 products first


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!