Im not sure where to start on this one really..
The abandoned cart report (Admin > Reports > Shopping Cart > Abandoned Carts) shows that there are only 8 abandoned carts at the moment. However I know there are more, and when I look at the 'Products in cart' report, it shows that one of my products is currently in 29 different carts. Ive not had any orders go through today, so shouldnt they be showing as abandoned carts. It used to work, but for somereason now it doesnt.
Thanks in advance
It's worth checking that the cron is running an dprocessing correctly. The best way imho is to install the great & free AOE Scheduler. That'll show you if there are any cron bottlenecks or errors which could be causing this not to update.
It updates only for certain registered customers, not all of them.
It used to be working sometime prior to 18.104.22.168
In my case it seems to be a problem in the "middle name" join.. in the query. That shouldn't be an inner join; but a left join; since for a lot of customers no middle name is present in the customer_entity_varchar table..
Creating an override for "app/code/core/Mage/Reports/Model/Resource/Quote/Collection.php" line 143 from "joinInner" to "joinLeft" solved the problem.. Another solution could be changing the affected table so all customers get a "NULL" as middle name..
For me it was on line number 217, but it worked great!
Thanks for the help!
It didn't help... when we tested it, our cart showed up. However, a few days later our test cart is still the latest cart.
Thank you so much, the joinLeft fix did the job and everything looks good. Mine was on line 209.
Thanks so much, boss had been on to me for weeks for this fix.