Barcode Scan with 11 Digit UPC

[mossmic1]

My UPC data is all store with an 11 digit UPC (UPC without the check digit). I took a first pass at creating a report with the UPC set up as a barcode, but no matter what I scan I do not come up with data. Can the barcode scan make the match between the UPC on a product and an 11 digit UPC in my data?

[Seth_C_Bauer · Accepted solution]

@mossmic1 Have you looked into just adding the check digit?

There is this site to test out a few UPC's to see if it works as expected.

And depending on what your database back end looks like, here is an example of how to create a SQL function to return the check digit. You could append this to the existing 11 digit UPC in a new column for reporting purposes.

[mossmic1]

Thanks for the info. Pulling in the check digit from another table is the route I will have to go it looks like.