Inventory Database Merger

We are just setting up our first brick & morter store and we have over 10K
items to enter into inventory. It would go faster if we could enter these on
2 or 3 different computers which means 2 or 3 different databases then merge
them all. Is this possible. I know nothing of SQL databases. Thanks,
Reply to
Pheasant
All three computers can be pointed to the same database, just make sure that each person has unique items to enter so as to not cause any mix-ups. One computer(or a server)would hold the database, and the other machines would be networked with the machine holding the database. Give each machine a unique IP address and point them to the IP address of the machine holding the database. Set up each machine using the Administrator program. Craig
> We are just setting up our first brick & morter store and we have over 10K > items to enter into inventory. It would go faster if we could enter these > on > 2 or 3 different computers which means 2 or 3 different databases then > merge > them all. Is this possible. I know nothing of SQL databases. Thanks,
Reply to
Craig
As well as what Craig suggests you could purchase a 3rd party import utility which would mean you could import excel sheets of product information supplied by your suppliers. This would greatly reduce your initial workload and pay for itself very quickly. I know of a great one that is not expensive and does a whole lot more than just the above. Let me know if you want some details
> All three computers can be pointed to the same database, just make sure that > each person has unique items to enter so as to not cause any mix-ups. One > computer(or a server)would hold the database, and the other machines would > be networked with the machine holding the database. Give each machine a > unique IP address and point them to the IP address of the machine holding > the database. Set up each machine using the Administrator program. > Craig >
> > We are just setting up our first brick & morter store and we have over 10K > > items to enter into inventory. It would go faster if we could enter these > > on > > 2 or 3 different computers which means 2 or 3 different databases then > > merge > > them all. Is this possible. I know nothing of SQL databases. Thanks, > >
Reply to
Gaz

Site Timeline Threads

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.