magento1 and magento2 which table to store all the category The 2019 Stack Overflow Developer Survey Results Are InHow to filter product collection using 2 or more category filters in magento2?Magento 2.2.2 Differet Store Category page was give 404 errorMagento 2 : Show only non store view Category and sub categoryMagento1 to Magento2 data migrationImport Magento1 admin users to Magento2Magento2 which table to store data like configurable productwhat is difference between magento1 and magento2 sales order table listmagento2 error like Products weight more than allowed. on checkout cart page Canada Post shippingMagento1 website Security patch installation by scriptmagento2 error like undefined Property on shipping method like canada post
What is this 4-propeller plane?
What are the motivations for publishing new editions of an existing textbook, beyond new discoveries in a field?
Carnot-Caratheodory metric
What do the Banks children have against barley water?
How to reverse every other sublist of a list?
How was Skylab's orbit inclination chosen?
How to manage monthly salary
Geography at the pixel level
The difference between dialogue marks
Monty Hall variation
Inflated grade on resume at previous job, might former employer tell new employer?
I see my dog run
Is "plugging out" electronic devices an American expression?
"To split hairs" vs "To be pedantic"
How do you say "canon" as in "official for a story universe"?
Does duplicating a spell with Wish count as casting that spell?
Why did Howard Stark use all the Vibranium they had on a prototype shield?
Unbreakable Formation vs. Cry of the Carnarium
What is the meaning of Triage in Cybersec world?
Output the Arecibo Message
Does light intensity oscillate really fast since it is a wave?
Does a dangling wire really electrocute me if I'm standing in water?
Could JWST stay at L2 "forever"?
Is domain driven design an anti-SQL pattern?
magento1 and magento2 which table to store all the category
The 2019 Stack Overflow Developer Survey Results Are InHow to filter product collection using 2 or more category filters in magento2?Magento 2.2.2 Differet Store Category page was give 404 errorMagento 2 : Show only non store view Category and sub categoryMagento1 to Magento2 data migrationImport Magento1 admin users to Magento2Magento2 which table to store data like configurable productwhat is difference between magento1 and magento2 sales order table listmagento2 error like Products weight more than allowed. on checkout cart page Canada Post shippingMagento1 website Security patch installation by scriptmagento2 error like undefined Property on shipping method like canada post
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom: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
asked Apr 6 at 11:20
MehulKanjariyaMehulKanjariya
909
add a comment |
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
asked Apr 6 at 11:20
MehulKanjariyaMehulKanjariya
909
Did you even look at the database? Why not try the tables that have "category" in their name?
– simonthesorcerer
Apr 6 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 at 13:17
why -2 given i ask question and not get solution why me given -2
– MehulKanjariya
19 hours ago
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
14 hours ago
add a comment |
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
asked Apr 6 at 11:20
MehulKanjariyaMehulKanjariya
909
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
asked Apr 6 at 11:20
MehulKanjariyaMehulKanjariya
909
asked Apr 6 at 11:20
MehulKanjariyaMehulKanjariya
909
asked Apr 6 at 11:20
MehulKanjariyaMehulKanjariya
909
asked Apr 6 at 11:20
MehulKanjariyaMehulKanjariya
909
asked Apr 6 at 11:20
MehulKanjariyaMehulKanjariya
909
909
Did you even look at the database? Why not try the tables that have "category" in their name?
– simonthesorcerer
Apr 6 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 at 13:17
why -2 given i ask question and not get solution why me given -2
– MehulKanjariya
19 hours ago
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
14 hours ago
add a comment |
Did you even look at the database? Why not try the tables that have "category" in their name?
– simonthesorcerer
Apr 6 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 at 13:17
why -2 given i ask question and not get solution why me given -2
– MehulKanjariya
19 hours ago
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
14 hours ago
Did you even look at the database? Why not try the tables that have "category" in their name?
– simonthesorcerer
Apr 6 at 12:29
Did you even look at the database? Why not try the tables that have "category" in their name?
– simonthesorcerer
Apr 6 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 at 13:17
I am look at the database but i know which table into magento1 and magento2 hold category all the information.
– MehulKanjariya
Apr 6 at 13:17
why -2 given i ask question and not get solution why me given -2
– MehulKanjariya
19 hours ago
why -2 given i ask question and not get solution why me given -2
– MehulKanjariya
19 hours ago
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
14 hours ago
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
14 hours ago
add a comment |
2 Answers
2
active
oldest
votes
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.
answered Apr 6 at 13:51
NSwanson7NSwanson7
467
add a comment |
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.
answered Apr 6 at 12:33
Narendra VyasNarendra Vyas
37911
Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.
– MehulKanjariya
Apr 6 at 13:18
thank you sir but i know also magento2 database
– MehulKanjariya
Apr 6 at 13:20
Okay then exactly what was your concern in question ??
– Narendra Vyas
Apr 6 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 at 13:24
Sorry but still unable to get exactly what issue you are facing or what is needed
– Narendra Vyas
Apr 6 at 14:30
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
answered Apr 6 at 13:51
NSwanson7NSwanson7
467
add a comment |
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.
answered Apr 6 at 13:51
NSwanson7NSwanson7
467
add a comment |
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.
answered Apr 6 at 13:51
NSwanson7NSwanson7
467
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.
answered Apr 6 at 13:51
NSwanson7NSwanson7
467
answered Apr 6 at 13:51
NSwanson7NSwanson7
467
answered Apr 6 at 13:51
NSwanson7NSwanson7
467
answered Apr 6 at 13:51
NSwanson7NSwanson7
467
467
add a comment |
add a comment |
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.
answered Apr 6 at 12:33
Narendra VyasNarendra Vyas
37911
Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.
– MehulKanjariya
Apr 6 at 13:18
thank you sir but i know also magento2 database
– MehulKanjariya
Apr 6 at 13:20
Okay then exactly what was your concern in question ??
– Narendra Vyas
Apr 6 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 at 13:24
Sorry but still unable to get exactly what issue you are facing or what is needed
– Narendra Vyas
Apr 6 at 14:30
add a comment |
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.
answered Apr 6 at 12:33
Narendra VyasNarendra Vyas
37911
Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.
– MehulKanjariya
Apr 6 at 13:18
thank you sir but i know also magento2 database
– MehulKanjariya
Apr 6 at 13:20
Okay then exactly what was your concern in question ??
– Narendra Vyas
Apr 6 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 at 13:24
Sorry but still unable to get exactly what issue you are facing or what is needed
– Narendra Vyas
Apr 6 at 14:30
add a comment |
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.
answered Apr 6 at 12:33
Narendra VyasNarendra Vyas
37911
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.
answered Apr 6 at 12:33
Narendra VyasNarendra Vyas
37911
answered Apr 6 at 12:33
Narendra VyasNarendra Vyas
37911
answered Apr 6 at 12:33
Narendra VyasNarendra Vyas
37911
answered Apr 6 at 12:33
Narendra VyasNarendra Vyas
37911
37911
Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.
– MehulKanjariya
Apr 6 at 13:18
thank you sir but i know also magento2 database
– MehulKanjariya
Apr 6 at 13:20
Okay then exactly what was your concern in question ??
– Narendra Vyas
Apr 6 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 at 13:24
Sorry but still unable to get exactly what issue you are facing or what is needed
– Narendra Vyas
Apr 6 at 14:30
add a comment |
Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.
– MehulKanjariya
Apr 6 at 13:18
thank you sir but i know also magento2 database
– MehulKanjariya
Apr 6 at 13:20
Okay then exactly what was your concern in question ??
– Narendra Vyas
Apr 6 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 at 13:24
Sorry but still unable to get exactly what issue you are facing or what is needed
– Narendra Vyas
Apr 6 at 14:30
Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.
– MehulKanjariya
Apr 6 at 13:18
Hello Narendra vyas thank you but i know which table into magento2 hold category all the information.
– MehulKanjariya
Apr 6 at 13:18
thank you sir but i know also magento2 database
– MehulKanjariya
Apr 6 at 13:20
thank you sir but i know also magento2 database
– MehulKanjariya
Apr 6 at 13:20
Okay then exactly what was your concern in question ??
– Narendra Vyas
Apr 6 at 13:22
Okay then exactly what was your concern in question ??
– Narendra Vyas
Apr 6 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 at 13:24
I want table name know magento1 and magento2 both because my old website is magento1 and new site is magento2 so
– MehulKanjariya
Apr 6 at 13:24
Sorry but still unable to get exactly what issue you are facing or what is needed
– Narendra Vyas
Apr 6 at 14:30
Sorry but still unable to get exactly what issue you are facing or what is needed
– Narendra Vyas
Apr 6 at 14:30
add a comment |
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
Did you even look at the database? Why not try the tables that have "category" in their name?
– simonthesorcerer
Apr 6 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 at 13:17
why -2 given i ask question and not get solution why me given -2
– MehulKanjariya
19 hours ago
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
14 hours ago