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:
newbie question about zip code search (2003)
What am I missing (1997)
Mail Server Needed. (1998)
Re1000001: Setting up shop (1997)
Cookies (1999)
Math, Multiple Equasions and Show/Hide (1998)
Merging databases (1997)
new storefront (2003)
Navigator Parsing (1997)
access denied problem (1997)
Exclamation point (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Cumulative Shipping charge calculations - your help please. (1997)
Note added to [sendmail] in Docs (2004)
details (2003)
[Fwd: Rotating Banners ... (was LinkExchange)] (1997)
WebDNA permissions? (2002)
default value from Lookup (was Grant, please help me) (1997)
Template transformed itself into a database? (1998)
macosx 1 process, linux N processes, macosx chokes under load (2001)