So I have to create a report (SQL Script) which has all the bundle products and all its customizable options. I can get list of all the bundle products using this query.
select entity_id, type_id, sku, has_options from catalog_product_entity where type_id='bundle';
In catalog_product_entity, I assume that entity_id is the primary key.
Now I want all the options associated with bundle product.
which tables should I refer to? I know catalog_product_bundle_option and catalog_product_bundle_option_value can give me option title but when I try to join using parent_id with entity_id it doesn't return anything.
Can anyone explain table structure to me or which tables should I refer to then that will be great.