gswant Posted July 11, 2011 Share Posted July 11, 2011 Hello everyone, I hope you can help me,I have two stores with a prestashop 1.4.3 and 1.4.1 in both the second with the same problem I have.I tried to buy a product, (the test was performed + times) and while the mail client sends the right order, never, to my list in order from BO I add one or two products not ordered. In this way, I can not understand what the customer orders.MAIL CUSTOMERBuste Shopper tutti gli accessori per la tua attività..Dati dell’ordineOrdine: #000001 effettuato il 2011-07-10 22:36:15Pagamento: Bonifico BancarioRef.29 Buste in Carta Senza Decoro Bianco, Avana, 18+8×24 0,30 € 600 181,80 €Riferimento Prodotto Prezzo unitario Quantità Prezzo totale Prodotti 216,00 € Sconti 0,00 € Carta regalo 0,00 € Spedizione 18,00 € Totale pagato 234,00 €MAIL DEALER AND ORDER BOOrdine: 000001 effettuato il 2011-07-10Pagamento: Bonifico BancarioiPod touch – Capacité: 32Go 469,00 € 1 469,00 € Écouteurs à isolation sonore Shure SE210 149,00 € 1 149,00 €STN009 Shopper TnT Modello a Sacco – Colore : Bianco, Colore : Nero, Colore : Lilla, Colore : Verde Scuro, Colore : Rosso, Colore : Avana, Colore : Arancio, Colore : Grigio, Formato in cm : 38×42 1,02 € 200 204,00 €Ref.29 Buste in Carta Senza Decoro – Colore : Bianco, Colore : Avana, Formato in cm : 18+8×24 0,36 € 600 216,00 €Riferimento Prodotto Prezzo unitario Quantità Prezzo totaleProdotti 216,00 €Sconti 0,00 €Carta regalo 0,00 €Spedizione 18,00 €Totale pagato 234,00 €As you can see I have added as many as 3 products in which there are two of my products.THANKS TO ALL Link to comment Share on other sites More sharing options...
Voliminal Posted October 26, 2011 Share Posted October 26, 2011 I have the same problem too! Anyone to help us? Link to comment Share on other sites More sharing options...
tomerg3 Posted October 26, 2011 Share Posted October 26, 2011 Does it happen with every payment method? Can you post a link to your site where we can create an order (without using a credit card)? Link to comment Share on other sites More sharing options...
gswant Posted October 26, 2011 Author Share Posted October 26, 2011 Solved place the solution in case someone needs it. Enter the db with phpmyadmin and clean all the tables related to your order and everything back in place. Probably still hanging on to something especially after updates later and then the only solution is to delete the tables of orders. However, this might be a problem for those who need to keep the old order. maybe if you can find a less drastic approach might be helpful. Link to comment Share on other sites More sharing options...
Voliminal Posted October 26, 2011 Share Posted October 26, 2011 My shop is this: www.nailshop.com.gr But as a customer you can make the order without any problem. The problem occures when I enter the back office to see the order. gswant, I'll try to do what you said. I'll let you know. Should I edit the "ps_order_detail" in the database? Link to comment Share on other sites More sharing options...
gswant Posted October 26, 2011 Author Share Posted October 26, 2011 No need to delete the products that are not in any order on the table"ps_order_detail" Link to comment Share on other sites More sharing options...
Voliminal Posted October 26, 2011 Share Posted October 26, 2011 I'm sorry but I haven't understand what exactly to modify at the database to fix the problem. Can you help me a little more? Thanks Link to comment Share on other sites More sharing options...
gswant Posted October 26, 2011 Author Share Posted October 26, 2011 I go to the db table ps_order_detail in if you do not order you'll see that deletes all data and solve Link to comment Share on other sites More sharing options...
tomerg3 Posted October 26, 2011 Share Posted October 26, 2011 Do not delete anything from the database! If there were orders placed on the site, and then the order table was cleared, but not the order_details table, then old products from previous orders would show up there. Do you know if this has happened? Link to comment Share on other sites More sharing options...
gswant Posted October 26, 2011 Author Share Posted October 26, 2011 Often happened when I updated the shop. I noticed that some orders are not entered in tebella leave detailed orders products that have nothing to do with the actual orders. These products are presented below on new orders. The fix is to remove these products without touching those who are in the order. The products can be found easily by analyzing the table and looking at the correspondence between the id and product id order. With a little patience and confidence, the problem is solved. I have done this in my shop if there is another simple solution I am happy to learn it. Greetings to all Link to comment Share on other sites More sharing options...
Voliminal Posted October 26, 2011 Share Posted October 26, 2011 I selected everything inside ps_order_detail and deleted 'em. Now older orders don't have products, but since it was testing its ok. I made a new order and it only shows me the product I ordered so I guess its solved. Unless it happens again. Is there anything I should do, or enable/disable so it wont happen again? Link to comment Share on other sites More sharing options...
gswant Posted October 26, 2011 Author Share Posted October 26, 2011 definitely will not happen again, especially when you update the store. You must learn to recognize what are the products which will remain suspended and then delete the ones exclusively. Link to comment Share on other sites More sharing options...
Voliminal Posted October 26, 2011 Share Posted October 26, 2011 I understand, I have a backup so I can restore it and locate the problematic products with the way you said in your previous post. Thanks broz! Link to comment Share on other sites More sharing options...
gswant Posted October 26, 2011 Author Share Posted October 26, 2011 It was a pleasure to make my contribution. 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