StriveFormats
CSV Fixer
Google Merchant CenterAttributesAuto-fixable

Invalid yes/no value

identifier_exists, adult or is_bundle must be yes or no.

What is this issue?

identifier_exists, adult or is_bundle must be yes or no.

Affected field:identifier_exists

What it looks like in your file

In your file
ididentifier_exists
2MUG-01FALSE
3TOTE-01Y
After the fix
ididentifier_exists
2MUG-01no
3TOTE-01yes

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

Fix now

Why Google Merchant Center rejects this

Other values are ignored, so Google falls back to its default for that attribute.

Google Merchant Center-specific note

identifier_exists, adult and is_bundle take yes or no. Google ignores other values and falls back to the attribute's default, so a product that should be marked adult or bundled may not be.

Valid values / expected format

  1. ✓yes
  2. ✓no

Fix in StriveFormats

Auto-fix normalizes common boolean variants (yes/no, 1/0, True/False) to the platform's exact required format. Upload your CSV and click Fix Issues.

Auto-fixable: this issue is corrected automatically when you click Fix Issues.
Open CSV FixerView templateGoogle Merchant Center Fixer guide

Fix in Excel

  1. 1In Excel, click the column letter for the identifier_exists column to select the entire column.
  2. 2Press Ctrl+H to open Find & Replace.
  3. 3In 'Find what', type TRUE, in 'Replace with', type yes, tick 'Match entire cell contents', then click Replace All.
  4. 4Repeat: FALSE -> no, 1 -> yes, 0 -> no, Y -> yes, N -> no.
  5. 5Scan the column to confirm only yes and no remain (and blanks if allowed).
  6. 6Save as Text (Tab delimited) (*.txt).

Fix in Google Sheets

  1. 1In Google Sheets, click the column letter for the identifier_exists column to select the whole column.
  2. 2Press Ctrl+H to open Find & Replace.
  3. 3Find TRUE, replace it with yes, tick 'Match entire cell contents', then click Replace All.
  4. 4Repeat: FALSE -> no, 1 -> yes, 0 -> no, Y -> yes, N -> no.
  5. 5Verify only yes and no remain in the column.
  6. 6Go to File > Download > Tab Separated Values (.tsv), then rename the file to end in .txt.

Prevent it next time

  1. ✓Type yes or no in lowercase. Don't use spreadsheet checkboxes; they export as TRUE and FALSE.
  2. ✓Only set identifier_exists to no for products that truly have no GTIN or MPN, such as handmade or custom items.
  3. ✓Use StriveFormats auto-fix as a final pass before every upload.

How StriveFormats detects this

StriveFormats reads identifier_exists, adult and is_bundle on every row. TRUE/FALSE, Y/N and 1/0 are converted to yes or no automatically, and anything else is flagged.

►Technical detail
Google's specification spells these attributes' values yes and no. Spreadsheets often turn them into TRUE and FALSE, and other feed tools write 1 and 0 or Y and N. Google doesn't treat those as yes or no, so the attribute is ignored. identifier_exists matters most: set to no, it tells Google the product has no GTIN or MPN, which stops the missing identifier warning for custom and handmade goods.