since I upgraded to version 1.6 orders are not register in the table ps_detail.
If I try with the last order:
SELECT *
FROM `ps_order_detail` or
LEFT JOIN `ps_product` p ON (p.id_product = od.product_id)
LEFT JOIN `ps_product_shop` ps ON (ps.id_product = p.id_product
AND ps.id_shop = od.id_shop)
WHERE od.`id_order` = 224 <- not showing last order
the result is' MySQL returned an empty set (ie zero rows). "
however if I write:
SELECT *
FROM `ps_order_detail` or
LEFT JOIN `ps_product` p ON (p.id_product = od.product_id)
LEFT JOIN `ps_product_shop` ps ON (ps.id_product = p.id_product
AND ps.id_shop = od.id_shop)
WHERE od.`id_order` = 213 <- last placed order
the result are correct, there are three products on order, 3 records registrered.
ps_order_detail not record incoming orders!! Help meee