products order Missing products in order on backoffice

[ruisonika]

I am experience a new problem in prestashop 1.6.1.24... sometimes when a customer make a purchase (for example two products) in prestashop backoffice (admin) the order only have 1 product, but the totals, ship and tax are ok, and in database ps_cart_product there are 2 products...
I am with no ideias how to desmantle this problem...
how can i start to debug?

[jmauclair]

Hi,

 

The best way to debug, is to var_dump 😂

 

Clone your website locally, and find the admin controller for the order detail page (it might be this one : \src\PrestaShopBundle\Controller\Admin\Sell\Order\OrderController.php)

Search in this file when does the product detail is rendered and then find which variable is storing the detail or which function generate the detail.
It might not be in this controller, but it will be a good start 😁

[musicmaster]

During the creation of the order the rows are copied (and a bit modified) from the ps_cart_product table to the ps_product_detail table. It looks something goes wrong there. The most likely explanation is that some php error stops the operation after one product was copied. 

So check the error log of your server. 

You can also switch on profiling to see which mysql commands are executed.