StriveFormats
Shopifyinventory

Negative inventory

Inventory quantity is negative.

What is this issue?

Inventory quantity is negative.

Affected field:Negative inventory

Why Shopify rejects this

Negative inventory is usually a data error and can create fulfillment issues.

Shopify-specific note

Shopify requires TRUE or FALSE in all caps. A blank cell is treated as FALSE for most boolean fields. Do not use Yes, No, 1, or 0 -- Shopify's importer will reject them.

Valid values / expected format

  • ✓TRUE
  • ✓FALSE
  • ✓(blank -- treated as FALSE for most boolean fields)

Examples

Bad valueGood valueNote
yesTRUEMust be uppercase
1TRUE
NoFALSE
0FALSE
TrueTRUEMixed case not accepted

Fix in StriveFormats

Upload your CSV to StriveFormats to detect this issue across all rows, with clear line-by-line reporting.

Open CSV FixerView templateShopify Fixer guideShopify ecommerce guide

Fix in Excel

  1. 1In Excel, click the column letter for the Negative inventory column to select the entire column.
  2. 2Press Ctrl+H to open Find & Replace.
  3. 3In 'Find what', type: yes -- in 'Replace with', type: TRUE -- check 'Match entire cell contents' -- click Replace All.
  4. 4Repeat: no -> FALSE, 1 -> TRUE, 0 -> FALSE.
  5. 5Also replace: True -> TRUE, False -> FALSE.
  6. 6Scan the column to confirm only TRUE and FALSE remain (and blanks if allowed).
  7. 7Save as CSV (Comma delimited).

Fix in Google Sheets

  1. 1In Google Sheets, click the column letter for the Negative inventory column to select the whole column.
  2. 2Press Ctrl+H to open Find & Replace.
  3. 3Set Find: yes -- Replace with: TRUE -- check 'Match entire cell contents' -- Replace All.
  4. 4Repeat: no -> FALSE, 1 -> TRUE, 0 -> FALSE, True -> TRUE, False -> FALSE.
  5. 5Verify only TRUE and FALSE remain in the column.
  6. 6Go to File > Download > Comma Separated Values (.csv).

Prevent it next time

  • --Always type TRUE or FALSE (all caps) -- do not use spreadsheet checkboxes; export them as text instead.
  • --If you export data from the platform's own admin panel, do not modify boolean columns in Excel -- autocorrect can silently change the values.
  • --Set the cell format to Text in Excel before pasting boolean values to prevent automatic conversion.
  • --Use StriveFormats auto-fix as a final pass before every import.

How StriveFormats detects this

StriveFormats reads every cell in the Negative inventory column and checks it against Shopify's accepted boolean values. Any value that does not match exactly -- including mixed-case variants like "True" or "Yes" -- is flagged as an error.

►Technical detail
Shopify's importer performs an exact, case-sensitive match on boolean fields. Only the uppercase strings TRUE and FALSE are accepted. Spreadsheet applications commonly produce alternative representations: Excel exports checkbox cells as TRUE/FALSE (which works), but "true" (lowercase), "Yes", "1", or "checked" will all fail. The blank value is treated as FALSE for most boolean fields, so leaving optional boolean fields empty is safe.