Format UPC or EAN column

Before importing UPCs or EANs, be sure that the column is formatted properly before importing to your account. You do not need to have the exact amount of digits; for instance if you import 11 digit UPCs, our system will automatically add the leading 0 to make it a 12 digit UPC. However, be sure that excel doesn’t truncate your UPCs or EANs. This commonly happens when you open a file with excel that contains all numbers in a single column. If the numbers are truncated and you re-save the file, it will cause issues and corrupt the imported data. Screenshots below:

upc-ean-truncated

Once the column is formatted, save the file as a CSV. If you close and open the file back up, you’ll notice the column will be truncated again by Excel. Don’t worry though, the saved file is formatted properly.

Leave a Reply