Missing SKU

What is this issue?

The sku field is required for every Amazon inventory row.

Why Amazon rejects this

Amazon uses the SKU to uniquely identify your listings. Rows without a SKU are rejected.

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 sku 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 sku 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 sku column by verifying that each cell is a non-negative whole number. Decimal values, negative numbers, text strings, and blank cells are all flagged.