how to implement automatic Related , upsell, cross-sell products. we uploaded lot of products. but there is no Related , upsell, cross sell products.

What we want is through programatically how we can assign the Related , upsell, cross sell for same category products. Is there any free extension that give this result with atleast 4 + review.

  • Did you find any free stuff?
    – Gem
    Commented May 4, 2018 at 10:15
  • @Rathinam i did't found..... Commented May 4, 2018 at 10:16

2 Answers 2


You can use AheadWorks Automatic Related Products 2 https://ecommerce.aheadworks.com/magento-extensions/automatic-related-products-2.html

43 reviews

5 Stars support


https://www.magentocommerce.com/magento-connect/related-products-manager.html https://www.magentocommerce.com/magento-connect/mtoo-related-automatic-related-products.html

  • sorry, i am looking for some free extension. Commented Feb 8, 2016 at 17:56
  • I don't suggest to do, I have been looking for the same function for ages and this is the best module to use. I'm not working for AheadWorks :D - Update me answer with 2 free modules Commented Feb 8, 2016 at 18:06
  • Nice , I will wait for some time. if i get free extension thats much better. although you are not working for ahead works, as you are suggesting ahead works, It shows the quality of that extension. :) Commented Feb 8, 2016 at 18:13
  • I have used the same module in few project and it works with no issues Commented Feb 9, 2016 at 14:37
  • if are interested to purchase paid module then see magento 2 automatic related products extension for upsell Commented Jun 2, 2021 at 10:50

You can check in DB how this is related...

catalog_product_linktable holds "link_type_id"(here you can check which id upsell or cross sell have), and then you just need to insert products to the table catalog_product_link and set the riht link_type_id to it. Best way to do this is to have some excel or something like that, map all products to its linked product id and just build insert queries and boom:) Clear cache, maybe you will need some reindexing - I am not sure about that and you should have related products on site.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.