Subject Best approach to storing suppliers' barcodes and map them to products in a database
Author Fidel Viegas
Hi all,

I have implemented a POS system a while ago, and now I have added
support for barcodes. Since I had a field for the item code, I have
used that to generate barcodes. I managed to get that working. But,
unfortunately, the client wants to be able to insert into the system
the barcodes that come with the products, and from what I could see
each item has its own barcode. So, my question is what is the best
approach to allow it to associate the items with the supplier's
barcodes. Shall I create a table that will map the item id to the
barcode? What would be the best approach to solve this problem?

I look forward to hearing from your suggestions.

Thanks in advance,

Fidel.