Editing Dimension Metafields with a Spreadsheet
With Shopify you have the ability to create metafield definitions for dimensions like weight, length and volume. You can use the Bulk Product Editor to set these values with a spreadsheet however you'll need to include the unit in the spreadsheet column.
For example, assuming you have the necessary metafield definitions on your store, the following will not work:
Adding the units to the fields will work:
Supported Units
Valid options for the units are:
- Weights: g, oz, kg, lb
- Lengths: mm, cm, m, in, ft, yd
- Volumes: ml, cl, l, m3, fl_oz, pt, qt, gal, imp_fl_oz, imp_pt, imp_qt, imp_gal
Why do you need the units?
The app needs the units because dimension metafields actually contain two pieces of information, the measurement value and the unit type
There's no way to set a default unit type for a metafield definition so it needs to be included in each column
Adding the unit to a whole column
You can use Excel or Google Sheets formulas to quickly add a unit to a whole column Make sure to include a space between the number and the unit and please reach out if you're having difficulties.