Ray UK Posted February 22, 2014 Share Posted February 22, 2014 (edited) Hi, Im thinking our shopping carts list is a bit messed up. All of the abandoned carts cannot be deleted ? Plus they all have an ID and order ID. In this image there are only 4 orders, yet they all have order ID's ? Plus if I click on any of the none orders, they each link to orders that were placed months ago ? Is there something wrong here and what can I do to resolve this. Is it a case of delete all previous order history and start again ? Edited February 25, 2014 by MerseyRay (see edit history) Link to comment Share on other sites More sharing options...
Ray UK Posted February 25, 2014 Author Share Posted February 25, 2014 (edited) any ideas on this one ? It seems to me that some sql code somewhere is messed up. If I go to our back office and create an order for a customer, there will be items in the basket already that shouldnt be there. I delete the items and it says an order has already been placed using this cart ? Also, there are shopping carts from feb 2003 that are still there and cant be removed/deleted. Should these not auto vanish over a pre-defined period to empty this list ? And what about the orders that have been placed from the shopping cart. Since this is now not a shopping cart, but an order, should they not vanish from the list also ? Any help on this is appreciated Thanks Edited February 25, 2014 by MerseyRay (see edit history) Link to comment Share on other sites More sharing options...
Ray UK Posted February 25, 2014 Author Share Posted February 25, 2014 Can I simply Empty the 2 tables "ps_cart" and ps_cart_cart_rule", or will this mess everything up ? Ive just deleted these 2 on a copy of the site, and it has totally emptied the "Abandoned Carts" list, but what effect will this have on the site ? Link to comment Share on other sites More sharing options...
Ray UK Posted February 25, 2014 Author Share Posted February 25, 2014 Nope that doesnt seem to work either. After deleting those 2 tables, I went to the backup site and signed in an added an item to the cart, then signed out and added a different item to the cart. Here is what now shows. (I didnt place an order, just added the items So ID 2 says ive placed an order ? If I click on that cart/order I get this Which clearly show I just created that cart, but placed an order on 9/17/2013 This isnt good Link to comment Share on other sites More sharing options...
Recommended Posts