magento1 and magento2 which table to store all the category .so which related table to store data like category and also give the different.

Thank you, Your Faithfully, Mehul Kanjariya

  • Did you even look at the database? Why not try the tables that have "category" in their name? – simonthesorcerer Apr 6 '19 at 12:29
  • I am look at the database but i know which table into magento1 and magento2 hold category all the information. – MehulKanjariya Apr 6 '19 at 13:17
  • why -2 given i ask question and not get solution why me given -2 – MehulKanjariya Apr 9 '19 at 10:35
  • Because your question is unclear, your comments to the answers are unclear, and you show zero effort to solve the problem by yourself. There is now table that holds "all information", as the answers have explained, and you simply lack basic understanding of the Magento database structure, as the answers have explained. And this is something that you can simply type into google, and will see a lot of results, instead of asking here and waste ppls time. – simonthesorcerer Apr 9 '19 at 16:20
  • so give me proper solution ok – MehulKanjariya Apr 10 '19 at 12:58

As others have mentioned there are many tables used for any entity in Magento because of the use of EAV (entity attribute value). I wouldn't recommend working with the database directly until you understand exactly what is happening when performing any sort of CRUD action on an entity. You can very easily end up with orphaned rows.

| improve this answer | |

Do you only need the names of tables containing category data ??

As Magento uses EAV structure so there can not be only one table holding the data. I have attached the names of various tables below.

You can find listing of all categories in this table "catalog_category_entity"


** This is for Magento2 for Magento1 you can find almost same names with some different structure, better to directly go into database and have a look by filtering with category name.

| improve this answer | |
  • Hello Narendra vyas thank you but i know which table into magento2 hold category all the information. – MehulKanjariya Apr 6 '19 at 13:18
  • thank you sir but i know also magento2 database – MehulKanjariya Apr 6 '19 at 13:20
  • Okay then exactly what was your concern in question ?? – Narendra Vyas Apr 6 '19 at 13:22
  • I want table name know magento1 and magento2 both because my old website is magento1 and new site is magento2 so – MehulKanjariya Apr 6 '19 at 13:24
  • Sorry but still unable to get exactly what issue you are facing or what is needed – Narendra Vyas Apr 6 '19 at 14:30

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