Questions tagged [sorting]

Denotes questions related to sorting collections in Magento.

Filter by
Sorted by
Tagged with
0
votes
3answers
34 views

How to sort modules in config.php alphabetically?

Is it possible to sort the output of the modules node in config.php alphabetically? This way git versioning won't get messed up since Magento sometimes changes the sorting. <?php return [ '...
0
votes
0answers
11 views

Magento 2.4 sorting issue due to pricing by some additional attributes

We have a site where we have to sort products by price to display in collection. But there are few attributes that too are considered while calculation final price and even on listing we want to show ...
0
votes
0answers
16 views

Magento 2 sort by price ASC not working

Magento 2 sort by price not working. DESC order working fine but ASC order, not getting the order for configurable products. One more is like catalog_product_index_price in this table showing zero for ...
0
votes
0answers
31 views

Magento 2 | Change sort order for search results

I would like to set as the default order in the search results page "relevance" in descending order. How can i do? Thanks
0
votes
0answers
57 views

Magento 2.3.2 sort the product collection by attributes

I want to sort the product collection by attributes. I want to apply multiple sorting to the product collection need to sort by NEW, ONSALE, and POSITION For example when going to any listing page ...
0
votes
0answers
8 views

How to show Shipping & Handeling after tax in order totals section admin order view?

I want to show Shipping & Handeling after Tax and just before Grand Total in order view page in admin. I have tried to change sort order from backend but this is not working for me.
0
votes
0answers
47 views

Magento 2.3 product listing page sorting not working - using varnish and elasticsearch

I was trying to show the products listing order by product id descending in any condition except price. So, I override the \Magento\Catalog\Block\Product\ProductList\Toolbar class with plugin and did ...
0
votes
1answer
21 views

Can we update Product Position in Category with CSV in M2?

Can we update products position with csv in Category ? If yes than please share share any sample or example. Thanks
0
votes
0answers
28 views

Best way to do this?

I've been racking my brains for a long time trying to think of the best most efficient way to solve the following problem. Basically I have a set of questions which I'm looping through in the ...
2
votes
1answer
71 views

Custom Sorting on category page not working in Magento 2.4.2

I have Magento 2.4.2. I have written a custom code to add A-Z & Z-A filters on category page. I have added dependency injection using below code <preference for="Magento\Catalog\Block\...
1
vote
0answers
92 views

Magento 2.4.2 and elasticsearch issue (sort by position)

As I have seen, sort by "position" does not work with Elasticsearch (I have no result when I want to see the products in a category). I would like to disable position sorting on ALL ...
0
votes
1answer
48 views

Paginate order list by 15 items and sort by price ASC

I need to do sort by price and paginate by 15 items for order list history page, can anyone help?
0
votes
0answers
45 views

Magento 2 - Cannot configure sort options in the backend

im trying to configure the sort options available in the category page. but it doesnt seem to work. i only need 'position' and 'price' as options but its displaying other attribute than the one i ...
0
votes
2answers
357 views

Sort products by In stock in magento 2.4

Can we sort products In stock only. see the below screenshot.
0
votes
0answers
20 views

Custom module sort and search filter not working

I've created a custom module. The sorting and search filter not working on the grid page. <arguments> <argument name="id" xsi:type="string">testGrid</argument> &...
0
votes
0answers
57 views

Sorting by position not working with Elastic Search 6+ on magento 2.3.3

When I use mysql as a default search engine in magento 2.3.3 everything works fine as it should but as I change the default search engine to Elastic Search 6+ the sort by position attribute does not ...
0
votes
0answers
35 views

Sort product list widget by position?

I added a prodct list widget that should show products from one category, sort by position. Sort products in widgets seems not to work, so I tried a suggested module from this question. It adds a ...
0
votes
1answer
172 views

Magento 2.4 : Sort Product by attribute value

