Barcode lost its leading zero in Excel - get the UPC back

LabelCraft - barcode labels for Shopify that print at exactly the size you set.

EN · FR · DE · ES

The guarantees behind every label

Exact to ±0.1 mm

Every label prints at the size you set - measured, not approximate.

Never a silent failure

Overflow or a missing barcode always raises a visible warning before you print.

Whole-dot barcodes

Modules snap to your printer's dots, so codes stay crisp and scan first time.

Your barcodes, untouched

We never overwrite or reassign a product's existing barcode.

You exported barcodes to a spreadsheet, did some edits, pasted them back into Shopify - and now a UPC won't scan to the right product. The usual cause is silent: Excel and Google Sheets treat a barcode column as a number, and a number can't begin with 0. So a valid 12-digit UPC-A like 036000291452 is read as 36000291452 and re-saved with only 11 digits. The leading zero is gone, and nothing warned you.

The 11-digit signature

A UPC-A is always 12 digits. If a barcode that should be UPC-A comes back from a spreadsheet with only 11 digits, that short length is the tell-tale signature of a dropped leading zero. The fix is almost always to put the 0 back on the front - not to invent a new number. Prepend the 0 and re-check the GS1 check digit to confirm.

Worked example. The valid 12-digit UPC-A 036000291452 survives a spreadsheet round-trip as 36000291452 - 11 digits, the leading 0 stripped. Prepend the 0 back to get 036000291452 again, and it passes the check digit, so you know the original value is restored.

Restore it

Spot the short value: a barcode that should be UPC-A but holds only 11 digits.
Prepend a single 0 to the front - e.g. 36000291452 becomes 036000291452.
Re-check the GS1 check digit on the restored 12-digit value. If it passes, the number is genuinely back.
Re-paste the verified 12-digit number into Shopify - copy the restored value, don't retype it.

Don't recompute the check digit

When a value is one digit short it is tempting to recalculate a check digit so it looks valid. Don't. A dropped leading zero is a presentation loss, not a data-entry error - the real 12-digit number is intact, you just need the 0 back. Recomputing the check digit on the 11-digit value produces a different, wrong GTIN that points the scanner at the wrong product. Restore and re-paste; never recompute.

Stop it happening again

Before you paste barcodes in, format the spreadsheet column as Text (not General or Number). Text columns keep every leading zero.
Or prefix each value with a single apostrophe ('036000291452) - Excel and Google Sheets store the rest as literal text and the 0 stays.
Re-export from the source rather than re-typing, and check the digit length before importing - a UPC-A must be 12 digits.

How LabelCraft guards the import

LabelCraft's import audit never lets a dropped zero through silently. When it sees an 11-digit value where a UPC-A is expected, it flags it as a suspected dropped-leading-zero. It then tries prepending a 0, and if the result is a check-digit-valid GTIN it offers that restored value for you to paste in. It is never auto-applied - you confirm it - because a barcode that scans to the wrong product is the worst failure the app could ship, so LabelCraft surfaces the suspicion rather than guessing for you.

Install free - 200 labels per month →

More guides: UPC vs EAN-13 vs GTIN-14 leading zeros, the GTIN check digit, add barcodes in bulk - or contact LabelCraft support.