Each product can be assigned to a category. I was wondering in which database table these products and categories are coupled.

1 Answer 1


product and category relation has been saved at table catalog_category_product and catalog_category_product_index.catalog_category_product is the main table

  • Is there any documenation about this? I can only find an entity relation diagram.
    – Julian
    Apr 28, 2015 at 7:44
  • 2
    Magereverse can be helpful Oct 8, 2016 at 9:31
  • If I was to upload those three tables from and existing store into a new DB with a new stand alone magento build... would i have all my products available?
    – thismethod
    Nov 9, 2016 at 1:18

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.