How can I bulk update product metafields in Shopify?

Shopify Discussion
1

Hey, I have around 12000 products that I am using a single line text metafield for. For all of them I need to put in a different value. It is hard to change it from the admin. Any suggestions how to do it in bulk and to save time?

2

You can do this with a bulk editing app like Matrixify. With the number of products you have, youā€™ll need to pay for one of their premium plans, but you can cancel it when youā€™re done.

There probably are other apps that can modify metafields in bulk, but Iā€™ve only personally used Matrixify.

3

Hello @ac0 and @BenSmith1

Thank you for suggesting the use of Matrixify app for this task!

You sure can use Matrixify to bulk export and import your Shopify Products with their Metafields.

We have a great tutorial here that explains exactly how to bulk manage Metafields in your Shopify store.

If you have any questions or concerns along the way, please reach out to us directly.

4

Hello,

I would suggest checking out our Ablestar Bulk Product Editor if you want to update these metafields in bulk. Since each of your products needs a different value the best way is to use a spreadsheet to update the values. A few things about the app you might find helpful:

  • You donā€™t need to rename the columns to match a specific format. As long as the first column in the spreadsheet refers to a product (title, handle, SKU etc..) the app can detect them for you
  • If you export the metafields to a spreadsheet itā€™s faster than most apps because the app keeps a copy of your products in its local database
  • You can undo any of your modifications with one click
  • Thereā€™s no limit on the number of products during the trial period so if this is a one time thing you should be able to do it for free

Hereā€™s a quick video showing how to update the values with a spreadsheet:

Also, if you want to update the metafields based on conditions, for example: ā€œAll products from vendor A with metafield B should have metafield C set to ā€˜abcā€™ā€ you can do that without spreadsheets.

Happy to answer any other questions you might have. Best,

Daniel

1 Like
5

Shopify has finally added bulk export and import of product metafields in the Summer 2024 update. No need for apps or workarounds now.

1 Like
6

Really? Is this documented anywhere? :crossed_fingers: