magento1 and magento2 which table to store all the category





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}







0















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






magento2 magento-1.9 category product-attribute category-listing







share|improve this question























  • Did you even look at the database? Why not try the tables that have "category" in their name?

    – simonthesorcerer
    15 hours ago











  • I am look at the database but i know which table into magento1 and magento2 hold category all the information.

    – MehulKanjariya
    15 hours ago


















0















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






magento2 magento-1.9 category product-attribute category-listing







share|improve this question























  • Did you even look at the database? Why not try the tables that have "category" in their name?

    – simonthesorcerer
    15 hours ago











  • I am look at the database but i know which table into magento1 and magento2 hold category all the information.

    – MehulKanjariya
    15 hours ago














0












0








0








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






magento2 magento-1.9 category product-attribute category-listing







share|improve this question














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






magento2 magento-1.9 category product-attribute category-listing




magento2 magento-1.9 category product-attribute category-listing






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked 17 hours ago









MehulKanjariyaMehulKanjariya

949




949













  • Did you even look at the database? Why not try the tables that have "category" in their name?

    – simonthesorcerer
    15 hours ago











  • I am look at the database but i know which table into magento1 and magento2 hold category all the information.

    – MehulKanjariya
    15 hours ago



















  • Did you even look at the database? Why not try the tables that have "category" in their name?

    – simonthesorcerer
    15 hours ago











  • I am look at the database but i know which table into magento1 and magento2 hold category all the information.

    – MehulKanjariya
    15 hours ago

















Did you even look at the database? Why not try the tables that have "category" in their name?

– simonthesorcerer
15 hours ago





Did you even look at the database? Why not try the tables that have "category" in their name?

– simonthesorcerer
15 hours ago













I am look at the database but i know which table into magento1 and magento2 hold category all the information.

– MehulKanjariya
15 hours ago





I am look at the database but i know which table into magento1 and magento2 hold category all the information.

– MehulKanjariya
15 hours ago










2 Answers
2






active

oldest

votes


















1














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.






share|improve this answer































    0














    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"



    catalog_category_entity
    
catalog_category_entity_datetime
    
catalog_category_entity_decimal
    
catalog_category_entity_int
    
catalog_category_entity_text
    
catalog_category_entity_varchar
    
catalog_category_product
    
catalog_category_product_index
    
catalog_category_product_index_replica
    
catalog_category_product_index_store1
    
catalog_category_product_index_store1_replica
    
catalog_category_product_index_tmp
    
catalog_url_rewrite_product_category


    ** 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.






    share|improve this answer
























    • Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.

      – MehulKanjariya
      15 hours ago











    • thank you sir but i know also magento2 database

      – MehulKanjariya
      15 hours ago











    • Okay then exactly what was your concern in question ??

      – Narendra Vyas
      14 hours ago











    • I want table name know magento1 and magento2 both because my old website is magento1 and new site is magento2 so

      – MehulKanjariya
      14 hours ago











    • Sorry but still unable to get exactly what issue you are facing or what is needed

      – Narendra Vyas
      13 hours ago












    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "479"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f269013%2fmagento1-and-magento2-which-table-to-store-all-the-category%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    1














    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.






    share|improve this answer




























      1














      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.






      share|improve this answer


























        1












        1








        1







        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.






        share|improve this answer













        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.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered 14 hours ago









        NSwanson7NSwanson7

        366




        366

























            0














            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"



            catalog_category_entity
            
catalog_category_entity_datetime
            
catalog_category_entity_decimal
            
catalog_category_entity_int
            
catalog_category_entity_text
            
catalog_category_entity_varchar
            
catalog_category_product
            
catalog_category_product_index
            
catalog_category_product_index_replica
            
catalog_category_product_index_store1
            
catalog_category_product_index_store1_replica
            
catalog_category_product_index_tmp
            
catalog_url_rewrite_product_category


            ** 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.






            share|improve this answer
























            • Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.

              – MehulKanjariya
              15 hours ago











            • thank you sir but i know also magento2 database

              – MehulKanjariya
              15 hours ago











            • Okay then exactly what was your concern in question ??

              – Narendra Vyas
              14 hours ago











            • I want table name know magento1 and magento2 both because my old website is magento1 and new site is magento2 so

              – MehulKanjariya
              14 hours ago











            • Sorry but still unable to get exactly what issue you are facing or what is needed

              – Narendra Vyas
              13 hours ago
















            0














            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"



            catalog_category_entity
            
catalog_category_entity_datetime
            
catalog_category_entity_decimal
            
catalog_category_entity_int
            
catalog_category_entity_text
            
catalog_category_entity_varchar
            
catalog_category_product
            
catalog_category_product_index
            
catalog_category_product_index_replica
            
catalog_category_product_index_store1
            
catalog_category_product_index_store1_replica
            
catalog_category_product_index_tmp
            
catalog_url_rewrite_product_category


            ** 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.






            share|improve this answer
























            • Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.

              – MehulKanjariya
              15 hours ago











            • thank you sir but i know also magento2 database

              – MehulKanjariya
              15 hours ago











            • Okay then exactly what was your concern in question ??

              – Narendra Vyas
              14 hours ago











            • I want table name know magento1 and magento2 both because my old website is magento1 and new site is magento2 so

              – MehulKanjariya
              14 hours ago











            • Sorry but still unable to get exactly what issue you are facing or what is needed

              – Narendra Vyas
              13 hours ago














            0












            0








            0







            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"



            catalog_category_entity
            
catalog_category_entity_datetime
            
catalog_category_entity_decimal
            
catalog_category_entity_int
            
catalog_category_entity_text
            
catalog_category_entity_varchar
            
catalog_category_product
            
catalog_category_product_index
            
catalog_category_product_index_replica
            
catalog_category_product_index_store1
            
catalog_category_product_index_store1_replica
            
catalog_category_product_index_tmp
            
catalog_url_rewrite_product_category


            ** 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.






            share|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"



            catalog_category_entity
            
catalog_category_entity_datetime
            
catalog_category_entity_decimal
            
catalog_category_entity_int
            
catalog_category_entity_text
            
catalog_category_entity_varchar
            
catalog_category_product
            
catalog_category_product_index
            
catalog_category_product_index_replica
            
catalog_category_product_index_store1
            
catalog_category_product_index_store1_replica
            
catalog_category_product_index_tmp
            
