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;
}
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 17 hours ago
MehulKanjariyaMehulKanjariya
949
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 17 hours ago
MehulKanjariyaMehulKanjariya
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
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 17 hours ago
MehulKanjariyaMehulKanjariya
949
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 17 hours ago
MehulKanjariyaMehulKanjariya
949
asked 17 hours ago
MehulKanjariyaMehulKanjariya
949
asked 17 hours ago
MehulKanjariyaMehulKanjariya
949
asked 17 hours ago
MehulKanjariyaMehulKanjariya
949
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
add a comment |
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
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 14 hours ago
NSwanson7NSwanson7
366
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 15 hours ago
Narendra VyasNarendra Vyas
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
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 14 hours ago
NSwanson7NSwanson7
366
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 14 hours ago
NSwanson7NSwanson7
366
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 14 hours ago
NSwanson7NSwanson7
366
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 14 hours ago
NSwanson7NSwanson7
366
answered 14 hours ago
NSwanson7NSwanson7
366
answered 14 hours ago
NSwanson7NSwanson7
366
answered 14 hours ago
NSwanson7NSwanson7
366
366
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 15 hours ago
Narendra VyasNarendra Vyas
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
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 15 hours ago
Narendra VyasNarendra Vyas
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
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 15 hours ago
Narendra VyasNarendra Vyas
35911
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 15 hours ago
Narendra VyasNarendra Vyas
35911
answered 15 hours ago
Narendra VyasNarendra Vyas
35911
answered 15 hours ago
Narendra VyasNarendra Vyas
35911
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
add a comment |
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
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
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