Most of my categories are working fine and only loading 12 products per page. Two of my categories are loading in every product assigned to those categories causing a very high page load time.

The categories have the same relevant settings as other categories that are working correctly (Anchor -> Yes, Display: Products Only).

Products per page on grid default value is set to 12 and products per page on grid allowed values is 6, 12, 18.

List mode is set to Grid Only.

Flat catalog category and flat catalog product are set to no.

Update: I've traced through the codebase and found that this category is deciding to be set to isLoaded before calling _loadEntities() so it never calls the $this->getSelect()->limitPage($this->curPage, $this->_pageSize); however other categories get into this function because isLoaded is false. You can see this functionality in Magento\Eav\Model\Entity\Collection\AbstractCollection

  • Hi Max Can you check in backend how many products you have assigned to this categories – BartZalas Jul 5 '18 at 16:26
  • @BartZalas one of them has 23 products, the other one has 2404 – Max Jul 5 '18 at 17:17
  • Any difference in layout update in categories settings? When you choice category => layout – BartZalas Jul 5 '18 at 19:39
  • @BartZalas nope :( – Max Jul 5 '18 at 19:42
  • Can you share URL? – BartZalas Jul 5 '18 at 19:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.