Invalid add-delete value

What is this issue?

The add-delete field must be 'a' (add/update) or 'd' (delete).

Why Amazon rejects this

An invalid add-delete value causes Amazon's processor to skip the row.

Valid values / expected format

• ✓a (add/update)
• ✓d (delete)

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 Invalid add-delete value column.
2. 2Press Ctrl+H. In 'Find what', type the invalid value -- in 'Replace with', type the correct accepted value -- Replace All.
3. 3The accepted values are: a (add/update), d (delete).
4. 4To prevent future errors, add a dropdown: select the column, go to Data > Data Validation, choose 'List', and enter the valid options separated by commas.
5. 5Save as CSV (Comma delimited).

Fix in Google Sheets

1. 1In Google Sheets, select the Invalid add-delete value column.
2. 2Press Ctrl+H. Find the invalid value -- Replace with the correct accepted value -- Replace All.
3. 3Accepted values: a (add/update), d (delete).
4. 4To add a validation dropdown: select the column, go to Data > Data Validation, choose 'Dropdown (from a list)', and enter the valid options.
5. 5Go to File > Download > Comma Separated Values (.csv).

Prevent it next time

• --Copy-paste allowed values directly from the official template to avoid typos.
• --Use Excel Data Validation or Google Sheets Data Validation to restrict the column to a dropdown of allowed values.
• --Check the platform's official documentation for the current list of allowed values -- they can change.

How StriveFormats detects this

StriveFormats checks the Invalid add-delete value column against the exact list of accepted values for Amazon. The comparison is case-sensitive -- any casing variation or typo is flagged as an invalid value.