importing product edits via csv upload to just edit specific fields

importing product edits via csv upload to just edit specific fields

philip648
Visitor
2 0 0

i have about 1000 SKUs that i am trying to update the tags, the price and the compare to price.  It would seem that it is not possible to use the csv import for this process unless i download the whole of the product data for those sku's, update what i need and then reload the whole lot of the data for all the products?   Is this correct?   This seems a little fraught with danger especially given all product data is live.  It would seem when you go to upload the csv, if you do not select the "overwrite everything" option and leave it unticked, nothing changes.

 

I would have thought that you should be able to prepare a csv file with only the columns that you want to edit (as will as the handle and name that seem to be used as keys for the csv upload) and then once loaded you can select whether you want to overwrite the fields or just make them additive (where relevant for tags and the like but not relevant for prices).

Replies 4 (4)

Dawood_Mirza_
Trailblazer
135 18 30

Hi @philip648,

A recommended method is to use a CSV file. Here's how I would approach it:

 

1. Adding tags Manually in Shopify's bulk editor takes time, but in a CSV, I would add tags in groups by searching for the title and inserting the tags.

This saves time.

2. Create a formula for the price and use it to determine the "compare at" price as well.

 

This can vary if price calculation is random and tag grouping is not feasible.

 

To import products, keep the handle and title unchanged.

Modify other columns, then select the "overwrite" option. Only the columns will change on live products.
I do this quite often,

 

 

If you provide the store URL and product details, I can give a more tailored solution.

BR

Dawood Mirza

Want to work with me - dawoodmirzabusiness@gmail.com
Don't forget to like and mark it as Solution if it was helpful to you.
philip648
Visitor
2 0 0

thanks Dawood - just a question - if i just put the specific columns that you want to edit in the csv and then hit overwrite, does it just overwrite the specific columns in the csv or does it assume that the rest of the columns are blanks so deletes them?   I know that i did use the overwrite on one variant in a product and it deleted all the other variants.  just a bit hesitant hahaha

Dawood_Mirza_
Trailblazer
135 18 30

What you can do is

First, export all products from Shopify.

Then, create a copy and make the necessary changes in the copied version, this way no blank columns are present. 
This way you can change your products 

If you found it to be helpful, do give a like and mark it as a Solution
BR
Dawood Mirza

 

Want to work with me - dawoodmirzabusiness@gmail.com
Don't forget to like and mark it as Solution if it was helpful to you.
DazC
Shopify Partner
21 0 24

Did you work out whether importing a CSV with unchanged columns removed wipes that data out or just updates the ones you provide?