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


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 '15 at 7:44
  • 2
    Magereverse can be helpful – lalit mohan Oct 8 '16 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 '16 at 1:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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