I would like to replace the opportunity product selection page with something more user friendly instead of just displaying a flat list of products. The ideas is a tree control display like:

 

+ Models

   + Family

      + Product Line

 

Model is defined by product record type: Model, Accessory

Family is defined by product family, e.g. "select family from product2 where recordtype = :model"

Product Line is defined by a custom field on Product, e.g. "select productline__c from product2 where recordtype=:model and family=:family"

Clicking + at product line gives you the products, e.g, "select name, ... from product2 where recrodtype=model and family=:family and productline__c = productline__c"

 

So, initially + Models isdisplay. Clicking on + expands to the Families under model. Clicking on a Family expands to the Product Lines under that Family, clicking + on product lines list all product under that recordtype, family, product line.

 

All obviously are controled by the selected Price Book.

 

Question: the functionality from an UI point of view is similar to what we have in the standard application under Setup: Clicking + under Customization gives you a list of standard objects, clicking a + next to a standard object gives you the various tasks you may perform.

 

How to do this on an APEX page?

Best regards,

Per