Chris, et al -- ...and then Chris W. Parker said... % % Hey there everyone.
Hiya! % ... % How do you determine if a shopping cart has been abandoned or not? ... % % The problem I see is that a cart could be considered abandoned for 4 % days but then become active again because the customer has come back to % it and has added more products to it. In this case I'd say it was never % abandoned in the first place and in which case it would be innacurate to % include it your abandoned cart total. If you go with the ideas of keeping the cart in a session (and not decrementing the stock until purchase time) then it's easy; when the session goes away the cart does and it's abandoned. Have a simple table of all carts created or even a counter of carts and reference that against completed carts to get your ratio. If you go with the ideas of storing the cart in the DB, then either implement the simple table above for your count as carts get deleted or just add an 'abandoned' field and keep the cart forever or perhaps combine the two and note old carts that are due to be wiped as such and include that analysis in the math against the cart_total_count table. HTH & HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
pgp00000.pgp
Description: PGP signature
