Difference between index catalog_category_product and catalog_product_categorydifference between event and process in creating custom Index in magento?catalog_category_product index corrupts once in a dayDifference between _module.less and _extend.lessDifference between position and sort_order in customer install scriptWhat does `associated_item_id` (Id of the associated item) mean in `sales_order_tax_item`?Difference between total_due & base_total_duedifference between ModelProductRepository and ApiProductRepositoryInterfaceDifference between magento 1 indexing and magento 2 indexingWhat is the difference between base_grand_total and base_total_invoiced?what is difference between magento1 and magento2 sales order table list
What is the intuition for higher homotopy groups not vanishing?
Has anyone ever written a novel or short story composed of only dialogue?
Nilpotent elements of Lie algebra and unipotent groups
Will copper pour help on my single-layer PCB?
Is art a form of communication?
Improving an O(N^2) function (all entities iterating over all other entities)
Counting multiples of 3 up to a given number
Why would word of Princess Leia's capture generate sympathy for the Rebellion in the Senate?
Soft constraints and hard constraints
How to hook up Korg EX-8000 to a computer w/o a keyboard?
Why didn't Balak request Bilam to bless his own people?
How far off did Apollo 11 land?
Can two waves interfere head on?
I want light controlled by one switch, not two
Project Euler # 25 The 1000 digit Fibonacci index
Linux ext4 restore file and directory access rights after bad backup/restore
Found old paper shares of Motorola Inc that has since been broken up
Inside Out and Back to Front
Animating the result of numerical integration
Does a hash function have a Upper bound on input length?
Can a crisscrossed metallic skeleton resist earthquakes for buildings?
What does a Nintendo Game Boy do when turned on without a game cartridge inserted?
Is it ethical to tell my teaching assistant that I like him?
What does Windows' "Tuning up Application Start" do?
Difference between index catalog_category_product and catalog_product_category
difference between event and process in creating custom Index in magento?catalog_category_product index corrupts once in a dayDifference between _module.less and _extend.lessDifference between position and sort_order in customer install scriptWhat does `associated_item_id` (Id of the associated item) mean in `sales_order_tax_item`?Difference between total_due & base_total_duedifference between ModelProductRepository and ApiProductRepositoryInterfaceDifference between magento 1 indexing and magento 2 indexingWhat is the difference between base_grand_total and base_total_invoiced?what is difference between magento1 and magento2 sales order table list
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
Could someone explain me what is the difference between the indexes catalog_category_product and catalog_product_category?
From db i see that catalog_category_product is related to table catalog_category_product_index, but i don't find to which table is related catalog_product_category index.
magento2 index
asked Mar 22 '17 at 8:05
LucScuLucScu
1,45812 silver badges31 bronze badges
|
show 5 more comments
Could someone explain me what is the difference between the indexes catalog_category_product and catalog_product_category?
From db i see that catalog_category_product is related to table catalog_category_product_index, but i don't find to which table is related catalog_product_category index.
magento2 index
asked Mar 22 '17 at 8:05
LucScuLucScu
1,45812 silver badges31 bronze badges
There is nocatalog_product_categorytable in Magento 2.1.5 CE &catalog_category_productstores Category wise Product Info
– Ankit Shah
Mar 22 '17 at 8:12
Yes i see that, so what is the role of catalog_product_category index?
– LucScu
Mar 22 '17 at 8:44
There is nocatalog_product_categoryIndex table as well
– Ankit Shah
Mar 22 '17 at 8:51
@AnkitShah I think my question is clear and you continue to give useless reply. What is the role of catalog_product_category index if it isn't related to any table? What does this index when run?
– LucScu
Mar 22 '17 at 9:05
@AnkitShah Do you give vote down? Are you serious?
– LucScu
Mar 23 '17 at 7:46
|
show 5 more comments
Could someone explain me what is the difference between the indexes catalog_category_product and catalog_product_category?
From db i see that catalog_category_product is related to table catalog_category_product_index, but i don't find to which table is related catalog_product_category index.
magento2 index
asked Mar 22 '17 at 8:05
LucScuLucScu
1,45812 silver badges31 bronze badges
Could someone explain me what is the difference between the indexes catalog_category_product and catalog_product_category?
From db i see that catalog_category_product is related to table catalog_category_product_index, but i don't find to which table is related catalog_product_category index.
magento2 index
magento2 index
asked Mar 22 '17 at 8:05
LucScuLucScu
1,45812 silver badges31 bronze badges
asked Mar 22 '17 at 8:05
LucScuLucScu
1,45812 silver badges31 bronze badges
asked Mar 22 '17 at 8:05
LucScuLucScu
1,45812 silver badges31 bronze badges
asked Mar 22 '17 at 8:05
LucScuLucScu
1,45812 silver badges31 bronze badges
asked Mar 22 '17 at 8:05
LucScuLucScu
1,45812 silver badges31 bronze badges
1,45812 silver badges31 bronze badges
There is nocatalog_product_categorytable in Magento 2.1.5 CE &catalog_category_productstores Category wise Product Info
– Ankit Shah
Mar 22 '17 at 8:12
Yes i see that, so what is the role of catalog_product_category index?
– LucScu
Mar 22 '17 at 8:44
There is nocatalog_product_categoryIndex table as well
– Ankit Shah
Mar 22 '17 at 8:51
@AnkitShah I think my question is clear and you continue to give useless reply. What is the role of catalog_product_category index if it isn't related to any table? What does this index when run?
– LucScu
Mar 22 '17 at 9:05
@AnkitShah Do you give vote down? Are you serious?
– LucScu
Mar 23 '17 at 7:46
|
show 5 more comments
There is nocatalog_product_categorytable in Magento 2.1.5 CE &catalog_category_productstores Category wise Product Info
– Ankit Shah
Mar 22 '17 at 8:12
Yes i see that, so what is the role of catalog_product_category index?
– LucScu
Mar 22 '17 at 8:44
There is nocatalog_product_categoryIndex table as well
– Ankit Shah
Mar 22 '17 at 8:51
@AnkitShah I think my question is clear and you continue to give useless reply. What is the role of catalog_product_category index if it isn't related to any table? What does this index when run?
– LucScu
Mar 22 '17 at 9:05
@AnkitShah Do you give vote down? Are you serious?
– LucScu
Mar 23 '17 at 7:46
There is no
catalog_product_category table in Magento 2.1.5 CE & catalog_category_product stores Category wise Product Info– Ankit Shah
Mar 22 '17 at 8:12
There is no
catalog_product_category table in Magento 2.1.5 CE & catalog_category_product stores Category wise Product Info– Ankit Shah
Mar 22 '17 at 8:12
Yes i see that, so what is the role of catalog_product_category index?
– LucScu
Mar 22 '17 at 8:44
Yes i see that, so what is the role of catalog_product_category index?
– LucScu
Mar 22 '17 at 8:44
There is no
catalog_product_category Index table as well– Ankit Shah
Mar 22 '17 at 8:51
There is no
catalog_product_category Index table as well– Ankit Shah
Mar 22 '17 at 8:51
@AnkitShah I think my question is clear and you continue to give useless reply. What is the role of catalog_product_category index if it isn't related to any table? What does this index when run?
– LucScu
Mar 22 '17 at 9:05
@AnkitShah I think my question is clear and you continue to give useless reply. What is the role of catalog_product_category index if it isn't related to any table? What does this index when run?
– LucScu
Mar 22 '17 at 9:05
@AnkitShah Do you give vote down? Are you serious?
– LucScu
Mar 23 '17 at 7:46
@AnkitShah Do you give vote down? Are you serious?
– LucScu
Mar 23 '17 at 7:46
|
show 5 more comments
2 Answers
2
active
oldest
votes
Looking deep in magento core files, you notice that catalog_product_category index model is MagentoCatalogModelIndexerProductCategory that extends MagentoCatalogModelIndexerCategoryProduct that is the model of catalog_category_product index.
Both of them $fullActionFactory and $rowsActionFactory entities extends from MagentoCatalogModelIndexerCategoryProductAbstractAction that has
const MAIN_INDEX_TABLE = 'catalog_category_product_index';
So we can say that both indexer works and save data on the same table catalog_category_product_index.
answered Nov 23 '17 at 9:25
LucScuLucScu
1,45812 silver badges31 bronze badges
add a comment |
catalog_product_category : the "true" data saved by product. Those are the categories checked in the back-office when you edit the product.
catalog_product_category_index : where the product are "really". Meaning, if the parent category has "is_anchor" at yes, it means it has also the children category in it. So, it's "normal" to have both of those table.
answered Jul 12 at 8:00
Pol RavaliteraPol Ravalitera
4446 silver badges13 bronze badges
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%2f165536%2fdifference-between-index-catalog-category-product-and-catalog-product-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
Looking deep in magento core files, you notice that catalog_product_category index model is MagentoCatalogModelIndexerProductCategory that extends MagentoCatalogModelIndexerCategoryProduct that is the model of catalog_category_product index.
Both of them $fullActionFactory and $rowsActionFactory entities extends from MagentoCatalogModelIndexerCategoryProductAbstractAction that has
const MAIN_INDEX_TABLE = 'catalog_category_product_index';
So we can say that both indexer works and save data on the same table catalog_category_product_index.
answered Nov 23 '17 at 9:25
LucScuLucScu
1,45812 silver badges31 bronze badges
add a comment |
Looking deep in magento core files, you notice that catalog_product_category index model is MagentoCatalogModelIndexerProductCategory that extends MagentoCatalogModelIndexerCategoryProduct that is the model of catalog_category_product index.
Both of them $fullActionFactory and $rowsActionFactory entities extends from MagentoCatalogModelIndexerCategoryProductAbstractAction that has
const MAIN_INDEX_TABLE = 'catalog_category_product_index';
So we can say that both indexer works and save data on the same table catalog_category_product_index.
answered Nov 23 '17 at 9:25
LucScuLucScu
1,45812 silver badges31 bronze badges
add a comment |
Looking deep in magento core files, you notice that catalog_product_category index model is MagentoCatalogModelIndexerProductCategory that extends MagentoCatalogModelIndexerCategoryProduct that is the model of catalog_category_product index.
Both of them $fullActionFactory and $rowsActionFactory entities extends from MagentoCatalogModelIndexerCategoryProductAbstractAction that has
const MAIN_INDEX_TABLE = 'catalog_category_product_index';
So we can say that both indexer works and save data on the same table catalog_category_product_index.
answered Nov 23 '17 at 9:25
LucScuLucScu
1,45812 silver badges31 bronze badges
Looking deep in magento core files, you notice that catalog_product_category index model is MagentoCatalogModelIndexerProductCategory that extends MagentoCatalogModelIndexerCategoryProduct that is the model of catalog_category_product index.
Both of them $fullActionFactory and $rowsActionFactory entities extends from MagentoCatalogModelIndexerCategoryProductAbstractAction that has
const MAIN_INDEX_TABLE = 'catalog_category_product_index';
So we can say that both indexer works and save data on the same table catalog_category_product_index.
answered Nov 23 '17 at 9:25
LucScuLucScu
1,45812 silver badges31 bronze badges
answered Nov 23 '17 at 9:25
LucScuLucScu
1,45812 silver badges31 bronze badges
answered Nov 23 '17 at 9:25
LucScuLucScu
1,45812 silver badges31 bronze badges
answered Nov 23 '17 at 9:25
LucScuLucScu
1,45812 silver badges31 bronze badges
1,45812 silver badges31 bronze badges
add a comment |
add a comment |
catalog_product_category : the "true" data saved by product. Those are the categories checked in the back-office when you edit the product.
catalog_product_category_index : where the product are "really". Meaning, if the parent category has "is_anchor" at yes, it means it has also the children category in it. So, it's "normal" to have both of those table.
answered Jul 12 at 8:00
Pol RavaliteraPol Ravalitera
4446 silver badges13 bronze badges
add a comment |
catalog_product_category : the "true" data saved by product. Those are the categories checked in the back-office when you edit the product.
catalog_product_category_index : where the product are "really". Meaning, if the parent category has "is_anchor" at yes, it means it has also the children category in it. So, it's "normal" to have both of those table.
answered Jul 12 at 8:00
Pol RavaliteraPol Ravalitera
4446 silver badges13 bronze badges
add a comment |
catalog_product_category : the "true" data saved by product. Those are the categories checked in the back-office when you edit the product.
catalog_product_category_index : where the product are "really". Meaning, if the parent category has "is_anchor" at yes, it means it has also the children category in it. So, it's "normal" to have both of those table.
answered Jul 12 at 8:00
Pol RavaliteraPol Ravalitera
4446 silver badges13 bronze badges
catalog_product_category : the "true" data saved by product. Those are the categories checked in the back-office when you edit the product.
catalog_product_category_index : where the product are "really". Meaning, if the parent category has "is_anchor" at yes, it means it has also the children category in it. So, it's "normal" to have both of those table.
answered Jul 12 at 8:00
Pol RavaliteraPol Ravalitera
4446 silver badges13 bronze badges
answered Jul 12 at 8:00
Pol RavaliteraPol Ravalitera
4446 silver badges13 bronze badges
answered Jul 12 at 8:00
Pol RavaliteraPol Ravalitera
4446 silver badges13 bronze badges
answered Jul 12 at 8:00
Pol RavaliteraPol Ravalitera
4446 silver badges13 bronze badges
4446 silver badges13 bronze badges
add a comment |
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%2f165536%2fdifference-between-index-catalog-category-product-and-catalog-product-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
There is no
catalog_product_categorytable in Magento 2.1.5 CE &catalog_category_productstores Category wise Product Info– Ankit Shah
Mar 22 '17 at 8:12
Yes i see that, so what is the role of catalog_product_category index?
– LucScu
Mar 22 '17 at 8:44
There is no
catalog_product_categoryIndex table as well– Ankit Shah
Mar 22 '17 at 8:51
@AnkitShah I think my question is clear and you continue to give useless reply. What is the role of catalog_product_category index if it isn't related to any table? What does this index when run?
– LucScu
Mar 22 '17 at 9:05
@AnkitShah Do you give vote down? Are you serious?
– LucScu
Mar 23 '17 at 7:46