RE: [PHP-DB] Inventory Management for ecommerce store
| From: | Aaron Wolski | Date: | Fri, 21 May 2004 16:21:40 +0000 |
| Subject: | RE: [PHP-DB] Inventory Management for ecommerce store | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34517@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Matt Schroebel [mailto:matthew.schroebel@epooch.com]
>
> What if I abandon my cart? Are you using transactions to make sure
all
> updates are atomic?
All cart records are stored to the database with a timestamp. On each
call to the cart_script, I check to see if any records are older than 24
hours and if they are, I dump the quantity back into inventory and
remove the entry from the DB.
A