For future people reading this, there is a much easier way to convert. I am surprised no one mentioned this… You are already using excel; Simply insert another cell next to your weights and then use the formula =CONVERT(A2,“lbm”, “g”). With A2 needs to be changed to the cell that you have your weight in. So in other words you can add another cell with your weights in pounds and then in the actual cell where grams go reference the cells with pounds. This will automatically convert them. Make sure the data is no longer a formula when you save it; you will want to copy and then right click PASTE AS VALUE to paste the actual number. There is no reason to manually convert 2000 individually or to use a converter on the internet for each product. That is such a waste of time. Hopefully this all made sense. If you are at the point that you have clients I would suggest taking a small course in excel. You will save yourself a lot of headache.
beaux
5
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| How to change the units from lbs to grams on bulk editor | 8 | 380 | February 21, 2024 | |
| How can I automatically convert all product weights to kg? | 2 | 95 | July 12, 2021 | |
| How to fix weight display issue after bulk update in lbs? | 0 | 34 | August 4, 2022 | |
| Shopify Products Weight | 4 | 106 | June 7, 2026 | |
| Where is weight in product data (shipping area) stored - how to edit it in bulk? | 8 | 388 | February 22, 2024 |