djbeat00 Posted February 7, 2016 Share Posted February 7, 2016 Hello! We built up a clothing store on PrestaShop and it was running fine for a few years but recently it started a crazy thing. When we receive a new order it automatically adds an extra product to the order summary. Check out this image: As you can see the first product is an extra (unnecessary) one, the client just ordered the last two products. The system is not even adding the extra item's price to the summary. We tried to delete and reupload the product with the PP40 reference number but now it's adding an other one to the summary. It's really annoying. I'm pretty sure it's a database related issue but I don't know how to fix that. Is there anyone who can help me diagnose this problem? Thank you in advance! Link to comment Share on other sites More sharing options...
sandipchandela Posted February 7, 2016 Share Posted February 7, 2016 - Did you ever delete orders in your shop? - Have you used data cleaner ? (If you still have the old 'deleted' orders on file, check the old order data with possibly the same order id/order no that PS is generated.) - Tell me about that extra product. Is there anything 'special' about it? means have u created Combinations/attributes/other than this for it? 1 Link to comment Share on other sites More sharing options...
djbeat00 Posted February 7, 2016 Author Share Posted February 7, 2016 (edited) - Did you ever delete orders in your shop? - Have you used data cleaner ? (If you still have the old 'deleted' orders on file, check the old order data with possibly the same order id/order no that PS is generated.) - Tell me about that extra product. Is there anything 'special' about it? means have u created Combinations/attributes/other than this for it? I didn't delete orders but maybe my colleagues did. I found this active module in the module manager area "Clear carts v1.0 - PrestaScope" The extra product is just a simple product like the others but it has combinations (for the different sizes). It doesn't have attributes though. As I mentioned we tried to delete and recreate this product and now the system adds a different t-shirt instead of what you see in the screenshot. I have PHPMyAdmin access if it helps. Edited February 7, 2016 by djbeat00 (see edit history) Link to comment Share on other sites More sharing options...
sandipchandela Posted February 7, 2016 Share Posted February 7, 2016 check in the phpmyadmin: Go to ps_orders, and check if all the orders you see there are actually real placed orders or not. Find order no: 000076 as this order id having problem. Now in table name ps_order_detail - In ps_order_detail, find rows that have an value in field name id_order to 000076. Link to comment Share on other sites More sharing options...
djbeat00 Posted February 7, 2016 Author Share Posted February 7, 2016 check in the phpmyadmin: Go to ps_orders, and check if all the orders you see there are actually real placed orders or not. Find order no: 000076 as this order id having problem. Now in table name ps_order_detail - In ps_order_detail, find rows that have an value in field name id_order to 000076. It's strange, there's no 76 order id in the ps_orders table. I see 75 and 77, but there's no 76. In the ps_order_detail table I see this: Link to comment Share on other sites More sharing options...
djbeat00 Posted February 8, 2016 Author Share Posted February 8, 2016 BUMP! Link to comment Share on other sites More sharing options...
djbeat00 Posted February 9, 2016 Author Share Posted February 9, 2016 HELP! Link to comment Share on other sites More sharing options...
sandipchandela Posted February 10, 2016 Share Posted February 10, 2016 Check that order in the cart tables Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now