Re: Inventory Control

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26418
interpreted = N
texte = Yes to both questions.Using the [math] and [replace] contexts, you could easily reduce the cumulative quantity by 1. Regarding searches, you'd just one of the required search parameters that qty must be greater than 0. Then, you'd use triggers to scan the inventory db late each night and generate purchase orders for all items under re-order levels. That might be a bit of steep learning curve as a first project, but absolutely do-able.ph.>I'm a newbie and am evaluating WebCatalog to see how well it will serve my >needs for an ecommerce site. > >Is there a way to deduct each item ordered from the quantity available as >each order is processed? > >If so, is there a way to restrict the catalog items shown to only those >whose inventory quantity is greater than zero? > >Thanks, >Glenn > > >------------------------------------------------------------- >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 > ------------------------------------------------------------- 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: Inventory Control (Nicolas Verhaeghe 2000)
  2. Re: Inventory Control (Glenn Busbin 2000)
  3. Re: Inventory Control (John Butler 2000)
  4. Re: Inventory Control (Phil Herring 2000)
  5. Inventory Control (Glenn Busbin 2000)
Yes to both questions.Using the [math] and [replace] contexts, you could easily reduce the cumulative quantity by 1. Regarding searches, you'd just one of the required search parameters that qty must be greater than 0. Then, you'd use triggers to scan the inventory db late each night and generate purchase orders for all items under re-order levels. That might be a bit of steep learning curve as a first project, but absolutely do-able.ph.>I'm a newbie and am evaluating WebCatalog to see how well it will serve my >needs for an ecommerce site. > >Is there a way to deduct each item ordered from the quantity available as >each order is processed? > >If so, is there a way to restrict the catalog items shown to only those >whose inventory quantity is greater than zero? > >Thanks, >Glenn > > >------------------------------------------------------------- >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 > ------------------------------------------------------------- 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 Phil Herring

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:

Euro Converter (1999) OT: recover corrupted data (2003) Search syntax question (1998) [WebDNA] Digest from talk@webdna.us (2018) still facing truncated [texta] problem (2000) WebCat2 several catalogs? (1997) AppleScript question (1997) BGcolor (1997) Only charge card when product shipped ? (1997) Note added to [sendmail] in Docs (2004) [WebDNA] 301 redirect (2010) & in Lookups (1997) Re:2nd WebCatalog2 Feature Request (1996) Download Question (1997) Extracting a Word (2000) Email within tmpl ? (1997) Re:Emailer and encryption (1997) [convertchars] Problem (2000) More DateMath problems (1997) Re:no [search] with NT (1997)