Home Page link  

Inventory Database Merger

 

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Inventory Database Merger Pheasant 07-05-2008
Posted by Pheasant on July 5, 2008, 10:33 am
Please log in for more thread options
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,

Posted by Craig on July 5, 2008, 11:55 am
Please log in for more thread options
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,


Posted by Gaz on July 7, 2008, 7:05 am
Please log in for more thread options
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

"Craig" wrote:

> 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,
>
>

Posted by JerryData on July 7, 2008, 5:42 pm
Please log in for more thread options
If you are entering the items one-by-one, you might as well just enter them
into RMS! Then you will avoid dupes.
--
-Jerry
JR Data Inc.


"Pheasant" wrote:

> 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,

Similar ThreadsPosted
Moving broken inventory out of database May 28, 2006, 3:35 pm
Pysical inventory updating database October 25, 2006, 1:48 pm
Food Inventory Database Download December 2, 2006, 10:46 pm
Download Grocery Store Inventory database February 12, 2007, 1:35 am
Import database and inventory form SYMFINITE (datasym) to MRS October 4, 2006, 12:53 pm
Worksheet 51 to copy from HQ database to each store database July 8, 2008, 12:07 pm
Can connect to HQ database but not Store database November 16, 2005, 12:17 am
synchronize a store database to another HQ database June 8, 2006, 9:52 am
2B-Inventory October Giveaway - Mobile Inventory Management September 1, 2006, 1:58 pm
2B-Inventory Giveaway - Mobile / Handheld Inventory Management October 27, 2006, 2:06 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap