SQL Statement to find all products in an order

[brownd92]

Hi there,

Does anyone have a SQL statement so I can find each product in an order?

i.e

 

select QTY, Name, details from orders where order reference = KSNFDNOSU

 

In other words the information you would get in order history.

 

Thanks

[doekia]

SELECT od.*

FROM ps_order_detail od

INNER JOIN ps_order o on (o.id_order = od.id_order)

WHERE o.reference = 'KSNFDNOSU'

[brownd92]

Brilliant starter :-) Thanks

How would I go about getting information like pack size?

 

i.e.

Reference Product Quantity
      Dectomax Inj. Cattle & sheep Dectomax Inj. Cattle & sheep - Pack : 200ml 2     Qualimec (Ivermectin) Injection Qualimec (Ivermectin) Injection - Pack : 500ml 2    

 

                 

[brownd92]

Or more specifically the product combination which was ordered?

 

Thanks

[doekia]

combination is id_product_attribute

 

But now should you be asking about specific attribute value regarding a combination it is a bit more tricky

 

You should find on product_combination the list of attributes then find on attribute_group the group name regarding your attribute