Invalid expedited-shipping value
The expedited-shipping field contains something other than Amazon's shipping option names.
What is this issue?
The expedited-shipping field contains something other than Amazon's shipping option names.
expedited-shippingWhat it looks like in your file
| sku | expedited-shipping | |
|---|---|---|
| 2 | MUG-01 | y |
| 3 | TOTE-01 | no |
| sku | expedited-shipping | |
|---|---|---|
| 2 | MUG-01 | Next,Second |
| 3 | TOTE-01 | N |
Upload your CSV to check for this issue and export a clean file.
Fix nowWhy Amazon rejects this
Amazon's Inventory Loader expects a comma-separated list of the faster shipping options you offer: Next (one day), Second (two day), Domestic, International and Plus. N or a blank cell means none. Words like yes or true, or anything else, can't be matched to an option.
Amazon-specific note
expedited-shipping isn't a yes/no field. It lists the faster shipping options you offer, separated by commas: Next (one day), Second (two day), Domestic, International and Plus. For example, Next,Second offers one-day and two-day shipping. Use N, or leave the cell blank, if you offer none.
Valid values / expected format
- ✓Next
- ✓Second
- ✓Domestic
- ✓International
- ✓Plus
- ✓N
Fix in StriveFormats
Upload your CSV to StriveFormats to detect this issue across all rows, with clear line-by-line reporting.
Fix in Excel
- 1In Excel, click the column letter for the expedited-shipping column.
- 2Press Ctrl+H. Type the invalid value in 'Find what' and the correct value in 'Replace with', then click Replace All.
- 3The accepted values are: Next, Second, Domestic, International.
- 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.
- 5Save as Text (Tab delimited) (*.txt).
Fix in Google Sheets
- 1In Google Sheets, select the expedited-shipping column.
- 2Press Ctrl+H, find the invalid value and replace it with the correct one, then click Replace All.
- 3Accepted values: Next, Second, Domestic, International.
- 4To add a validation dropdown: select the column, go to Data > Data Validation, choose 'Dropdown (from a list)', and enter the valid options.
- 5Go to File > Download > Tab Separated Values (.tsv), then rename the file to end in .txt.
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, as they can change.
How StriveFormats detects this
StriveFormats splits each expedited-shipping cell at the commas and checks every part against Amazon's option names, in any capitalization. A blank cell or N passes; anything else, such as y, yes or Standard, is flagged.