Bulk upload changes to specific fields

[Charming_Beads]

Hey all,

I am trying to upload changes to specific product fields (actually meta data).

I downloaded my product file, removed all columns except handle, title, Variant SKU and the various metafield columns.

I was effectively looking to do a "partial update" to my products.

However when I go to upload it says "src" is missing.  I assume it wants the image source column. I am not wanting to change any other details other than my metafield data.

Is that even possible or do I have to include all columns?

Many thanks.

[Ablestar_Daniel · Accepted solution]

Hi @Charming_Beads,

You shouldn't need to include the image columns when you're doing the updating. I'm wondering if the error is related to the type of the metafield you're updating. Are they all text metafields or do you have some other types of metafields as well?

Best,

Daniel

[Small_Task_Help]

Hi, 

Hope following will help

- You can use Shopify’s API for direct metafield updates.
- Update metafields via Shopify’s Bulk Editor at admin interface.

[Charming_Beads]

Thank you but it was relating to upload csv, not a bulk editor.  I didn't know about the bulk editor though, so that may come in handy for small edits thanks!

[Ablestar_Daniel · Accepted solution]

Hi @Charming_Beads,

You shouldn't need to include the image columns when you're doing the updating. I'm wondering if the error is related to the type of the metafield you're updating. Are they all text metafields or do you have some other types of metafields as well?

Best,

Daniel

[Charming_Beads]

Hi Daniel,

Hi Daniel,

Yes that is the answer thanks!

When I rechecked I had accidentally left the alt image text column in there.  Makes total sense now.

Sorry can I please ask one more quick question ... 

I only want to update the fields from the columns present in my file, and not the whole product.

Do I tick "Overwrite products with matching handles" and untick "Publish new products to all sales channels" OR do I untick both please?

Many thanks,

Paul

[Ablestar_Daniel · Accepted solution]

Hi @Charming_Beads,

To update the products tick "Overwrite products with matching handles" and untick "Publish new products to all sales channels" like you mentioned.  (I don't think "Publish new products to all sales channels" will have any effect because you're just updating new products but it's better to be safe).

I'd also recommend:

• Exporting all your products to a CSV and keeping that file as a backup
• Testing your updates on 1-2 products at first

It can be easy to accidentally delete data if you include blank columns or adjust the option1/2/3 columns so it's always safer to test and have a backup first.

Best,

Daniel

[Charming_Beads]

Hey Daniel,

Thank you so much - I tried it with one product and it worked like a dream, only updating the metafield data fields and leaving the other data in tact.

The issue I had faced is that an app that migrated my products from another platform did an okay job with the metafield data but blank fields were filled with a 0.  So I wanted to basically get rid of the 0s for blanks.  And that just worked great.

And that's also great advice to save a copy of the full product data and only tes on one or two products.

Thanks for your help - it was much appreciated!

Kind regards,

Paul