joaofilipe Posted July 2, 2013 Share Posted July 2, 2013 Hi, Today I started to have some issues with cart. When a client makes an order some products are not added to total cost. They appear on the order but the sum is not right. Another issue is when i'm adding a product to cart it adds other i didn't pick! thanks, JoaoFilipe Link to comment Share on other sites More sharing options...
vekia Posted July 2, 2013 Share Posted July 2, 2013 issue 1: but you're talking about back office, or about customer account in front-office? issue 2: you use default template or maybe some custom solution? 1 Link to comment Share on other sites More sharing options...
joaofilipe Posted July 2, 2013 Author Share Posted July 2, 2013 (edited) Hey vekia, thanks for the help! all of this is in front office for example; i choose a product while i'm logged , when i add it to cart the cart shows 2 products, one of them it comes from i don't know. i custom the default theme, i made it by the book! I think! add a new one and choose copy the files from default i also deleted some orders with free order delete module, maybe has something to do with that, it deletes orders but some data remains that is causing this mess. Edited July 2, 2013 by joaofilipe (see edit history) Link to comment Share on other sites More sharing options...
tomerg3 Posted July 2, 2013 Share Posted July 2, 2013 It certainly sounds like an issue with the DB tables not being properly cleared, specifically ps_order_details, and ps_cart_products. 1 Link to comment Share on other sites More sharing options...
joaofilipe Posted July 2, 2013 Author Share Posted July 2, 2013 Thanks for help tomerg3 shall i empty those tables in phpMyAdmin? and after will this issue be solved? assuming we don't delete any more orders. Link to comment Share on other sites More sharing options...
tomerg3 Posted July 3, 2013 Share Posted July 3, 2013 Create a backup of all your tables and try to delete those 2. Link to comment Share on other sites More sharing options...
joaofilipe Posted July 3, 2013 Author Share Posted July 3, 2013 sry my question ... but shall i delete or empty? Link to comment Share on other sites More sharing options...
tomerg3 Posted July 3, 2013 Share Posted July 3, 2013 Empty (delete the contents) 1 Link to comment Share on other sites More sharing options...
joaofilipe Posted July 3, 2013 Author Share Posted July 3, 2013 thanks for help tomerg3, i'll do that and post results here later. Link to comment Share on other sites More sharing options...
joaofilipe Posted July 4, 2013 Author Share Posted July 4, 2013 Thanks guys for the help, seems all OK now! Indeed was some garbage left in BD tables, from tests were made with orders, customers, etc not only i deleted those referred by tomerg3, but also some others, here's complete list: ps_adress ps_cart ps_cart_cart_rule ps_cart_product ps_cart_cart_rule ps_compare ps_compare_product ps_connections ps_connections_source ps_customer ps_customer_group ps_customer_message ps_guest ps_newsletter ps_orders ps_order_carrier ps_order_cart_rule ps_order_detail ps_order_detail_tax ps_order_history ps_order_invoice ps_order_invoice_payment ps_order_invoice_tax ps_order_message ps_order_message_lang ps_order_payment ps_product_sale ps_range_price Link to comment Share on other sites More sharing options...
Recommended Posts