Thanks for prompt response, DivaVocals.
We had a huge sale on 4/1. Did 656 orders in 24 hours. All of March I had 920 orders so it definitely could be related to congestion or simultaneous users which I consider more likely. There were items from 3 different customers landed in one customers basket. I have not attempted to reproduce but I found the evidence in customer_basket table. My store items are registrations that include first name and last name as TEXT option values which is how I know customer was correct. Customer_basket has customers_id as column. I saw the 7 rows with her customers_id in customer_basket. When I logged in as her, I saw the items, too. I simply deleted them from her cart to enable her to continue. The items that DID NOT belong in this ladies cart I found in 2 completed orders by 2 different customers less that one minute apart and close to the time I handled this complaint.
I have not been able to reproduce this but I purged customer_basket and customer_basket_attributes rows prior to 3/15/2014. I have never had this kind of volume before. My "inventory" (I.e. events) are perishable. When their over, their over. I was hoping for some insight into how COWOA handles basket/cart merge? Perhaps some insight (a file name maybe) of how Zen Cart handles basket/cart merge. I am very early in my investigation. COWOA was the last update I did. I love the way it works and I think it has improved my conversion rate. Get everything out of the way between the customer and the cash register, if you know what I mean. Since I am registering people for events, it is embarrassing to see strangers showing up in your cart at check out.
One other item. I know COWOA prevents customers from checking out without an account if their email address is already on file with an account. I think I tested that. I have found a few customers in my customer table with the same email address. It very well could be I have some other problem going on.
You may see my site here
https://www.mellew.com/reg/
Any hints or insight is appreciated.
Bookmarks