LuckyURE Posted December 19, 2012 Share Posted December 19, 2012 A customer somehow registered two accounts (with the same information) and while the cart was there the order never created (but yet the payment went through to PayPal). Weird situation, I know. In any case, I deleted one of the customer entries and that left the order (that I manually created from the cart - so it would match the PayPal statement) orphaned (evidently I deleted the wrong customer duplicate). In any case, it's a simple matter of assigning the order to the customer. I can't find anywhere (searched the forums and google) on how to do this!? Can someone help please? I'm using the latest version of PrestShop. Thanks! Link to comment Share on other sites More sharing options...
suenda Posted December 22, 2012 Share Posted December 22, 2012 Well, I had somewhat similar problems few months ago. I ended up manually modifying the database. Link to comment Share on other sites More sharing options...
LuckyURE Posted December 27, 2012 Author Share Posted December 27, 2012 Suenda: Thank you for your response and apologies for my delayed reply. Can you provide me with which fields in the database you updated to save me the trouble of hunting them down so I can link the order? Thanks! Link to comment Share on other sites More sharing options...
suenda Posted December 27, 2012 Share Posted December 27, 2012 Well, i think ps_order table is all you need to modify. Find the line corresponding to your orphaned order and set the id_customer to the id of your customer. And do not forget to set id_address_invoice and id_address_delivery. I hope this should do the job. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts