Re: retail integration

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26563
interpreted = N
texte = > I am looking for recommendations on how best to integrate a WebCat-driven > web database and a local desktop database that is in a retail store. > One reason that I would want to do this is for inventory checking. > Another reason would be for database administration (i.e., using a > Point-of-Sale system or local desktop database app to administer the > database rather than building web-based admin). I am interested in > finding out how others are handling this situation and whether your > implementations are working well. One scenario would be to sync up the > databases once per day or something, but this seems a bit cumbersome. Is > there a better way to integrate the web-based and desktop-based databases > in more real-time fashion?I would recommend that they access the same db source, if you can access the pos system with ODBC, this should work well. I would try to stay away from syncing as it could cause data consistency problems if an item is sold online and in the store, the quantity may go negative.Just an idea,Jason Tyler www.3ip.net ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: retail integration (Jason Tyler 2000)
  2. retail integration (Brian Wachter 2000)
> I am looking for recommendations on how best to integrate a WebCat-driven > web database and a local desktop database that is in a retail store. > One reason that I would want to do this is for inventory checking. > Another reason would be for database administration (i.e., using a > Point-of-Sale system or local desktop database app to administer the > database rather than building web-based admin). I am interested in > finding out how others are handling this situation and whether your > implementations are working well. One scenario would be to sync up the > databases once per day or something, but this seems a bit cumbersome. Is > there a better way to integrate the web-based and desktop-based databases > in more real-time fashion?I would recommend that they access the same db source, if you can access the pos system with ODBC, this should work well. I would try to stay away from syncing as it could cause data consistency problems if an item is sold online and in the store, the quantity may go negative.Just an idea,Jason Tyler www.3ip.net ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Jason Tyler

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

A multi-processor savvy WebCatalog? (1997) problems with WebCat-Plugin (1997) Pgp&emailer (1997) Multiple Passwords (1997) Chatroom (2000) Disappearing data (2002) Bug Report, maybe (1997) Press Release hit the NewsWire!!! (1997) WebCat editing, SiteGuard & SiteEdit (1997) Multiple Ad databases? (1997) setcookie getcookie on the same page (2003) Help with Shipping Costs (1997) Trouble with formula.db (1997) Multiple prices (1997) [MATH] and Dates (1998) linetiems in thankyou.tpl (1997) How to Ignore Your Best Customers (2003) purchase plugin (1996) Major bug report on rootbeer (1997) [FoundItems] solved - thanks (1997)