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
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
"Matt Nachtrab" wrote:
Matt you might try the local edition of beverage journal many of them have
current databases available electronically. Importing and merging the fields
may be another story. Good luck
"Matt Nachtrab" wrote:
BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here.
All logos and trade names are the property of their respective owners.
Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee
neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.