Bulk Edit Weight and Packed Dimensions in Shopify: 3 Ways

Your supplier sends a new spreadsheet with case weights, or you finally measured every parcel, and now hundreds of variants need a new weight and a packed size. Opening each product is not an option. Shopify gives you two built-in ways to change many variants at once, and both work well if you know their traps.

This guide covers the bulk editor, the product CSV and when an app is worth it, for two fields: the variant weight and the packed product size (the length, width and height after packing, which Shopify uses to pick a saved box for a shipment; see how Shopify’s packed product size works).

Before you start: what has to be true

• Weight is per variant. Each variant has its own weight and its own packed size. A product with six sizes needs six sets of values.
• All three sides or none. For packed product size, Shopify saves the length, width and height together. If you enter only one or two, the packed size is not saved (Shopify Help Center).
• Measure the packed item. Packed size is the outer size after wrapping or boxing, not the product’s own size.
• Keep a copy of the old values. Export your products before a big change, so you can see or restore what was there.

Way 1: the bulk editor

Shopify’s bulk editor is a spreadsheet-like table in the admin. From Products, tick the products, click Bulk edit, then use Columns to add the fields you want (Bulk editing products). Shopify’s help on packages says you can add a packed product size to variants in bulk with the bulk editor.

Useful habits:

• Fill down. Drag a cell’s fill handle over the cells below to copy one value down the column.
• Edit several cells at once. Select a range, type into the active cell, and the edit applies to every selected cell.
• Work in batches. Shopify notes that the more you change at once, the longer the save takes. A product type or a collection at a time is easier to check.

Best for: dozens of variants that share values, for example every variant of a mug range, when you are already in the admin.

Watch out for: there is no preview of what changes and no undo button for the batch. Check a few rows before you save.

Way 2: the product CSV

For hundreds of variants, or values that come from a supplier spreadsheet, a CSV is faster. Export your products, edit the columns, and import the file again. Shopify’s product CSV column reference lists the columns:

Column	What goes in it
Weight value (grams)	The variant weight in grams, as a whole number without the unit
Weight unit for display	g, kg, lb or oz: how the weight is shown, not the unit of the value
Packed product length / width / height	The packed size, in the dimension unit
Packed product dimension unit	cm or in

Common pitfalls:

1. Weights in kilograms in the grams column. A 0.42 kg mug is 420, not 0.42. The weight column is always grams, whatever display unit you pick.
2. Decimal commas. Spreadsheet apps in many European languages save 12,5. Check what your file contains before you import it.
3. Two sides filled, one empty. The packed size is not saved for that row.
4. Columns you did not mean to touch. An export holds every product field. Remove the columns you are not changing, or check them carefully, so the import does not rewrite prices or descriptions by accident.
5. One big import. Import ten rows first, check them in the admin, then do the rest.

Best for: large changes prepared in a spreadsheet, and teams used to working in Excel or Google Sheets.

Way 3: an app built for shipping data

Both built-in ways assume you already know which variants to change. The harder question in a big catalogue is often “which variants are still missing a weight or a packed size?” An app can help when you need any of these:

• a list of variants that miss a value, ideally with the ones that sell first;
• a rule such as “every variant of product type Mug ships at 12 × 12 × 11 cm”;
• a CSV import that matches rows by SKU and shows every change before it is saved;
• an undo for the last change.

Whatever you choose, check where it saves the values. For Shopify to use them at checkout they have to end up in the variant’s own weight and packed product size fields, not only in metafields or the app’s database.

Which way to use

Situation	Use
A few products	The product page
Dozens of variants with the same values	The bulk editor
Hundreds of rows from a spreadsheet	The product CSV
You don’t know which variants are missing values, or you want rules, a preview and undo	An app

FAQ

Can I bulk edit weight in Shopify without an app?

Yes. Use the bulk editor for smaller batches, or export a product CSV, change the weight column and import it again.

What unit does the Shopify CSV use for weight?

Grams, as a whole number. The “Weight unit for display” column only decides how the weight is shown.

Why didn’t my packed size save?

The most common reason is that only one or two of length, width and height were filled. Shopify saves the packed size only when all three are present.

Should I put the product’s own size in the packed size?

No. Packed size is the outer size after packing. Use the size of the item as it goes into the carton, wrapping included.