Invalid weight unit

What is this issue?

Weight unit for display is not g, kg, lb, or oz.

Why Shopify rejects this

Shopify only accepts g, kg, lb, or oz as the display unit.

Valid values / expected format

1. ✓Whole number (integer), 0 or greater
2. ✓No decimal places -- write 10 not 10.5
3. ✓No negative values -- use 0 for out-of-stock items

Examples

Fix in StriveFormats

This issue is auto-fixable. Upload your CSV and click Fix Issues to apply all safe corrections at once.

Fix in Excel

1. 1In Excel, click the column letter for the Invalid weight unit column.
2. 2Right-click and choose 'Format Cells'. Select 'Number', set Decimal places to 0, click OK.
3. 3Use Data > Filter on this column. Filter where value is less than 0 and change those cells to 0.
4. 4Also filter for non-numeric values (text cells) and enter the correct whole number.
5. 5Save as CSV (Comma delimited).

Fix in Google Sheets

1. 1In Google Sheets, click the column letter for the Invalid weight unit column.
2. 2Go to Format > Number > Number and set decimal places to 0 (integers only).
3. 3In a blank helper column, enter =MOD(A2,1) (replace A2 with your column) and copy it down. Rows showing non-zero have decimal values -- round them manually.
4. 4Delete the helper column when done.
5. 5Go to File > Download > Comma Separated Values (.csv).

Prevent it next time

1. ✓Export quantity data from your inventory system as whole numbers.
2. ✓Use 0 for out-of-stock items -- do not leave the quantity blank.
3. ✓Never copy-paste quantity data from a financial system that uses decimal places.

How StriveFormats detects this

StriveFormats validates the Invalid weight unit column by verifying that each cell is a non-negative whole number. Decimal values, negative numbers, text strings, and blank cells are all flagged.