Triggers and inventory...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52958
interpreted = N
texte = Hi Donovan I have come to a conclusion on how the timeout and the ARIC need to work simultaneously and have put together this example. Say I have a cart created at 10:15am and my trigger is not due to fire again till 10:30 (triggers set to go off at 1min and 30mins), this means that my trigger and timeout are actually out of sync as the timeout is based on the time the cart is created. In the event that the customer reaches their timeout limit, they have to start a new shopping trip but the stock they had in their cart will not be added back into the products.db for another 15 minutes (when the next trigger fires). I guess my question is this... What is a reasonable limit to set a trigger at or do you think that it would be possible to have the timeout *and* the inv_check.tpl page combined into one include that will execute when the shopping trip exceeds the given limit. The reason I suggest this is that for the trigger to be effective it would need to fire every minute but even then you have 59 seconds possible lag until the stock gets fired back into the products.db. I would have thought that the time limit could be set once in this include as opposed to 2 pages and then the actions of redirect and stock replenishing to take place simultaneously. Here is the logic as I see it ------------------------------------- IF - Live Cart Time > 1hr (3600 seconds) THEN - Add stock back into products.db AND redirect to Timeout page ELSE - Carry on as normal ENDIF -------------------------------------- The best part of executing both of these using the same include is that not only do things happen at the same time, we also eliminate the requirement of the trigger to fire back stock in the event of a timeout. Although I believe that the trigger may still be need to be active to put stock back into the products.db after stock is abandoned in a cart??? If you could please reply to me with your thoughts on this idea as I think it is very important that this system is locked down to be as effective as possible. Err... I could also be doing with a little clarification of what happens to abandoned carts as I kind of winged that part at the end :D I look forward to hearing from you... Kind Regards Alan ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
| |
- Triggers and inventory... ( Alan White 2003)
|
Hi Donovan I have come to a conclusion on how the timeout and the ARIC need to work simultaneously and have put together this example. Say I have a cart created at 10:15am and my trigger is not due to fire again till 10:30 (triggers set to go off at 1min and 30mins), this means that my trigger and timeout are actually out of sync as the timeout is based on the time the cart is created. In the event that the customer reaches their timeout limit, they have to start a new shopping trip but the stock they had in their cart will not be added back into the products.db for another 15 minutes (when the next trigger fires). I guess my question is this... What is a reasonable limit to set a trigger at or do you think that it would be possible to have the timeout *and* the inv_check.tpl page combined into one include that will execute when the shopping trip exceeds the given limit. The reason I suggest this is that for the trigger to be effective it would need to fire every minute but even then you have 59 seconds possible lag until the stock gets fired back into the products.db. I would have thought that the time limit could be set once in this include as opposed to 2 pages and then the actions of redirect and stock replenishing to take place simultaneously. Here is the logic as I see it ------------------------------------- IF - Live Cart Time > 1hr (3600 seconds) THEN - Add stock back into products.db AND redirect to Timeout page ELSE - Carry on as normal ENDIF -------------------------------------- The best part of executing both of these using the same include is that not only do things happen at the same time, we also eliminate the requirement of the trigger to fire back stock in the event of a timeout. Although I believe that the trigger may still be need to be active to put stock back into the products.db after stock is abandoned in a cart??? If you could please reply to me with your thoughts on this idea as I think it is very important that this system is locked down to be as effective as possible. Err... I could also be doing with a little clarification of what happens to abandoned carts as I kind of winged that part at the end :D I look forward to hearing from you... Kind Regards Alan ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Alan White
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:
Dealer Locator (zip codes) (2003)
Price Not Appearing (2000)
Not really WebCat (1997)
Re1000001: Setting up shop (1997)
Sharing DBs across domains (2001)
Odd search results, or odd programmer, not sure which... (2002)
WebDNA and PostGres SQL (2005)
Date Formats (1997)
Every other record deleted (2005)
politeness (was searches with dash...) Please Read (2000)
using showpage and showcart commands (1996)
New Site Announcement (1998)
Another new bug found ... (2000)
Removing user entered whitespace... (2004)
webcat 2.1 new cart fields - please explain more (1998)
OT: Amazon Patents (2000)
Refering page (1998)
[include] affect on filepaths for links? (1997)
WebCat2: Formulas.db question (1997)
Nested tags count question (1997)