Ttdfjt

Burned out due to current job, Can I take a week of vacation between jobs?

Does an eye for an eye mean monetary compensation?

Why isn't 'chemically-strengthened glass' made with potassium carbonate? To begin with?

Where is Jon going?

“For nothing” = “pour rien”?

Sorting with IComparable design

How does the Earth's center produce heat?

Do copyright notices need to be placed at the beginning of a file?

Best shape for a necromancer's undead minions for battle?

Why did other houses not demand this?

Interpretation of ROC AUC score

What is the use case for non-breathable waterproof pants?

Why do Russians almost not use verbs of possession akin to "have"?

Python program for fibonacci sequence using a recursive function

Are cells guaranteed to get at least one mitochondrion when they divide?

What did the 'turbo' button actually do?

Why sampling a periodic signal doesn't yield a periodic discrete signal?

Creating second map without labels using QGIS?

One word for 'the thing that attracts me'?

What is the recommended procedure to land a taildragger in a crosswind?

How to keep consistency across the application architecture as a team grows?

How to melt snow without fire or using body heat?

Count all vowels in string

How did NASA Langley end up with the first 737?

How to sort product collection on stock status

Magento 2 : product collection ASC sort by categoryCreate categories through installerProducts from a category plus any children and get category ID for conditions from collectionGet all associated value of a attributes in all products of categoryInserting multiple CMS blocks into a product collectionchange logic stock status for visibility product viewHow to change dynamic attributes when simple product is selectedGet product Category from Parent Product using SQL queryMagento 1.9: How to show instock items first in product listing even after using sortingwhere is filter applied to get product collectionCould not filter product collection in Mage_Catalog_Block_Product_List by a custom attribute in magento 1.9

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I want to sort product collection on category page so that the in stock products shall appear before out of stock products. All the out of stock products will be displayed after the in stock products. I have already rewritten the Mage_Product_Block_List block. After rewriting I have tried the following:

protected function _getProductCollection()

 if (is_null($this->_productCollection)) 
 $layer = $this->getLayer();
 /* @var $layer Mage_Catalog_Model_Layer */
 if ($this->getShowRootCategory()) 
 $this->setCategoryId(Mage::app()->getStore()->getRootCategoryId());
 

 // if this is a product view page
 if (Mage::registry('product')) 
 // get collection of categories this product is associated with
 $categories = Mage::registry('product')->getCategoryCollection()
 ->setPage(1, 1)
 ->load();
 // if the product is associated with any category
 if ($categories->count()) 
 // show products from this category
 $this->setCategoryId(current($categories->getIterator()));
 
 

 $origCategory = null;
 if ($this->getCategoryId()) 
 $category = Mage::getModel('catalog/category')->load($this->getCategoryId());
 if ($category->getId()) 
 $origCategory = $layer->getCurrentCategory();
 $layer->setCurrentCategory($category);
 $this->addModelTags($category);
 
 
 **$this->_productCollection = $layer->getProductCollection()->addAttributeToSort('stock_status', desc);**

 $this->prepareSortableFieldsByCategory($layer->getCurrentCategory());

 if ($origCategory) 
 $layer->setCurrentCategory($origCategory);
 
 

 return $this->_productCollection;

magento-1.9 stock-status

share|improve this question

edited Sep 3 '16 at 8:20

Abhishek Dhanraj Shahdeo

asked Sep 3 '16 at 8:02

Abhishek Dhanraj ShahdeoAbhishek Dhanraj Shahdeo

2972722

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  can you please provide me code?? what you have tried so far
  
  – Murtuza Zabuawala
  Sep 3 '16 at 8:12
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have also tried to sort with inventory_stock_availability, is_in_stock, etc. and none worked out for me.
  
  – Abhishek Dhanraj Shahdeo
  Sep 3 '16 at 8:22
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  any update on this??
  
  – Murtuza Zabuawala
  Sep 5 '16 at 8:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try My answer and let me know
  
  – Murtuza Zabuawala
  Sep 6 '16 at 16:38
  

  
  
  
  

add a comment | 

1

I want to sort product collection on category page so that the in stock products shall appear before out of stock products. All the out of stock products will be displayed after the in stock products. I have already rewritten the Mage_Product_Block_List block. After rewriting I have tried the following:

