When Opportunities are enabled within the control panel, the a Product list view page can be filtered down to obtain a list of Products that are connected to Opportunities.
Filtering Products by Opportunity connections
To view a list of Products connected to Opportunities, go to:
01. The Products drop-down in the header menu bar and select the desired Product type, which directs to that category's list view page.
02. Click the 'Connections' filter drop-down in the filter menu bar and select Opportunities.
This displays a list of all Products within that category which are connected to an Opportunity.
03. The text Opportunities will appear as a blue filter label with a drop-down providing the ability to filter the list further by using data input against that Product when it was added to an Opportunity. In example, show all Cupcake types connected to an Opportunity where the order Quantity was equal to 10.
04. Opportunity related custom fields and standard fields are available under the More drop-down to filter the list of Product types further.