cancel
Showing results for 
Search instead for 
Did you mean: 

Finding the parent id of an product

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Finding the parent id of an product

Hi All,

I have a requirement to create a cross sales report(Which combination of the product is most purchased by a customer with it order count), But i want to avoid those orders contains parents and child,Suppose if an order contains P1 ,P2 and P3 products(P2 is the parent of P1) then i want to show the combination like P2 and P3(excluded the child),likewise i have to show the combination of products (excluding parent and child and showing parents only with other products).

 

So for this i have created a table where i'm updating the order , product details and parent details.But facing an issue to identify the correct parent of product(same child is having multiple parents),So how can i tackle this situation and find the exact and correct parent for each products.

 

i'm using the table catalog_product_relation for identifying the parent ,child relation(but in this for same child have multiple parents).

Any suggestions/recommendations will be of great help.

 

Version Magento 1.9 

1 REPLY 1

Re: Finding the parent id of an product

Does anyone know the answer for this, I'll be much grateful if anyone can help on this.