hi,

I'm a little confused about cart-abandonment. I made the cba shop with help of this book. It stores the shopping cart in a table in a database.
However in the exercises there is nothing said about the spam left in the temp database, the database fills up and if you have many visitors it fills up fast. What is the best way to deal with this problem, is there a script which knows when a user closes its browser and then deletes it's cart. The book says that it wants to save it for analysis, but if I keep it I must delete the entries weekly and I’m not really happy with that.

greetz

xipnl,
Sorry for the delay in responding to you- to delete the temp database on a regular basis, you could write a simple PHP program with a SQL statement that empties the table, then set up a cronjob to execute the program at determined intervals.

hope that helps!
Elizabeth Naramore