Invalid quantity

What is this issue?

The quantity value must be a non-negative integer.

Why Amazon rejects this

Amazon rejects rows where quantity is not a valid number. Negative quantities are not accepted.

Valid values / expected format

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

Examples

Fix in StriveFormats

Upload your CSV to StriveFormats to detect this issue across all rows, with clear line-by-line reporting.

Fix in Excel

1. 1In Excel, click the column letter for the Quantity 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 Quantity 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

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

How StriveFormats detects this

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