I am trying to get all the products from my Drupal Commerce site but some are not coming through
Here is the code I am using - but I am getting 1316 rows back and I think that is because I am getting back the physical products and the courses but not the membership type products - how do I get those back please??
914 Items - "Physical Products"
20 Individual Membership
12 Business Membership
1350 Total Catalog
SELECT p.*,n.nid,d.field_product_description_value,d.entity_id,ua.alias FROM commerce_product p left outer JOIN field_data_field_product_reference r on r.field_product_reference_product_id=p.product_id left outer Join node n ON n.nid=r.entity_id left outer join field_data_field_product_description d on d.entity_id = n.nid left outer join url_alias as ua on ua.source=CONCAT('node/',n.nid)