I am not doing a POS system but I am working on a project that incorporates inventory and barcode scanning. I previously added inventory items and was looking at ways to keep track of items using barcodes. As far as implementation the more I work with it the more I see using the barcode as the primary key seems like the best solution I have come yup with so far.
By doing this when using the barcode scanner it creates a file I can import later and uses the barcode as the primary key for easy updates and the quantity as another field. By doing some minor editing of the barcode scanner file in excel and working with only 2 fields (Primary key which is the barcode and quantity) I can import the file into the database quickly and update my actual inventory levels.
Any additional input or ideas would be greatly appreciated as my project is under development as far the inventory section.