Hi All,
I want to get the list of product combinations which is Selling the most along with how many orders have been made with this combination.
A sample expected result is shown below.If there is 5 products let's say P1,P2,P3,P4& P5 & I want to find the combination of products which is selling the most or Popular along with its order details(Number of distinct Orders and Order_id).
Also I want to exclude the parent child items,means if a customer bought a set which contains three items(Parent) ,and if the combination product is shown as it's child then it should be avoided.
Also in the above products suppose, if P1,P2&P3 is the most sellinng combination then should count the orders if the P1,P2&P3 is included with other products also,means if an order contains P1,P2,P4,P5&P3 then this order should be counted.
Is there a way to get this using SQL.i'm using Postgresql,but if someone can help me with MySQL query or tables in Magento side,it is also helpful.
Thanks and regards
