Meijer UPCs & Check Digits

Owned by Avantalytics Support
Last updated: Jan 08, 2021 by Daniel Fitzpatrick (Unlicensed)
1 min read

Problem

When clients who service Meijer go to set up new items in Avantalytics they need to provide an item → UPC map in order to have the Meijer EDI data report correctly at the item level. However lookups for new items in Meijer VendorNet provide UPCs in 11-digit format while the EDI data reports data in the 12-digit (GTIN-12) format. Submissions with 11 digits therefore won't tie out to EDI results.

Solution

The solution resides in what is called a "check digit" in UPC GS1 parlance.  There are lots of tools that can calculate check digits

  1. Open this website https://www.gs1.org/services/check-digit-calculator  and enter your 11 digit UPC, it will provide you the 12th (check) digit.
  2. Use the 12 digit UPC for your item setup.

If you run into this a lot you can create an Excel file with a formula for calculating the check digit by following the steps in the link below:

https://www.mrexcel.com/forum/excel-questions/310146-calculating-upc-barcode-check-digits.html