Can we import product weights in pounds instead of grams?

Can we import product weights in pounds instead of grams?

MalikTillman
Visitor
1 0 1

I have a client that needs to import ~2000 items into their store via CSV. We need to import the Variant Grams field (product weight) as pounds (lb) not grams. Is there a way to do this without having to manually convert all values to grams? Can we set the Variant Weight Unit field to pounds (lb) instead?

Replies 4 (4)

trifonsans
Visitor
2 0 0

From what I know, the only way is to convert them manually.

trifonsans
Visitor
2 0 0

Sometimes it is better to do things manually. To be sure everything is correct. I am using this website https://ounces-to-grams.com/, and it simplifies my work. I am inserting the data manually and getting the result instantly. It is a piece of cake to convert ounces to grams. Moreover, it doesn't take much time, so it assures productivity. You can manage to do a lot of operations in a short time. I tried other options, but this seemed to be the best. It still requires attention when inserting numbers, but it is a trustworthy source. You should try it!

beaux
Shopify Partner
10 0 3

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.