Display Products via parent child relationship

[CCSS-Github]

What our requirement was, we needed to display products filtered via parent_id (its self referencing product id) so we added parent_id fourth column in groupscatalog_product_idx and we wanted composite key to further extend and make parent_id part of composite primary key and display filter via
parent_id.

We also modify indexer because its gave us some errors. Kindly guide us how can we achieve this. Wanted to further extend your extension.

[CCSS-Github]

Issue is:

If there are 2 bundle products: 1st bundle product have (options - simple products) [a,b,c,d] and other bundle product have options [c,d,e,f] than we wanted as per current data structure . All options start appearing against each bundle product, what we want is to display data for each user group + parent product. We are not populating data via admin panel instead data is coming via ETL process from salesforce. Thanks in advance, it will be great if you guide us in right direction.

[awahab445]

I have similar problem. What I want is to have bundle products against different customer group having shared bundle items. For Example, Bundle product A have bundle items having ids [1,2,3,4,5] and Bundle Product B have [3,4,5,6,7]. what happening is all the bundle items from 1 to 7 have single entry in groupscatalog_product_idx and if we assign Bundle Product A and B to a customer Group X then all the other options that is shared between bundle products also visible against each single bundle product A,B. Kindly help me in this. I have tried different tricks but all failed due to global events like 'catalog_product_collection_load_before' and 'catalog_product_collection_apply_limitations_after'.