I've been trying without success to obtain the line level information about a specific order but i am getting the header information.
Take a look at this picture:
This is my query:
select o.increment_id, o.status, oi.price_incl_tax, t.carrier_code, o.created_at, oi.price_pvp, oi.created_at, o.shipping_instruction, o.payment_term from sales_flat_order o join sales_flat_order_item oi on o.entity_id = oi.order_id left join sales_flat_shipment_track t on o.entity_id = t.order_id where oi.parent_item_id is null
What's wrong? Can you please help me to solve this?
This is what i found in MYSQL:
The problem here is that i do not understand how should i look into this in order to obtain what i need :/.