Questions tagged [sorting]

Denotes questions related to sorting collections in Magento.

Filter by
Sorted by
Tagged with
0
votes
0answers
18 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 /...
0
votes
1answer
19 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
1answer
103 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
24 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 Like in this URL https://...
1
vote
1answer
60 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/...
0
votes
0answers
24 views

Sort attributes in layered navigation. M2

I'm trying to sort options of attributes in alphabetic order. For example we have attribute "color" and there is options: 1) attr 2) bttr 3) attr2 I need to sort this options like: 1) attr 2) ...
0
votes
0answers
21 views

Magento 2.3.1 Sorting on front end category page not working

I've added a custom attribute 'screen_size' and given it set values as drop-down list, but when I've added it as a sort-able field it's not actually picking up the value of the attribute but rather ...
2
votes
2answers
79 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
23 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
99 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
38 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
24 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
153 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" ...
0
votes
0answers
11 views

Changing order of color attributes for admins

Trying to change the order of our list of colors (attributes > product > color) for easier admin management. I've seen a few SQL solutions, but wondered if anyone had used JS, or something similar to ...
1
vote
1answer
89 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
vote
0answers
30 views

Sorting is not working on category page

We have dropdown, which have an option to sort the products by position, name, etc., but its not working. Could anyone please help me?
0
votes
0answers
25 views

Magento 2 - How do i sort custom attribute in admin product listing gridpro

How could i sort product attribute in admin product listing? I couldn't find how they call the attribute in product_listing.xml . Drag and drop is not what i'm looking for. I want something ...
0
votes
1answer
157 views

Magento 2 - Custom sort order not working properly

I have created a custom plugin for sorting options for high to low & low to high price. High to low sort works fine but "low to high" sort order not showing correct results. app/code/Digital/...
0
votes
0answers
17 views

Sort Customizable Options values in backend

I want to sort option values alphabetically. I already did in frontend now i want same in backend - see image, please I know this can be done manually but I have a large number of products and ...
0
votes
1answer
242 views

Use join table to display data in admin grid column

