StriveFormats
ShopifycomplianceImport blockerAuto-fixable

Invalid Status value

Status is not one of Active, Draft, Archived.

What is this issue?

Status is not one of Active, Draft, Archived.

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

Why Shopify rejects this

Unexpected status values can cause Shopify to ignore or misinterpret a row.

Valid values / expected format

  • Active
  • Draft
  • Archived

Examples

Bad valueGood valueNote
other_valueActiveMust be one of: Active, Draft, Archived

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.

Fix in Excel

  1. 1In Excel, click the column letter for the Status 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: Active, Draft, Archived.
  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 Status column.
  2. 2Press Ctrl+H. Find the invalid value -- Replace with the correct accepted value -- Replace All.
  3. 3Accepted values: Active, Draft, Archived.
  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 Status column against the exact list of accepted values for Shopify. The comparison is case-sensitive -- any casing variation or typo is flagged as an invalid value.

Technical detail
Shopify's importer validates this field against a fixed list of accepted values defined in its import specification. These values are often short codes that map to internal states -- for example, "active"/"draft" map to product visibility states. The match is case-sensitive and exact: an extra space, a different casing, or a synonym (like "enabled" instead of "active") will cause the value to be rejected. The allowed values can change between platform versions, so always refer to the most recent template.