protected function _getProductCollection()

 if (is_null($this->_productCollection)) 
 $layer = $this->getLayer();
 /* @var $layer Mage_Catalog_Model_Layer */
 if ($this->getShowRootCategory()) 
 $this->setCategoryId(Mage::app()->getStore()->getRootCategoryId());
 

 // if this is a product view page
 if (Mage::registry('product')) 
 // get collection of categories this product is associated with
 $categories = Mage::registry('product')->getCategoryCollection()
 ->setPage(1, 1)
 ->load();
 // if the product is associated with any category
 if ($categories->count()) 
 // show products from this category
 $this->setCategoryId(current($categories->getIterator()));
 
 

 $origCategory = null;
 if ($this->getCategoryId()) 
 $category = Mage::getModel('catalog/category')->load($this->getCategoryId());
 if ($category->getId()) 
 $origCategory = $layer->getCurrentCategory();
 $layer->setCurrentCategory($category);
 $this->addModelTags($category);
 
 
 **$this->_productCollection = $layer->getProductCollection()->addAttributeToSort('stock_status', desc);**

 $this->prepareSortableFieldsByCategory($layer->getCurrentCategory());

 if ($origCategory) 
 $layer->setCurrentCategory($origCategory);
 
 

 return $this->_productCollection;

magento-1.9 stock-status

share|improve this question

edited Sep 3 '16 at 8:20

Abhishek Dhanraj Shahdeo

asked Sep 3 '16 at 8:02

Abhishek Dhanraj ShahdeoAbhishek Dhanraj Shahdeo

2972722

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  can you please provide me code?? what you have tried so far
  
  – Murtuza Zabuawala
  Sep 3 '16 at 8:12
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have also tried to sort with inventory_stock_availability, is_in_stock, etc. and none worked out for me.
  
  – Abhishek Dhanraj Shahdeo
  Sep 3 '16 at 8:22
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  any update on this??
  
  – Murtuza Zabuawala
  Sep 5 '16 at 8:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try My answer and let me know
  
  – Murtuza Zabuawala
  Sep 6 '16 at 16:38
  

  
  
  
  

add a comment | 

I want to sort product collection on category page so that the in stock products shall appear before out of stock products. All the out of stock products will be displayed after the in stock products. I have already rewritten the Mage_Product_Block_List block. After rewriting I have tried the following:

protected function _getProductCollection()

 if (is_null($this->_productCollection)) 
 $layer = $this->getLayer();
 /* @var $layer Mage_Catalog_Model_Layer */
 if ($this->getShowRootCategory()) 
 $this->setCategoryId(Mage::app()->getStore()->getRootCategoryId());
 

 // if this is a product view page
 if (Mage::registry('product')) 
 // get collection of categories this product is associated with
 $categories = Mage::registry('product')->getCategoryCollection()
 ->setPage(1, 1)
 ->load();
 // if the product is associated with any category
 if ($categories->count()) 
 // show products from this category
 $this->setCategoryId(current($categories->getIterator()));
 
 

 $origCategory = null;
 if ($this->getCategoryId()) 
 $category = Mage::getModel('catalog/category')->load($this->getCategoryId());
 if ($category->getId()) 
 $origCategory = $layer->getCurrentCategory();
 $layer->setCurrentCategory($category);
 $this->addModelTags($category);
 
 
 **$this->_productCollection = $layer->getProductCollection()->addAttributeToSort('stock_status', desc);**

 $this->prepareSortableFieldsByCategory($layer->getCurrentCategory());

 if ($origCategory) 
 $layer->setCurrentCategory($origCategory);
 
 

 return $this->_productCollection;

magento-1.9 stock-status

share|improve this question

edited Sep 3 '16 at 8:20

Abhishek Dhanraj Shahdeo

asked Sep 3 '16 at 8:02

Abhishek Dhanraj ShahdeoAbhishek Dhanraj Shahdeo

2972722

protected function _getProductCollection()

 if (is_null($this->_productCollection)) 
 $layer = $this->getLayer();
 /* @var $layer Mage_Catalog_Model_Layer */
 if ($this->getShowRootCategory()) 
 $this->setCategoryId(Mage::app()->getStore()->getRootCategoryId());
 

 // if this is a product view page
 if (Mage::registry('product')) 
 // get collection of categories this product is associated with
 $categories = Mage::registry('product')->getCategoryCollection()
 ->setPage(1, 1)
 ->load();
 // if the product is associated with any category
 if ($categories->count()) 
 // show products from this category
 $this->setCategoryId(current($categories->getIterator()));
 
 

 $origCategory = null;
 if ($this->getCategoryId()) 
 $category = Mage::getModel('catalog/category')->load($this->getCategoryId());
 if ($category->getId()) 
 $origCategory = $layer->getCurrentCategory();
 $layer->setCurrentCategory($category);
 $this->addModelTags($category);
 
 
 **$this->_productCollection = $layer->getProductCollection()->addAttributeToSort('stock_status', desc);**

 $this->prepareSortableFieldsByCategory($layer->getCurrentCategory());

 if ($origCategory) 
 $layer->setCurrentCategory($origCategory);
 
 

 return $this->_productCollection;

