Apologies if this question has been asked before, but I couldn't find anything very close to what I'm trying to do.
Our store is running a single register with mostly food products that are priced by weight and using price embedded barcodes (EAN13) of the format 2LLLLLXXXXXC where L is a 5 digit lookup code and X is the price and C is check digit. 200239011192 is lookup code 00239 and a price of $11.19. Pretty basic, and works great with what our scale prints on our item labels. Our scale also prints out item totals of the same format so an item at $4.99/lb where we label 44.01 lbs of product prints out a total with a barcode like 200062219604. This is what we use to update quantities each time. The problem we run into is keeping our quantities in inventory correct. We add to the quantity multiple times per week (over 100 quantity updates/week) and as of right now it's entirely manual through the item database. The total weight (the number used in inventory) also prints out on the totals label but ideally I could scan the EAN13 barcode and somehow update our inventory that way.
I can manipulate an excel sheet to scan in and separate lookup code, price, and can type in quantity if I have to, then export it as tab delimited file for the inventory update wizard but that only overwrites the item inventory quantity, it doesn't add to quantities already in there. That's the problem I'm having and any help or a solution to this would be great. I find it hard to believe that we would be the only ones having this issue, but I don't know. Thanks in advance
*This post is locked for comments
I have the same question (0)
