Subject | Best approach to storing suppliers' barcodes and map them to products in a database |
---|---|
Author | Fidel Viegas |
Post date | 2008-11-27T04:26:20Z |
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.
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.