Magento 2 – Remove Position from Category Sorting Product List

magento2product-listsorting

I have sorted products in categories by:

price (default)
name
position

I need to remove the position from the menu leaving only price and name

I don't want to edit every single category view from the catalog–>manage categories because I have too many categories in the store.

PFA

Best Answer

quick workaround can be add a condition in theme templates file Magento_Catalog/templates/product/list/toolbar/sorter.phtml like

if $key != 'position' then don't add in drop down options :

<select id="sorter" data-role="sorter" class="sorter-options">
    <?php foreach ($block->getAvailableOrders() as $_key => $_order): ?>

        <?php if ($_key != 'position') : // if key sort by position remove it?>
        <option value="<?= /* @escapeNotVerified */ $_key ?>"
            <?php if ($block->isOrderCurrent($_key)): ?>
                selected="selected"
            <?php endif; ?>
            >
            <?= $block->escapeHtml(__($_order)) ?>
        </option>
       <?php endif; ?>

    <?php endforeach; ?>
</select>

Related Solutions

Magento – How to add attributes set column to category products grid

In the same module that you used for special price (explained here) you can add you attribute set also.
Just add this to the collection init ->addAttributeToSelect('attribute_set_id') and the corresponding column in _prepareColumns().

$sets = Mage::getResourceModel('eav/entity_attribute_set_collection')
            ->setEntityTypeFilter(Mage::getModel('catalog/product')->getResource()->getTypeId())
            ->load()
            ->toOptionHash();
    $this->addColumnAfter('set_name',
        array(
            'header'=> Mage::helper('catalog')->__('Attrib. Set Name'),
            'width' => '100px',
            'index' => 'attribute_set_id',
            'type'  => 'options',
            'options' => $sets,
    ), 'name');

Product – Programmatically Assign Product’s Categories and Sort Order/Position

You can do that writing directly to the database below is a working code that do that using an array of categories products

You have to create the array like this

            $categoryPosition[] = array('product_id' => $mageProduct->getId(),
                                        'category_id' => $categoryId,
                                        'position' => $position);

an run this code

foreach ($categoryPosition as $position){                        
            //print "Position: c=".$position['category_id']." prod=".$position['product_id']." pos=".$position['position'] . "\n";
            $query = "UPDATE tn_catalog_category_product SET position = :position "
                    . "WHERE category_id = :category_id and product_id = :product_id";
            $values = array('position' => $position['position'],
                                'category_id' => $position['category_id'],
                                'product_id' => $position['product_id']);
            $writeConnection->query($query,$values);                    
}

and remember to run the indexer catalog_category_product

Thanks

Best Answer

Related Solutions

Magento – How to add attributes set column to category products grid

Product – Programmatically Assign Product’s Categories and Sort Order/Position

Related Topic