Re: webCatalog and Stocks
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16792
interpreted = N
texte = At 6:29 AM -0800 3/27/98, Giovanna Petrachi is rumored to have typed:> Thank you Michael, > your source has been very helpful for the resolution of my problem. But now > I've another trouble: what happens if someone do not complete the order and > close connection? > I need to set a timeout after which webcatalog cancel the suspend order. > I.e, I'm managing a DB in which some products have inventory=1. Anytime > someone order one of this product, Webcatalog add it in a cart and baffle > the order. So if a user do not want to bye product in the cart and do not > remove it but simply close connection, WebCat do not permit to another user > to order it. > > What can I do for the resolution of this problem?I have two inventory fields in my database (INV and HOLD). When someone adds an item to their cart, I move the amount from INV to HOLD. When they delete items, I move it back.Often, a shopper will put stuff in their cart and not buy it. When that happens, I have a script that runs once an hour (thanks to PageSentry) which finds carts more than 24 hours old, loops through the lineitems, and puts their items back into INV. When it's done, it deletes the cart.MichaelMichael Winston *By Phone!: (503)/652/8815 x341 Internet Coordinator *By e-mail!: michaelw@dhorse.com Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/
Associated Messages, from the most recent to the oldest:
At 6:29 AM -0800 3/27/98, Giovanna Petrachi is rumored to have typed:> Thank you Michael, > your source has been very helpful for the resolution of my problem. But now > I've another trouble: what happens if someone do not complete the order and > close connection? > I need to set a timeout after which webcatalog cancel the suspend order. > I.e, I'm managing a DB in which some products have inventory=1. Anytime > someone order one of this product, Webcatalog add it in a cart and baffle > the order. So if a user do not want to bye product in the cart and do not > remove it but simply close connection, WebCat do not permit to another user > to order it. > > What can I do for the resolution of this problem?I have two inventory fields in my database (INV and HOLD). When someone adds an item to their cart, I move the amount from INV to HOLD. When they delete items, I move it back.Often, a shopper will put stuff in their cart and not buy it. When that happens, I have a script that runs once an hour (thanks to PageSentry) which finds carts more than 24 hours old, loops through the lineitems, and puts their items back into INV. When it's done, it deletes the cart.MichaelMichael Winston *By Phone!: (503)/652/8815 x341 Internet Coordinator *By e-mail!: michaelw@dhorse.com Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/
Michael Winston
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:
MasterCounter Weirdness -Resolved! (1997)
Ticks Email Preference (2002)
[SearchString] problem with [search] context (1997)
The Send Mail Button is the Best Troubleshooter (1998)
The IBC root beer has arrived! (1997)
Date or time comparisons have bugs ... (1998)
Re:2nd WebCatalog2 Feature Request (1996)
[lookup] speed sales pitch (2003)
PCS Frames (1997)
Setting up the server (1997)
Limit to Field Length in DB (1998)
Cart doesn't interpret tag! (1997)
New command suggestion (was Modifying databases manually) (1997)
default error on NT? (1997)
shipCost not working v2.1b4 (1997)
Serial Number Question (1997)
My web page only... (2003)
Re:listfiles-looking for slick solution (1997)
Doesn't change (WebCat 4.0) (2000)
Reversed words (1997)