Hey @jhbh2 ,
This is Finley from the Social Care team at Shopify.
Thanks for your question!
From my understanding, you need to update the weight unit of your products from pounds to grams, and there are quite a few to update.
If you’ve updated your weight unit in your Shopify Admin > Settings > General > Standards and formats > Default weight unit to grams recently, then you should notice that when you add a new product, the weight is in grams by default.
However, when you change your default weight unit, this does not automatically update all the weights of the products you’ve already created, so you would need to update these yourself.
I completely understand that you’d want to do this the best way possible with the many products that you have.
The best way would indeed be through the bulk editor or with a CSV file.
Using the bulk editor
With the bulk editor, you can use the shortcuts shown here to make the process much faster!
My favorite shortcut to use when I’m editing every product in the bulk editor is to select multiple adjacent cells with your mouse.
To use this shortcut, you would:
- Select a cell
- Hold the shift key and click another cell in the same column.
- All cells in between the two cells, will be selected. Any changes made to one cell will change the others like so:

In the example above, I’ve only switched the weight unit, but you can use this for text and numbers too.
Using a CSV file
Similarly, you can edit in bulk using a CSV file.
To do this, you’ll want to export your products from your Shopify admin.
Once exported, you can edit your Variant weight unit column in your CSV file.
Once the changes are complete, you can import the CSV into your Shopify admin to update your products with its new changes.
I do hope this helped clarify things, however, please do let me know if I can explain any of these points further! I’m happy to help wherever I can.
Cheers,