How can I use join table to display second table data in admin grid? Admin grid is created using layout & block in proper manner. I used this link (how to create a grid without using ui component ...
1
vote
0answers
18 views

How to remove default options from sort order list?

How can I remove default options from de sort by list? For example, see the image? Is it possible to remove Best Sellers from the list?
0
votes
0answers
383 views

magento 2.3.1 - How to sort product name, price in ascending order in search result page?

Below is my search result page sort by product name in result page. Products are sorting by name by Z to A. I want to show the products in A-Z order when user click Product Name sort By option.How ...
0
votes
0answers
62 views

How sort by option working in category page and search result page in magento 2?

In My category page sort by option if i click Product Name products are sorting A-Z, In Search Page if i click Product Name products are sorting Z-A. Is there any setting to do to sort the products A-...
0
votes
0answers
39 views

Magento 2 - double ordering in category page

Some products have custom attribute blue_widget. On category pages, I want to list all blue_widget poducts that belong to that category first, and then the rest of the products. However, I want to ...
0
votes
0answers
26 views

Grouped product sorting issue when tier price in associated product

I have grouped product listing but it showing wrong sorting based on price. Associated product has tier price so based on it showing wrong on listing. Screenshot
1
vote
0answers
39 views

The image is not assigning to the correct attribute option after sorting when use visual swatch- Magento 2.3.1

Summary of Issue: I am looking to sort the color attribute options programmatically with input type 'Visual Swatch'. I have made customization in below files to sort the attribute options: File 1:...
0
votes
0answers
30 views

Magento2.1.9 - Catalogsearch pagination not work

When I'm searching by product name via mini search / advance search but the issue is toolbar.phtml not loading. I added block in catalogsearch_result_index.xml but not loading.
0
votes
0answers
202 views

Magento 2 REST API: Sort using custom attribute

I have created a custom product attribute best_seller and I want to use it for sorting API response. I am using the following API: V1/products?searchCriteria[filter_groups][0][filters][0][field]=...
0
votes
0answers
72 views

Magento2.3.0 How to brand filter sorting left side layer navigation

I am using Magento2.3.0 i need to brand filter sorting for left side layer navigation. I attached image for layered navigation to clearly understand, where am i need.
0
votes
0answers
25 views

Magento2.3.0 How to attribute for brand layered navigation automatically A-Z

I need in programatically set brand attribute layered navigation automatically A-Z. If anyone know please reply for specific category attribute option sort by ascending order. Thanks in advance.
0
votes
1answer
69 views

Sort product collection on stock status in magento2.3

I want to sort my list.phtml and catalogsearch by availability. Mean that when category page or search result page loads, first show "in stock" product and at the end show out of stock items. Don't ...
2
votes
0answers
20 views

Magento2.2.7 PLP sorting breaks after we place orders

Whenever we place an order on store front and come back to any category page, the sorting is not working(sorting breaks) . To fix this we needed to run a reindex on the below indexers and clear the ...
3
votes
2answers
259 views

Sorting by product ID

I'd like to add product id as a new sorting option in frontend catalog pages. How can I do that? This attribute is not listed in product attributes configuration in magento backend. I guess that it ...
0
votes
0answers
28 views

magento2 Sort is not working on PLP due to entity_id

We are working on Magento 2.2.7. On PLP, sort by price is not working. This is because in the query it first sorts the items by entity_id then only using the price field. Example query is given below ...
1
vote
1answer
118 views

Magento 2: How can change in the frontend sortOrder of Grand Totals and Tax positions in my account order detail page?

I need to change sort order in order_totals block in the frontend order view page. I want to swap the position of Grand Total & Tax in order_totals child items. Please help to change to order of ...
1
vote
1answer
236 views

How to sort by position field

This is my collection function: public function getCollection() { $searchCriteria = $this->searchCriteriaBuilder->addFilter('status', '1')->create(); $someCollection = $this->...
0
votes
0answers
29 views

Incorrect product sorting for numerical attributes (Magento 2.2.8)

I've got a shop with an attribute "capacity" created via Magento Backend: Shops -> Attribute -> Product It has "Text Field" as input type and "Decimal" as validation. So for new products therefore ...
0
votes
0answers
33 views

Magento 2 sorting duplicates

i have a problem with sorting products on magento2. When i sort by price or position some of the products gets duplicated. And it shows less products. For example if i have 20 products(10 per page) it ...
1
vote
1answer
269 views

Need help with ui component and change sorting order of columns in magento 2

Have listing but need to change view of one column: <column name="status"> <settings> <filter>text</filter> <label translate="true">...
1
vote
0answers
20 views

M2 - Previous & Next product from category

I have this code below to show the Previous & Next buttons on the product detail page, but the next en previous product are based on the position in the category. How can this be modified so the ...
1
vote
1answer
256 views

Magento 2 - Category page `addAttributeToSort` not working on custom product attribute

I used the following code for sorting on category page. if($this->getCurrentOrder() =="latest_products") { $collection->addAttributeToSort('significance', 'DESC')->getSelect()->...
11
votes
1answer
6k views

Magento 2 - Product sorting issue on category page using product attribute

I made product attribute and assign it on of attribute set so that it will show in the admin product detail page. Based on this product attribute I sort the product collection on category page. The ...
1
vote
1answer
367 views

Sort products in ascending order by name on specific category page not working

I want to sort product for a specific category by name in ascending order but it is still sorting in descending order in the front-end. For a category under Display Setting, I have set Default ...
1
vote
1answer
103 views

Magento 2 - Category page sorting does not work on grouped products

I added the new product sorting attribute related to price in category page like price low to high and price high to low. It showed on Sort By drop down. It is working fine for configurable product ...
1
vote
4answers
203 views

Categories are not in order same as in Admin panel Magento 2

I am listing children categories of specific category using below code: $categoryFactory = $this->_categoryFactory->create(); $category = $categoryFactory->loadByAttribute('url_key', 'shop');...
0
votes
1answer
349 views

Magento2 Catalog search result and product listing grid only sort by product name set

I need below condition to my website. Magento2 Catalog search result and product listing grid only sort by product name to be set. I have also back-end configuration done but issue is like product ...
0
votes
1answer
192 views

Grouped product (simple product sorting on price) Magento 2

In Magento 2.2 on the product view page is it possible to sort the simple products of a grouped product based on price (or any other attribute)? At the moment they seem to be sorting randomly. I ...
0
votes
0answers
16 views

Checked “Use Config Settings” for “Default Product Listing Sort By” for all categories

How to checked the checkbox "Use Config Settings" for "Default Product Listing Sort By" using script or sql ?
1
vote
0answers
78 views

Sort by Each Price Magento 2 via \Zend_DB_expr

I've had this working previously however seems to be causing me some difficulty now, basically i have a unit of sale attribute that I am using to get an each price from the sale price: if ($...
3
votes
0answers
30 views

Position not showing in category sorting dropdown

I have a problem with the sort order of products in the categories: The Position option is not showing in the dropdown as you can see in the screenshot. In the Magento backend the position is ...