My category navigation layered navigation is showing no products
I am newbie in Magento 2, I configured the Magento 2 layered Navigation and did everything to set layered navigation for categories and size and color.
Layered Navigation is working perfect for color but not for categories and size.
When i select any size in Magento 2 layered navigation it shows no product but at side it shows number of products in that category.
I think this is Magento 2 bug, because i tried every settings and looked at every overriding file to check if there's any file causing error.
Here is what it seems like
For size it is showing only first and last size but not all sizes in siz attributes.
magento2 magento-2.1 category layered-navigation
edited yesterday
Abhishek Panchal
3,4122929
asked yesterday
CrackIt
268
add a comment |
I am newbie in Magento 2, I configured the Magento 2 layered Navigation and did everything to set layered navigation for categories and size and color.
Layered Navigation is working perfect for color but not for categories and size.
When i select any size in Magento 2 layered navigation it shows no product but at side it shows number of products in that category.
I think this is Magento 2 bug, because i tried every settings and looked at every overriding file to check if there's any file causing error.
Here is what it seems like
For size it is showing only first and last size but not all sizes in siz attributes.
magento2 magento-2.1 category layered-navigation
edited yesterday
Abhishek Panchal
3,4122929
asked yesterday
CrackIt
268
add a comment |
I am newbie in Magento 2, I configured the Magento 2 layered Navigation and did everything to set layered navigation for categories and size and color.
Layered Navigation is working perfect for color but not for categories and size.
When i select any size in Magento 2 layered navigation it shows no product but at side it shows number of products in that category.
I think this is Magento 2 bug, because i tried every settings and looked at every overriding file to check if there's any file causing error.
Here is what it seems like
For size it is showing only first and last size but not all sizes in siz attributes.
magento2 magento-2.1 category layered-navigation
edited yesterday
Abhishek Panchal
3,4122929
asked yesterday
CrackIt
268
I am newbie in Magento 2, I configured the Magento 2 layered Navigation and did everything to set layered navigation for categories and size and color.
Layered Navigation is working perfect for color but not for categories and size.
When i select any size in Magento 2 layered navigation it shows no product but at side it shows number of products in that category.
I think this is Magento 2 bug, because i tried every settings and looked at every overriding file to check if there's any file causing error.
Here is what it seems like
For size it is showing only first and last size but not all sizes in siz attributes.
magento2 magento-2.1 category layered-navigation
magento2 magento-2.1 category layered-navigation
edited yesterday
Abhishek Panchal
3,4122929
asked yesterday
CrackIt
268
edited yesterday
Abhishek Panchal
3,4122929
asked yesterday
CrackIt
268
edited yesterday
Abhishek Panchal
3,4122929
edited yesterday
Abhishek Panchal
3,4122929
edited yesterday
Abhishek Panchal
3,4122929
3,4122929
asked yesterday
CrackIt
268
asked yesterday
CrackIt
268
asked yesterday
CrackIt
268
268
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I also think that it's a bug. However, you can fix it temporarily. Replace these codes in vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:
)->join(
['cpa' => $attribute->getBackend()->getTable()],
'cpe.' . $aiField . ' = cpa.' . $aiField,
['store_id', 'value']
with these lines:
)->join(
['cpa' => $attribute->getBackend()->getTable()],
'cpe.' . $aiField . ' = cpa.' . 'row_id' //$aiField,
['store_id', 'value']
answered 10 hours ago
Md. Ehsanul Haque Kanan
154
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%2f256854%2fmy-category-navigation-layered-navigation-is-showing-no-products%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I also think that it's a bug. However, you can fix it temporarily. Replace these codes in vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:
)->join(
['cpa' => $attribute->getBackend()->getTable()],
'cpe.' . $aiField . ' = cpa.' . $aiField,
['store_id', 'value']
with these lines:
)->join(
['cpa' => $attribute->getBackend()->getTable()],
'cpe.' . $aiField . ' = cpa.' . 'row_id' //$aiField,
['store_id', 'value']
answered 10 hours ago
Md. Ehsanul Haque Kanan
154
add a comment |
I also think that it's a bug. However, you can fix it temporarily. Replace these codes in vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:
)->join(
['cpa' => $attribute->getBackend()->getTable()],
'cpe.' . $aiField . ' = cpa.' . $aiField,
['store_id', 'value']
with these lines:
)->join(
['cpa' => $attribute->getBackend()->getTable()],
'cpe.' . $aiField . ' = cpa.' . 'row_id' //$aiField,
['store_id', 'value']
answered 10 hours ago
Md. Ehsanul Haque Kanan
154
add a comment |
I also think that it's a bug. However, you can fix it temporarily. Replace these codes in vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:
)->join(
['cpa' => $attribute->getBackend()->getTable()],
'cpe.' . $aiField . ' = cpa.' . $aiField,
['store_id', 'value']
with these lines:
)->join(
['cpa' => $attribute->getBackend()->getTable()],
'cpe.' . $aiField . ' = cpa.' . 'row_id' //$aiField,
['store_id', 'value']
answered 10 hours ago
Md. Ehsanul Haque Kanan
154
I also think that it's a bug. However, you can fix it temporarily. Replace these codes in vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:
)->join(
['cpa' => $attribute->getBackend()->getTable()],
'cpe.' . $aiField . ' = cpa.' . $aiField,
['store_id', 'value']
with these lines:
)->join(
['cpa' => $attribute->getBackend()->getTable()],
'cpe.' . $aiField . ' = cpa.' . 'row_id' //$aiField,
['store_id', 'value']
answered 10 hours ago
Md. Ehsanul Haque Kanan
154
answered 10 hours ago
Md. Ehsanul Haque Kanan
154
answered 10 hours ago
Md. Ehsanul Haque Kanan
154
answered 10 hours ago
Md. Ehsanul Haque Kanan
154
154
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f256854%2fmy-category-navigation-layered-navigation-is-showing-no-products%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
