Discuss and resolve questions on Liquid, JavaScript, themes, sales channels, and site speed enhancements.
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?
From what I know, the only way is to convert them manually.
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!
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.
June brought summer energy to our community. Members jumped in with solutions, clicked ...
By JasonH Jun 5, 2025Learn how to build powerful custom workflows in Shopify Flow with expert guidance from ...
By Jacqui May 7, 2025Did You Know? May is named after Maia, the Roman goddess of growth and flourishing! ...
By JasonH May 2, 2025