UPC Database for Liquor Store

Matt, I have one, but you should anticipate some issues before you decide to use someone else's database, as opposed to building your own from scratch. Here are some of the issues:

1) Length of the barcode. Some end users use all 12 UPC A characters, some use the 1st 11 characters and some use only the middle 10 characters, leaving off the preamble and check digits. 2) All liquor, beer and wine products are not sold in all states. It is usually up to the distributors to make these decisions 3) How will you generate P.O.s and receive, by Distributor Part #(Alias)? If so, all distributors use their own proprietarty Part #, so you would have to enter manually unless you could find a local database. 4) The cost for products is going to vary by liquor store, depending on how they buy (quantity and deals) 5) Selling Price of each product will have to be changed, as all retailers make their own pricing decisions. 6) Suppliers (Distributors) will be unique for each state, so these will have to be entered manually. 7) Departments and categories may (probably will) be different for each database.

I have a liquor database for Arkansas that I have maintained over 20 years, we install lots of liquor store systems, and the fact that we have a current, clean database has closed lots of deals. But I think you will spend as much time modifying someone else's database as you will spend creating your own, in this case.

Kinnard L. Kohler Business Machines Systems

6101 South Shackleford Road Little Rock, AR 72204-8606 (T) 501-375-8380 (F) 501-375-0043 (Cell) 501-412-5686 Email: snipped-for-privacy@bmsar.com

"Matt Nachtrab" wrote: