How to get the Commerce Product type from the order object. D7 I am unable to find the product type when looking at the order object. I have tried 

commerce_order_load($order_id);


This does not give the product type and neither does 

commerce_line_item_load();


I have also looked for a function to achieve this here but can't see anything to achieve this.

I am able to get the line item type it seems but not the product type, seems odd
I ended up just querying the database, here is what worked for me

$product_type = db_select('commerce_product', 'cp')
    -&gt;fields('cp', array('type', 'product_id'))
    -&gt;condition('cp.product_id', $product_id, '=')
    -&gt;execute()
    -&gt;fetchAll();