Re: webCatalog and Stocks
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16785
interpreted = N
texte = >Before the items are displayed on the cart page, I go through a [LINEITEMS]>loop to check the ordered quantity against the available inventory. If the>customer wants more than is available, I readjust their quantity and make a>note in htat line item:>>[LINEITEMS]>[SHOWIF [QUANTITY]>[LOOKUP>db=MYDB.db&value=[SKU]&lookinfield=SKU&ReturnField=Inventory]]>[SETLINEITEM CART=[CART]&INDEX=[LINEINDEX]]QUANTITY=[LOOKUP>db=MYDB.db&value=[SKU]&lookinfield=SKU&ReturnField=Inventory]&TEXTA=OVER[/SETLI>N>EITEM]>[/SHOWIF]>[/LINEITEMS]>>Then, when displaying the items later in the page, I say something like:>>[LINEITEMS]>[QUANITY][SHOWIF [TEXTA]=OVER](You have requested more than we have in>stock. Your order had been adjusted.)[/SHOWIF]>[SETLINEITEM CART=[CART]&INDEX=[LINEINDEX]]TEXTA=[/SETLINEITEM]>[/LINEITEMS]>>Now the customer sees how much they can order, and I can erase the note>from the lineitem.>>MichaelThank you Michael,your source has been very helpful for the resolution of my problem. But nowI've another trouble: what happens if someone do not complete the order andclose 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. Anytimesomeone order one of this product, Webcatalog add it in a cart and bafflethe order. So if a user do not want to bye product in the cart and do notremove it but simply close connection, WebCat do not permit to another userto order it.What can I do for the resolution of this problem?ThanksGiovanna
Associated Messages, from the most recent to the oldest:
>Before the items are displayed on the cart page, I go through a
[lineitems]>loop to check the ordered quantity against the available inventory. If the>customer wants more than is available, I readjust their quantity and make a>note in htat line item:>>
[lineitems]>[SHOWIF [QUANTITY]>[LOOKUP>db=MYDB.db&value=[SKU]&lookinfield=SKU&ReturnField=Inventory]]>[SETLINEITEM CART=
[cart]&INDEX=[LINEINDEX]]QUANTITY=[LOOKUP>db=MYDB.db&value=[SKU]&lookinfield=SKU&ReturnField=Inventory]&TEXTA=OVER[/SETLI>N>EITEM]>[/SHOWIF]>[/LINEITEMS]>>Then, when displaying the items later in the page, I say something like:>>
[lineitems]>[QUANITY][SHOWIF [TEXTA]=OVER](You have requested more than we have in>stock. Your order had been adjusted.)[/SHOWIF]>[SETLINEITEM CART=
[cart]&INDEX=[LINEINDEX]]TEXTA=[/SETLINEITEM]>[/LINEITEMS]>>Now the customer sees how much they can order, and I can erase the note>from the lineitem.>>MichaelThank you Michael,your source has been very helpful for the resolution of my problem. But nowI've another trouble: what happens if someone do not complete the order andclose 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. Anytimesomeone order one of this product, Webcatalog add it in a cart and bafflethe order. So if a user do not want to bye product in the cart and do notremove it but simply close connection, WebCat do not permit to another userto order it.What can I do for the resolution of this problem?ThanksGiovanna
Giovanna Petrachi
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:
no global [username] or [password] displayed ... (1997)
[TCPSend] and whois? (1999)
Credit card types (1997)
Webcatalog Future?!? - Was &fieldsdir=ra truely random?? (2000)
[WebDNA] WebDNA future (2010)
Combining search criteria in a context? (1998)
NT version (1997)
WebCat2b15MacPlugin - [protect] (1997)
SQL Ref. (1999)
[search] in formulas.db (1997)
Version f1 status (1997)
WebMerchant Q (2000)
Email (1998)
customer info (2001)
PCS Customer submissions ? (1997)
ErrorLog with Linux? (2000)
Vanity counter side note (1998)
Nested vs conditional (1997)
WebDNAmonitor running but webcat won't start. (2002)
problems with 2 tags (1997)