i have configurable and simple product in my website with Attribute color: (Values - Red, Green, Blue) I want to sort product on the listing page with specific attribute value, for example, all ...
0
votes
0answers
35 views

In Navigation top menu sort default and custom added links

Kindly read it out carefully because for me it is somehow confusing. 1- I have default links in navigation like (What's New, Women, Collection). I have sorted them by adding category attributes (sort ...
0
votes
0answers
30 views

Magento 2 : When I special price bulk update price sorting is not working

My site has just configurable products only. I want to sort by price. For products so when users sort products by price, sorting looks wrong. So I have checked so Price(Low to High) Sorting not ...
1
vote
1answer
242 views

How can you map a virtual column in magento 2.4.1?

I have just upgraded to Magento 2.4.1 that REQUIRES you to use Elasticsearch as the search engine instead of MySql. In the previous setup (Magento 2.3.2) I had a custom sort by a discount in the ...
3
votes
2answers
1k views

Elastic Search: Custom sorting options not working after enable elastic search

I'm trying to add custom sorting options like newest products,price high-to-low & price low-to-high in category page using plugin. After creating plugin it's working good in category page and ...
0
votes
1answer
116 views

Column 'created_at' not imported

My goal is to sort products on the frontend from newest to oldest. The products CSV file contains the created_at column (e.g. 2020-10-31 14:05:44). Format seems to be correct. After the standard ...
0
votes
1answer
22 views

Magento2 query displaying perfect result in database but wrong in collection while sorting by created_at

Magento2 query displaying perfect result in database but wrong in collection while sorting by created_at Query SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `...
0
votes
1answer
68 views

Category Products - Sort By Newest

Since upgrading to Magento 2.4x and having to use ElasticSearch as default, I am unable to find a way to sort category products by newest (created_at). I have tried enabling used_in_sort_by for ...
0
votes
0answers
59 views

Magento2.4 sort by created date not working

Magento2.4 Sort by created date not working on list page case 'new_arrivals': $this->_collection->getSelect()->order('e.created_at '. $this->getCurrentDirection()); break; It just ...
-1
votes
3answers
256 views

Magento 2 - Sort by Brand and Position?

Is it possible to sort by A the Brand alphabetically and then B by Position Programmatically.
1
vote
0answers
29 views

Sorting Products at Category Page

Is there a way to bulk update products position at Category Page importing a CSV file via System -> Data Transfer -> Import ? Cordially, Daniel Mas
2
votes
1answer
902 views

Magento 2 GrahQL Product Sorting does not work for the product query with category Filter

I have this graphQL query { products(filter: {category_id:{eq: "5"}, price: {from: "0", to: "999999"}}, pageSize: 10, currentPage: 1 sort: {position: DESC}) { ...
1
vote
1answer
394 views

Custom column sorting(DESC and ASC) not working in custom grid Magento 2.3.5

Actually in below listing.xml file i am trying to sort customer_id column DESC/ASC but not working fine. After using below code it's loading the data in ASC order only if sort customer_id column one ...
0
votes
1answer
58 views

Show products with zero quantity last in Magento 1.9

I want to show products with zero quantity last in all site categories, search results, etc. But the sort order should be as follows: the products with a non-zero quantity (not in decreasing, default (...
0
votes
1answer
139 views

Change order of widget catalog products list

I have a product in my product list, which must be at the top. After I have extended the product list, the product is unfortunately no longer at the top. I add the product list via the widget catalog ...
1
vote
2answers
368 views

Magento 1.9 How to sort product in category page by stocks product

I want the products to be displayed on the category page, if available That is, first those that are stocks , then those that are not stocks I didn't find anything with the title in the attribute Is ...
1
vote
0answers
272 views

Sort Menu items in aphabetical order magento 2 in observer

I am creating menu items in magento 2. I is working fine and generated according to category order in admin dashboard. But I wanted to sort the menu items alphabetically on store front ir-respective ...
1
vote
0answers
65 views

Magento 2.3 sortOrders not working in search rest API

I tried to pass sort order in V1/search API as below but the sorting is not working in the result. searchCriteria[sortOrders][0][field]=price searchCriteria[sortOrders][0][direction]=DESC Anyone has ...
1
vote
0answers
70 views

How to sort product by position, if every product has same position?

I read somewhere that if all product has same position it will sort by product id, but I don't think its sorting by Id. Here are a few screenshots I am sharing which I am sorting by position problem ...
0
votes
1answer
534 views

Sort product collection by date in standart category view

I'm running Magento CE 2.3.3 with Porto theme. I want to sort the products in the category overview by the date they were added without using an extra extension. By default products in category view/...
3
votes
8answers
1k views

Magento2: I want to show featured product on top of the category and search result

I have yes/no type product attribute. If this featured attribute is yes for any products, those product will show top(first featured product showing in category page then rest of the products are ...
0
votes
1answer
552 views

Products in Category Default Sort and Direction on Position Column

In catalog Category's assigned product grid, sort order is applied on entity_id as DESC by default like this: But I want to apply sort order by default on position as ASC like this: I found a file /...
2
votes
3answers
1k views

Magento 2.3 Natural Sort Order for Numeric Attributes / Sort Order Wrong

I have a custom attribute (text field) - let's call it "size". It contains numeric values like 1,2,3,10,20,30. Products are sorted by this attribute on the category page. Expected sort order: 1,2,...
1
vote
2answers
392 views

Magento 2: Multiple Product Type Not Sorting Due To Amasty Extension

I'm facing a problem due to Amasty Extension. I have a category which has 1 simple product and some configurable products, but when I try to sort them, simple product always comes first although ...
0
votes
0answers
166 views

Magento 2 : on page load product sorting not working

When I go on the category page, sorting does not work unless I select any value from dropdowns like position or price then it sorts the product. http://prntscr.com/q97trw Can anyone help me how can ...
1
vote
1answer
733 views

Sort the product collection before load by attribute option in Magento2

I am trying to sort the Product collection based on the attribute option value, I used below plugin Vendor/Module/di.xml <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/...
2
votes
2answers
87 views

Sorting on a date's component

For Magento 1.x How do I sort product based on a date attribute by a month and year only, rather than on the whole date? The code looks a bit like this: Mage::getSingleton('...')->...
0
votes
0answers
132 views

Sorting products based on a custom attribute Magento2

I have a plugin that adds some custom product sorting, based on a customer attribute, in a way similar to below. # Vendor\ModuleName\Plugin\Product\ProductList\Toolbar; case 'capacity_low_to_high': ...
1
vote
1answer
1k views

How to change products sort order in magento 2?

In product list page I need to change the sorting order. I have a current order like: Description A-Z Price High To Low Price Low to High Description Z-A I need to change it to. Description A-Z ...
0
votes
1answer
71 views

Magento 2: sort values in collection with unique flag

I have an array as collection and ordered it in ascending order with respect to expiry date as below: $creditDetails = $this->_creditFactory->create()->addFieldToFilter('customer_id', 1)->...
0
votes
1answer
102 views

Magento 2: Display out of stock items in the end in API

I am using a headless magento 2 approach for my store. I have made an API which accepts parameters like: category_slug, sort_by, sort_order, page_size, current_page and returns the products ...
0
votes
0answers
954 views

Magento 2 Sort product in cms page widget block

I want to insert multiple products in a cms page using SKU . So i did using blocks . So please see my code {{widget type="Magento\CatalogWidget\Block\Product\ProductsList" show_pager="0" ...
1
vote
1answer
423 views

Magento 2 How to sort admin column in desc order?

I have a custom grid, I am trying to sort it in desc order What I did Try 1:- In my Grid Collection: protected function _renderFiltersBefore() { $orderUpdate = $this->getTable('xyztable');...

1
2 3 4 5
8