Invalid availability value
availability must be in stock or out of stock.
What is this issue?
availability must be in stock or out of stock.
availabilityWhat it looks like in your file
| id | availability | |
|---|---|---|
| 2 | MUG-01 | in_stock |
| 3 | TOTE-01 | Sold out |
| id | availability | |
|---|---|---|
| 2 | MUG-01 | in stock |
| 3 | TOTE-01 | out of stock |
This issue is fixed automatically. Upload your CSV to fix it now.
Fix nowWhy Meta rejects this
Meta only accepts its own two values, written with a space. Other values stop the product from uploading.
Meta-specific note
Meta's catalog takes only in stock and out of stock, written with a space. Google-style values like in_stock are converted for you; retired values like preorder have to be changed by hand.
Valid values / expected format
- ✓in stock
- ✓out of stock
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
- 1In Excel, click the column letter for the availability 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: in stock, out of stock.
- 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 CSV UTF-8 (Comma delimited).
Fix in Google Sheets
- 1In Google Sheets, select the availability column.
- 2Press Ctrl+H, find the invalid value and replace it with the correct one, then click Replace All.
- 3Accepted values: in stock, out of stock.
- 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 > 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, as they can change.
How StriveFormats detects this
StriveFormats checks the availability column against the exact list of accepted values for Meta. The comparison is case-sensitive, so any difference in capitalization or spelling is flagged as an invalid value.