StriveFormats
MetaSKUs & IDsImport blockerAuto-fixable

Invalid GTIN

The gtin isn't 8, 12, 13 or 14 digits with a correct check digit, or a spreadsheet turned it into scientific notation.

What is this issue?

The gtin isn't 8, 12, 13 or 14 digits with a correct check digit, or a spreadsheet turned it into scientific notation.

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

What it looks like in your file

In your file
idgtin
2MUG-014.00638E+12
3TOTE-014006-3813-3393-1
After the fix
idgtin
2MUG-014006381333931
3TOTE-014006381333931

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

Fix now

Why Meta rejects this

Meta asks for a GTIN only if you're sure it's correct. A wrong one can match the product to someone else's.

Meta-specific note

Meta asks for a GTIN only when you're sure it's right. A wrong one can match your product to someone else's in ads and shops, so a blank gtin with a brand is better than a guess.

Valid values / expected format

  1. ✓8, 12, 13 or 14 digits (GTIN-8, UPC, EAN, ITF-14)
  2. ✓The last digit must be the correct check digit
  3. ✓Digits only: no spaces, dashes or letters

Fix in StriveFormats

StriveFormats removes spaces and dashes, restores a leading zero when the check digit proves it was dropped, and flags GTINs with the wrong length, a wrong check digit or scientific notation.

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

Fix in Excel

  1. 1In Excel, select the gtin column, right-click it and choose 'Format Cells' > 'Text'. Do this before pasting barcodes, or Excel turns them into scientific notation.
  2. 2If values already show as 4.00638E+12, the digits are gone: copy the barcodes again from your supplier or product system.
  3. 3Press Ctrl+H and replace spaces and dashes with nothing.
  4. 4Check each barcode against the number printed on the packaging.
  5. 5Save as CSV UTF-8 (Comma delimited).

Fix in Google Sheets

  1. 1In Google Sheets, select the gtin column and go to Format > Number > Plain text before pasting barcodes.
  2. 2If values already show as 4.00638E+12, the digits are gone: copy the barcodes again from your supplier or product system.
  3. 3Press Ctrl+H and replace spaces and dashes with nothing.
  4. 4Check each barcode against the number printed on the packaging.
  5. 5Go to File > Download > Comma Separated Values (.csv).

Prevent it next time

  1. ✓Format barcode columns as Text before pasting, in every spreadsheet you use.
  2. ✓Copy GTINs from the manufacturer or GS1, never type them by hand.
  3. ✓Don't invent a GTIN. If a product has none, leave gtin blank and fill in brand or mpn.

How StriveFormats detects this

StriveFormats strips spaces and dashes from each gtin, checks that it has 8, 12, 13 or 14 digits, and recalculates the check digit. Values in scientific notation are flagged because their digits can't be recovered.

►Technical detail
A GTIN's last digit is a check digit calculated from the others, so a typo or a lost digit almost always shows up as a wrong check digit. Spreadsheets cause most GTIN errors: long numbers are shown as 4.00638E+12 and saved that way, and leading zeros are dropped from UPCs. StriveFormats only adds a zero back when the check digit proves the shorter number was a 12- or 13-digit GTIN missing its first zero.