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.
gtinWhat it looks like in your file
| id | gtin | |
|---|---|---|
| 2 | MUG-01 | 4.00638E+12 |
| 3 | TOTE-01 | 4006-3813-3393-1 |
| id | gtin | |
|---|---|---|
| 2 | MUG-01 | 4006381333931 |
| 3 | TOTE-01 | 4006381333931 |
This issue is fixed automatically. Upload your CSV to fix it now.
Fix nowWhy 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
- ✓8, 12, 13 or 14 digits (GTIN-8, UPC, EAN, ITF-14)
- ✓The last digit must be the correct check digit
- ✓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.
Fix in Excel
- 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.
- 2If values already show as 4.00638E+12, the digits are gone: copy the barcodes again from your supplier or product system.
- 3Press Ctrl+H and replace spaces and dashes with nothing.
- 4Check each barcode against the number printed on the packaging.
- 5Save as CSV UTF-8 (Comma delimited).
Fix in Google Sheets
- 1In Google Sheets, select the gtin column and go to Format > Number > Plain text before pasting barcodes.
- 2If values already show as 4.00638E+12, the digits are gone: copy the barcodes again from your supplier or product system.
- 3Press Ctrl+H and replace spaces and dashes with nothing.
- 4Check each barcode against the number printed on the packaging.
- 5Go to File > Download > Comma Separated Values (.csv).
Prevent it next time
- ✓Format barcode columns as Text before pasting, in every spreadsheet you use.
- ✓Copy GTINs from the manufacturer or GS1, never type them by hand.
- ✓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.