Join us for an upcoming Shopify Partner webinar on February 27, 2024. Discover the latest Checkout Extensibility features, and deep dive on improvements to Shopify Functions and Web Pixels. Register now for either the 10am EST or 2pm EST sessions.
Solved

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

OTATA
Tourist
3 0 5

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?

Accepted Solution (1)

BenMurphySmith
Tourist
4 2 19

This is an 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.

View solution in original post

Replies 5 (5)

BenMurphySmith
Tourist
4 2 19

This is an 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
Tourist
3 0 5

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
Shopify Partner
277 30 328

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!

Matrixify | Bulk Import Export Update | https://apps.shopify.com/excel-export-import | https://matrixify.app

MetafieldsGuru
Shopify Partner
157 32 95

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*:

1.png

 

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

1) bulk editor;

2) Excel-like editor;

3) CSV import.

Check out Metafields Guru, the #1 ranked metafields app.

Bulk editor | Data import/export | Metafield sets | Browser extension

natashadisante
Shopify Partner
126 0 13

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.