I’d use Shopify’s own export as the test file here. Export one affected product, change only Variant Grams in that CSV, then re-import it with the matching handle. If the weight updates from Shopify’s export format, the issue is likely the custom CSV structure or variant matching, not the grams value itself.
This is Vineet from Identixweb, a Shopify Development Agency.
I’d first export one product from Shopify and use that exact CSV format as your template. The last time I checked, Shopify’s current native CSV uses Weight value (grams) and Weight unit for display, not variant weight.
For 26.54 lb, the value should go in the grams column as 12037, and the display unit should be lb. Also, make sure the product/variant has Requires shipping = true, and when updating existing variants, include the option columns like Option1 name and Option1 value so Shopify knows which variant you’re updating.
Ohh, one more thing: if you’re updating existing products, make sure you select Overwrite products with matching handles during import. Otherwise, Shopify can ignore matching handles, and your weight changes won’t apply.
Use Shopify’s exported CSV as a template. Update only the “Variant Grams” column with the weight in grams (e.g., 12037 for 26.54 lb). Make sure “Requires shipping” is true, include variant options, and select “Overwrite products with matching handles” on import. Shopify doesn’t use a separate “Variant Weight Unit” column, the weight unit is for display only.
Hello @Friday-Deals24
Shopify assumes weight will be specified using Variant Grams when you are importing from a CSV file and does the conversion to grams automatically. The fields Variant Weight and Variant Weight Unit are ignored during import, this is why the value is empty.
Convert your lb to grams before upload (1 lb = 453.592g) and only use Variant Grams once in the csv, don’t add any other weight columns. Also be sure that you are properly matching variants (Handle, Option) so that the updates will take.
