Hello (different user here than the OP). Adding on to that, lets say just for easy math I have only 10 items I am selling that are all in the POS with their own unique barcode. I get a new order in and I add them to the inventory as you listed above however there is a new item with a new barcode. Now my employees may not be able to distinguish that this is a new item with a new barcode not yet in the database. If they try and scan the barcode and add it to stock, what will happen? And will it alert them it is not in the database so they could be a new "Product" for it with all the correct information (ie.: price, name, barcode, etc.)?
Or is there a better way for us to check for new barcodes on new shipments that may not be in the system. The thing is we will get a shipment in of perhaps 10,000 sunglasses! They all look somewhat alike so it is hard to know if it is already in the system or a new style that just came out.
Thanks for the help as always! =)