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:
StatusImport 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 value | Good value | Note |
|---|---|---|
other_value | Active | Must 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
- 1In Excel, click the column letter for the Status column.
- 2Press Ctrl+H. In 'Find what', type the invalid value -- in 'Replace with', type the correct accepted value -- Replace All.
- 3The accepted values are: Active, Draft, Archived.
- 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 (Comma delimited).
Fix in Google Sheets
- 1In Google Sheets, select the Status column.
- 2Press Ctrl+H. Find the invalid value -- Replace with the correct accepted value -- Replace All.
- 3Accepted values: Active, Draft, Archived.
- 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 -- 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.