share|improve this question

edited Sep 3 '16 at 8:20

Abhishek Dhanraj Shahdeo

asked Sep 3 '16 at 8:02

Abhishek Dhanraj ShahdeoAbhishek Dhanraj Shahdeo

2972722

share|improve this question

edited Sep 3 '16 at 8:20

Abhishek Dhanraj Shahdeo

asked Sep 3 '16 at 8:02

Abhishek Dhanraj ShahdeoAbhishek Dhanraj Shahdeo

2972722

asked Sep 3 '16 at 8:02

Abhishek Dhanraj ShahdeoAbhishek Dhanraj Shahdeo

2972722

asked Sep 3 '16 at 8:02

Abhishek Dhanraj ShahdeoAbhishek Dhanraj Shahdeo

2972722

1 Answer
1

active

oldest

votes

0

you can not do as

$this->_productCollection = $layer->getProductCollection()->addAttributeToSort('stock_status', desc);

To achieve this you have to do left join

$this->_productCollection = $layer->getProductCollection()->joinLeft(array('bs'=>'cataloginventory/stock_status'), 'bs.product_id = e.entity_id', array('stock_status' => 'bs.stock_status'))->order("stock_status desc"); 

try this and let me know its working or not

share|improve this answer

edited Sep 3 '16 at 10:25

answered Sep 3 '16 at 9:42

Murtuza ZabuawalaMurtuza Zabuawala

12.8k73363

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you please help me here ? magento.stackexchange.com/questions/269282/…
  
  – Emipro Technologies Pvt. Ltd.
  Apr 9 at 6:12
  

  
  
  
  

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
);



);

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f134566%2fhow-to-sort-product-collection-on-stock-status%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

you can not do as

$this->_productCollection = $layer->getProductCollection()->addAttributeToSort('stock_status', desc);

To achieve this you have to do left join

$this->_productCollection = $layer->getProductCollection()->joinLeft(array('bs'=>'cataloginventory/stock_status'), 'bs.product_id = e.entity_id', array('stock_status' => 'bs.stock_status'))->order("stock_status desc"); 

try this and let me know its working or not

share|improve this answer

edited Sep 3 '16 at 10:25

answered Sep 3 '16 at 9:42

Murtuza ZabuawalaMurtuza Zabuawala

12.8k73363

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you please help me here ? magento.stackexchange.com/questions/269282/…
  
  – Emipro Technologies Pvt. Ltd.
  Apr 9 at 6:12
  

  
  
  
  

add a comment | 

0

you can not do as

$this->_productCollection = $layer->getProductCollection()->addAttributeToSort('stock_status', desc);

To achieve this you have to do left join

$this->_productCollection = $layer->getProductCollection()->joinLeft(array('bs'=>'cataloginventory/stock_status'), 'bs.product_id = e.entity_id', array('stock_status' => 'bs.stock_status'))->order("stock_status desc"); 

try this and let me know its working or not

share|improve this answer

edited Sep 3 '16 at 10:25

answered Sep 3 '16 at 9:42

Murtuza ZabuawalaMurtuza Zabuawala

12.8k73363

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you please help me here ? magento.stackexchange.com/questions/269282/…
  
  – Emipro Technologies Pvt. Ltd.
  Apr 9 at 6:12
  

  
  
  
  

add a comment | 

you can not do as

$this->_productCollection = $layer->getProductCollection()->addAttributeToSort('stock_status', desc);

To achieve this you have to do left join

$this->_productCollection = $layer->getProductCollection()->joinLeft(array('bs'=>'cataloginventory/stock_status'), 'bs.product_id = e.entity_id', array('stock_status' => 'bs.stock_status'))->order("stock_status desc"); 

try this and let me know its working or not

share|improve this answer

edited Sep 3 '16 at 10:25

answered Sep 3 '16 at 9:42

Murtuza ZabuawalaMurtuza Zabuawala

12.8k73363

$this->_productCollection = $layer->getProductCollection()->addAttributeToSort('stock_status', desc);

$this->_productCollection = $layer->getProductCollection()->joinLeft(array('bs'=>'cataloginventory/stock_status'), 'bs.product_id = e.entity_id', array('stock_status' => 'bs.stock_status'))->order("stock_status desc"); 

share|improve this answer

edited Sep 3 '16 at 10:25

answered Sep 3 '16 at 9:42

Murtuza ZabuawalaMurtuza Zabuawala

12.8k73363

answered Sep 3 '16 at 9:42

Murtuza ZabuawalaMurtuza Zabuawala

12.8k73363

answered Sep 3 '16 at 9:42

Murtuza ZabuawalaMurtuza Zabuawala

12.8k73363