Forum Discussion
Barcode Scan with 11 Digit UPC
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?
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.
2 Replies
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.
Thanks for the info. Pulling in the check digit from another table is the route I will have to go it looks like.
