How do I fix "Invalid availability value"?

Use one of the five values. Google-style values like in_stock and pre_order, and words like "Sold out", are converted automatically.

TikTokInventoryImport blockerAuto-fixable

Invalid availability value

availability must be in stock, available for order, preorder, out of stock or discontinued.

What is this issue?

availability must be in stock, available for order, preorder, out of stock or discontinued.

Affected field:availability

Import blocker: your file will fail to import until this is resolved.

What it looks like in your file

In your file

	sku_id	title	availability
2	MUG-01	Acme Ceramic Coffee Mug, 12 oz	in_stock
3	TOTE-01	Acme Canvas Tote Bag, Natural	Pre-order

After the fix

	sku_id	title	availability
2	MUG-01	Acme Ceramic Coffee Mug, 12 oz	in stock
3	TOTE-01	Acme Canvas Tote Bag, Natural	preorder

This issue is fixed automatically. Upload your CSV to fix it now.

Fix now

Why TikTok rejects this

TikTok only accepts its own five values. Other values stop the product from uploading.

TikTok-specific note

TikTok takes five values: in stock, available for order, preorder, out of stock and discontinued, written with spaces. Google-style values like in_stock and pre_order are converted for you.

Valid values / expected format

✓in stock
✓available for order
✓preorder
✓out of stock
✓discontinued

Fix in StriveFormats

This issue is auto-fixable. Upload your CSV and click Fix Issues to apply all safe corrections at once.

Auto-fixable: this issue is corrected automatically when you click Fix Issues.

Open CSV Fixer View template TikTok Fixer guide

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, available for order, preorder, 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, available for order, preorder, 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 TikTok. The comparison is case-sensitive, so any difference in capitalization or spelling is flagged as an invalid value.

►Technical detail

TikTok's importer checks this field against a fixed list of accepted values. These are often short codes for internal settings; for example, "active" and "draft" set whether a product is visible. The match is exact and case-sensitive: an extra space, different capitalization, or a synonym (like "enabled" instead of "active") gets the value rejected. The allowed values can change between platform versions, so always check the latest template.