Skip to content

How to bulk edit product weight in Shopify

Updated 30 Oct 2026 · 5 min read · Markdown

In the Shopify admin, open Products, tick the products, click Bulk edit, add the weight column under Columns, type the new values and click Save. Weight is a variant field, so every size or color has its own weight and its own row. It is free and right for a few dozen variants. For hundreds, use the product CSV, where the "Weight value (grams)" column is in grams whatever unit your store shows. The guide to bulk editing Shopify products covers the other fields.

Weight is worth care because shipping reads it. A kilogram typed into the grams column is a thousand times too light, the import succeeds, and the checkout charges for a 1.5 gram parcel.

Bulk edit preview with current and new weights per Shopify variant
A weight change is safe when each row shows the variant, the current weight with its unit, and the new one.

Why weight matters: shipping rates

Weight-based shipping rates and carrier-calculated rates use the weight of the variants in the cart. So a wrong weight is invisible on the product page. It shows at checkout, as a rate that is too low or too high, and usually after a customer or the margin report notices.

That makes a bulk weight change closer to a price change than to a description edit. Check it the same way: count the rows, read the units, and put one product in a cart afterwards.

Units and the grams column

Each weight has a value and a unit: grams, kilograms, pounds or ounces. The unit is part of the value. 1.2 kg and 1.2 lb are different parcels, and a copy that keeps the number but not the unit changes the weight by a factor of about two.

In the product CSV the two are split. "Weight value (grams)" holds the number, always in grams. "Weight unit for display" only controls how the weight is shown in the admin: g, kg, lb or oz, with kg as the default. Convert before you import: kilograms times 1,000, pounds times 453.6, ounces times 28.35.

In the bulk editor

Filter Products first ("product type is Coats"), Select all results, then Bulk edit. Click Columns and add the weight field; variant rows sit under each product. Type values, or select several cells in the column and set one value for all of them, then Save. A row that fails validation is marked; fix it and save again.

The editor does no arithmetic. There is no "plus 200 g" and no "plus 10 percent", each cell takes the final number, and there is no undo after Save. The same variant rows hold price and options, as in bulk editing variants.

In a product export

Export the products, edit the weight columns, import with "Overwrite products with matching handles" ticked. This is the best route when measured weights already exist somewhere, such as a packing list with 3,000 SKUs. Convert to grams in the sheet with a formula, not by hand, and check one row in the admin before trusting the rest.

Keep the file small. With the overwrite option on, a blank cell in an included column overwrites the current value as blank, while a column left out of the file keeps its value. The safe file has the handle, the title, the option values that identify each variant, and the two weight columns. One row per variant, handle repeated; the row count should not change.

Apps and ApiMate

Bulk-edit apps such as Ablestar, Hextom and Matrixify add a saved filter and a formula, which pays off when packaging changes every season. In ApiMate the change is a sentence ("add 200 g to every variant in Coats"); the preview lists each variant with its current and new weight and unit, the before values are kept for a revert, and the free plan covers small jobs. Length, width and height are not variant fields; they live in metafields, as the metafield bulk edit case shows.

Before the weights change

  • Count the variants. If the number is larger than the products you meant, the filter caught more.
  • Read the unit on every row of the preview or the sheet, not only the number.
  • Test one product in the cart after the change and look at the shipping rate.
  • Look for variants that should have no weight: digital products and services usually do not need one.
  • Keep the before values. For a CSV that is the export you made first; see how to undo a bulk edit in Shopify.

Questions

What unit does the Shopify CSV use for weight?+

Grams. The column is "Weight value (grams)". "Weight unit for display" only sets how the weight is shown: g, kg, lb or oz.

Why did my shipping rates drop after a CSV import?+

Usually a weight typed in kilograms or pounds into the grams column. 1.5 in that column is 1.5 grams. Convert to grams and import again.

Can I increase all weights by a percentage?+

Not in the admin bulk editor, which takes final values. Use a formula in the CSV, a bulk-edit app, or an instruction in ApiMate.

Explore More

Related

Run this on your own catalog

Install from the Shopify App Store. Every write shows its rows before it runs, and applied jobs can be reverted from history.