Best way to edit all products as an admin over a script

[OTATA]

Hello!

I am fairly new to shopify development and feel a little overwhelmed by all the different services and products that are offered to me as a developer.

My objective is to change specific words in the metafields of all products (some words in the metafields should be bold because of allergenes contained).

What would be the best approach to iterate over all products in my shop, grab the metafields of the product, change it, and update it on the store?
Can I use the shopify cli for that? Do I have to setup a private app for that (I mean I dont need a GUI for that task, actually just my console or some typescript code I guess)? Whats the best/quickest way to interact with the data on my shop when I dont want to write an "app" (in the classical sense) but just want to change something over the console as an admin?

[BenMurphySmith · Accepted solution]

Use the app Matrixify (formerly known as Excelify)

or

Bite the bullet and write a little app to do it yourself over GraphQL. If you're going to be working with Shopify in your job, you should get used to doing this kind of task yourself, it's very educational to take the time to do so. If you're handy with Postman you could set up a simple collection to call your store's api, get the products, and modify the metafields as necessary.

[OTATA]

Ok got it!

For now, Matrixify will indeed do the trick, but I will look into the GraphQL API as well!
Thank you very much!!

[Renars]

Hey @OTATA 

Sorry about the late reply here.

Just wanted to check in here if you managed to solve your issue with the use of our app.

Feel free to reach out to our support directly if you have any issues or troubles when using our app!

[MetafieldsGuru]

Luckily, there's a more efficient option -- you can do that using a third-party app.

For instance, with our app you can edit metafields for all the resource types either "manually" or in bulk*:

* by the way, there are multiple options to edit the data in bulk:

1) bulk editor;

2) Excel-like editor;

3) CSV import.

[natashadisante]

Hi @OTATA 

You can easily bulk edit your Shopify store's metafields from Mixtable's Excel-like spreadsheet interface. Map the metafields you want to update, change the relevant cells, and sync the data back to Shopify. You can change the cells manually, or by using the built-in bulk find & replace feature.