catalog_url_rewrite_product_category


            ** 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.







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered 15 hours ago









            Narendra VyasNarendra Vyas

            35911




            35911













            • Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.

              – MehulKanjariya
              15 hours ago











            • thank you sir but i know also magento2 database

              – MehulKanjariya
              15 hours ago











            • Okay then exactly what was your concern in question ??

              – Narendra Vyas
              14 hours ago











            • I want table name know magento1 and magento2 both because my old website is magento1 and new site is magento2 so

              – MehulKanjariya
              14 hours ago











            • Sorry but still unable to get exactly what issue you are facing or what is needed

              – Narendra Vyas
              13 hours ago



















            • Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.

              – MehulKanjariya
              15 hours ago











            • thank you sir but i know also magento2 database

              – MehulKanjariya
              15 hours ago











            • Okay then exactly what was your concern in question ??

              – Narendra Vyas
              14 hours ago











            • I want table name know magento1 and magento2 both because my old website is magento1 and new site is magento2 so

              – MehulKanjariya
              14 hours ago











            • Sorry but still unable to get exactly what issue you are facing or what is needed

              – Narendra Vyas
              13 hours ago

















            Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.

            – MehulKanjariya
            15 hours ago





            Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.

            – MehulKanjariya
            15 hours ago













            thank you sir but i know also magento2 database

            – MehulKanjariya
            15 hours ago





            thank you sir but i know also magento2 database

            – MehulKanjariya
            15 hours ago













            Okay then exactly what was your concern in question ??

            – Narendra Vyas
            14 hours ago





            Okay then exactly what was your concern in question ??

            – Narendra Vyas
            14 hours ago













            I want table name know magento1 and magento2 both because my old website is magento1 and new site is magento2 so

            – MehulKanjariya
            14 hours ago





            I want table name know magento1 and magento2 both because my old website is magento1 and new site is magento2 so

            – MehulKanjariya
            14 hours ago













            Sorry but still unable to get exactly what issue you are facing or what is needed

            – Narendra Vyas
            13 hours ago





            Sorry but still unable to get exactly what issue you are facing or what is needed

            – Narendra Vyas
            13 hours ago


















            draft saved

            draft discarded




















































            Thanks for contributing an answer to Magento Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f269013%2fmagento1-and-magento2-which-table-to-store-all-the-category%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            Popular posts from this blog

            What other Star Trek series did the main TNG cast show up in?

            Image
            .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0; } 4 I'm referring to Picard, Riker, Data, Worf, Geordi, Dr. Crusher, Wesley Crusher, Chief O'Brien and family, Deanna Troi, Guinan. I know Picard and Worf show up on DS9, though I haven't seen it myself. I'm curious what happened to the characters after that last episode of TNG? star-trek star-trek-tng share | improve this question edited 10 hours ago Ham Sandwich 6,051 2 25 75 ...
            Read more

            Berlina muro

            Image
            La berlina muro ĉe Bethaniendamm, 1986 La berlina muro aŭ simple la muro [1] , nomita ankaŭ "kontraŭfaŝisma remparo" en propaganda lingvo de la iama Germana Demokratia Respubliko, estis parto de la interngermana limo, kiu dividis de la 13-a de aŭgusto 1961 ĝis la 9-a de novembro 1989 okcidentan Berlinon de la orienta parto de la urbo kaj de la ĉirkaŭa tereno de la GDR. Ĝi estis unu el la plej famaj simboloj de la malvarma milito kaj de la disdivido de Germanio. Pli ol simpla muro, la berlina muro estis fakte tuta defendokonstruaĵo kun du muroj, ena malplena strio, rondirvojo, gardturoj kaj alarmsistemoj. Dum la provo transiri la severe garditan limon al okcidenta Berlino multaj homoj estis mortigitaj. La preciza nombro de viktimoj estas pridisputita kaj ne certa; la nombroj anoncataj varias inter 86 kaj 238 mortintoj. La malplifortiĝo de Sovetunio kaj la politiko de liberigo gvidita de Miĥail Gorbaĉov ebligis al la orientgermanoj faligi la 9-an de novembro 1989 l...
            Read more

            Berlina aerponto

            Image
            Flugkoridoroj dum la blokado de Berlino La Berlina aerponto estas la provizigo de okcidenta Berlino per aviadiloj fare de la aliancanoj inter la 23-a de junio 1948 kaj la 12-a de majo 1949 dum la blokado de Berlino fare de la sovetia armeo. Enhavo 1 Historio 1.1 La aerkoridoroj 1.2 Unuaj flugoj 1.3 Plibonigo de la aerponto 1.4 Fino de la aerponto 1.5 Rozinbombiloj 1.6 Bilanco 2 Flughavenoj 2.1 Berlino 2.2 Okcidenta Germanio 3 Aviadiloj de la berlina aerponto 4 15-a datreveno de la aerponto 5 Bibliografio 6 Referencoj 7 Eksteraj ligiloj Historio | General Lucius D. Clay, militguberniestro de la usona okupadzono Jam antaŭ la berlina aerponto estiĝis la malgranda aerponto . La estro de la sovetia militadministracio en Germanio, Vasili Daniloviĉ Sokolovski, ordonis la 1-an de aprilo 1948, kiel reago al la konferenco de Londono inter britoj, francoj kaj reprezentantoj de Benelukso pri aligo de Germa...
            Read more