Forum Discussion

mossmic1's avatar
mossmic1
Regular Visitor
10 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    10 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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's avatar
    mossmic1
    Regular Visitor
    10 years ago

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