updating with cvs without changing title field

Highlighted
New Member
2 0 0

I get stock updates from suppliers some of which have useless product descriptions, so i've had to re title all products.

How do i do a CSV update "Variant Inventory Tracker" and price fields, without updating the "title" field of the product?

 

thanks

-Tim

0 Likes
Highlighted
Shopify Partner
685 101 213

Assuming you have lots of products then you have a number of options but I'd go with something like this:

 

1 - Do an export of all your products

2 - Open it via Google Sheets (don't use Excel)

3 - Also open suppliers CSV in Sheets as a new worksheet

4 - Do a vLookup on a common key (Barcode, SKU etc.)

5 - Via vlookup pull in quantities & price to your products export sheet

6 - Do a copy & paste special (values only) to remove the formulas but leave the values

7 - Check all is ok

8 - Import product export sheet back into Shopify

 

If you have to do this often, turn it into a database rather than a spreadsheet or use an app like this one https://apps.shopify.com/ez-inventory or do via Excelify app.

If helpful then please Like and Accept Solution
0 Likes
Highlighted
New Member
2 0 0
im an idiot i should have been using inventory update all along. sorry new to this
0 Likes