Magento

Questions tagged [filter]

Ask Question

Denotes questions about filtering in Magento (layered navigation, collection filtering)

757 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
27 views

filterUrlParams property not generating ajax url param on admin grid

i m struggling with an issue on Magento 2.4.5 creating a custom module on admin. I have created a 2 column ui with a form and listing, which renders a grid on the admin, however, no matter what i have ...
nikolas
  • 101
0 votes
0 answers
27 views

Magento 2 : Apply filter layered navigation in REST API

In frontend side, layer filter apply because of this below code. But, how can i use this below line into rest api as well? Is it possible to get $this->getRequest() object into rest api? Below code ...
Rohan Hapani
  • 17.1k
0 votes
1 answer
42 views

I need filter products by discount percentage in layared navigation (category page)

I have applied several price cart rules, I would like to see those frontend rules that work as a filter for discounted products. Someone can help me?
Gennaro Luca Scognamiglio
  • 13
0 votes
0 answers
45 views

Magento 2.4.3 - Layered Navigation - Categories

How can I go about setting up my layered navigation and category tree so the displayed products can be filtered by which child category they are in? I currently have every category in my tree is set ...
A. Andersen
  • 29
0 votes
0 answers
40 views

Filter products on the wish list page

could any of you give me some advice on how I can move/replace or just create product filtering on the wish list page? Is this at all feasible to do? Anyone seen or done something similar? Maybe there ...
meracle3
  • 13
0 votes
0 answers
16 views

how show one product with different color in product details page but every color has different url depend on color value

i saw example and i want make like that https://www.zalando.sk/nike-sportswear-club-pant-teplaky-active-pink-ni122e0d8-j11.html
Salah Mustafa
  • 1
0 votes
0 answers
35 views

Remove Category_id attribute from the filterable product attributes GraphQl

Remove the category_id attribute from the filterable product attributes GraphQl Native app development using Apolo APIs and that API adds category_id attribute with null value as a filter and the ...
Knight017
  • 602
0 votes
1 answer
124 views

Magento 2.4 admin grid add select filter with search

Good afternoon community, does anyone by chance know how I can add a select type filter to an adminhtml table grid and that additional internally include a search to filter options? As you can see in ...
Stiven Gallardo
  • 21
0 votes
0 answers
66 views

How to replace default filter of a specific field by custom filter in admin grid of custom table . Still keep pagingnation, other filter

In Admin grid filter type select.By default Magento, it will add this string to SQL query Where main_table.my_field = 'my-value'. Now I want it will be Where FIND_IN_SET('my-value',main_table.my_field)...
Phạm Hòa
  • 11
0 votes
0 answers
15 views

How to make query sort by number not by alphabet in admin grid filter?

In my custom_table have custom_field (type varchar)- but I only insert the number on that field. My problem is when I filter custom_field by range in the admin grid, the query is select `main_table`.* ...
Phạm Hòa
  • 11
0 votes
0 answers
112 views

How to filter products by multiselect attribute in GraphQL request?

So, I have a custom product attribute: $eavSetup->addAttribute('catalog_product', 'visible_in_country', [ 'type' => 'varchar', 'backend_type' => 'text', 'backend_model' => \...
Vasyl Malanka
  • 31
2 votes
2 answers
61 views

what this means 'neq' in magento2

can someone explain for me the this attribute used in array? $order = $this->createObject(Order::class) ->getCollection() ->addFieldToFilter('...
Bayzel
  • 167
1 vote
1 answer
69 views

How to Filter a collection with specific date range in Magento2

How to filter a collection with specific column name from and to in Magento2? For example: $fromdate = 2022-10-23 00:00:00; $todate = 2022-10-25 00:00:00 $collection = $this->...
Alshihab
  • 131
1 vote
0 answers
28 views

Filters don't hide out-of-stock products

I have a couple of custom filters, size and warehouse availability. When I select for example, size "XS" and "Warehouse1" I still see the product in the catalog that has size XS in ...
Захар Joe
  • 151
1 vote
5 answers
676 views

Magento 2.4.5-p1 not filtering products

Since i updated my instance from 2.3 to 2.4.5-p1 somehow my shop is not filtering products anymore in the category list pages. I tried to debug it and these steps are already taken: Flushed cache (...
Dirkos
  • 41
1 vote
0 answers
46 views

Magento 2.4: Change price filter text and range programmatically

I want to change the price filter text and range on the layered navigation from: To: Something like this: Under $30.00 $30.00 - $60.00 $60.00 - $90.00 $90.00 - $120.00 $120.00 and Above How can it ...
mechanic
  • 330
1 vote
0 answers
20 views

How to unset layered navigation block if theres not filters inside layered navigation

How can I unset sidebar.main container if there's no layered navigation the layered search result page navigation if there's no filters catalogsearch_result_index.xml
Anass Hl
  • 81
0 votes
1 answer
17 views

Search and filter redirecting to 404 page in Custom Product grid in custom module admin form in Magento 2?

I have created a custom product grid in my custom module form successfully Like below. Existing products are showing fine which i saved. When i want to try search for another product i am ...
Mujahidh
  • 2,651
1 vote
2 answers
12 views

Adding FilterGroupBuilder to customs template creates error message

im trying to add and OR Filter to my template. So i added filtergroupbuilder to the construct. As soons as i add the lines im getting the following error message __construct(): Argument #8 ($...
Uerke
  • 11
1 vote
1 answer
165 views

How to apply filter on magento 2 collection like below query?

THis is my core Mysql query select * from table_name where CONCAT(',', subscriptions, ',') like '%,4793,%' and i want to apply below filter on magento 2 collection. where CONCAT(',', subscriptions, '...
SURENDER SINGH
  • 173
1 vote
2 answers
71 views

How can I get the a selected option of Admin->configuration->Sales->Deliver Methods->flatrate-> field id? I need to inject this into a class

I will be injecting this into a ViewModel or Plugin. I have a custom configurable field in the Admin->configuration->Sales->Deliver Methods->flatrate and I need to check the value of it to ...
Justin Collins
  • 178
0 votes
0 answers
53 views

Magento 2.4.3 how to show size filter to show in stock child product

We are using magento 2.4.3 We have enabled inbuilt displaying out of stock product as enabled We want to show Product details page hence we have enabled it. But on collection page, when we apply size ...
Alwira Sheikh
  • 1
0 votes
1 answer
38 views

Rename Shop by and clear all text in left side Magento2

I want to change the text SHOP BY and clear all from left sidebar in list page
kiran
  • 475
0 votes
0 answers
82 views

Magento 2.4.4 admin grid filter & search not showing

Just updated from Mage2.4.3-p1 to Mage2.4.4 and on the admin/catalog/product and admin/sales/orders page the filter/search area is not visible anymore. It seems still functional, as the old filter ...
vandijkstef
  • 53
0 votes
0 answers
41 views

Select multiple options in a single attribute in catalog

Not sure if I'm doing something wrong or if it's by design, or if it's a theme. I've added a custom option (size) and enabled it for catalog pages, it does display as a filter on the left. However I ...
Захар Joe
  • 151
0 votes
0 answers
35 views

How do I add a custom filter to layered navigation?

I need to add a new filter to this menu Filter items should be active categories that are not in the menu. I plan to get them this way: public function getCategoryCollection() { $...
user105720
  • 1
0 votes
0 answers
220 views

Magento 2 Graphql: custom filter products not working

I want to add a custom filter (Stock status filter) to products like this one but it's not working. How to filter product collection with default graphql products query in Magento 2 I used XDebug to ...
Mahdi Alikhani
  • 13
1 vote
2 answers
345 views

Magento 2 : Create a JOIN

I am trying to display a report which GROUP BY : SKU and Subsidiary. So instead of displaying each RMA in different rows, I am trying to display Filtered Report, Group by SKU and 2nd group by ...
Devhs
  • 50
1 vote
3 answers
657 views

Filter admin order by store id magento 2

I'm trying to filter orders by store instead of store view. I have 2 stores, each has 2 store views. I wanted to filter order with store. I declared a collection in di.xml <type name="Magento\...
Janani Kumar
  • 73
0 votes
2 answers
727 views

Some Filters not showing on some Categories in Magento 2.4

Some Filters not showing on some Categories in Magento 2.4 As you can see in two images both are diffrent categories but Newest filter not showing in second image. In some categories it just show ...
Prits
  • 586
0 votes
0 answers
22 views

Add Filter grid into existing newsletter table that not containing ui_component folder

can anyone help me please? its the original file newsletter module after installing magento2.4.3 i have tried a lot online ways buttheir was just add a column only.
user104749
  • 1
0 votes
1 answer
289 views

Magento 2.3: Add stock status filter in product admin grid

I want to add stock status dropdwon filter in product admin grid like this: I tried this: https://magecomp.com/blog/how-to-add-stock-status-column-in-admin-product-grid-magento-2/ but it didnt work.
mechanic
  • 330
0 votes
1 answer
70 views

How to change filter "and" to "or"?

version : Magento 2.4 safira I want my website show every products related to filters I choose. If I choose multi filters, I only got products fulfilled all conditions. Is there any way I can edit ...
Ryung Kim
  • 3
0 votes
0 answers
39 views

Stock sources as filters layered navigation

I'm quite new to Magento2 so correct me if there is anything unclear or impossible to do. We have different stock sources (stock for Europe and for the UKs). I would like our customers to be able to ...
Pierre
  • 1
0 votes
2 answers
106 views

Magento 2.4 FilterSearch Custom admin grid

I'm trying to modify the admin grid's "filterSearch" field from default query if I type a whole word eg "Iphone", I'm trying to change the type search criteria in SQL to LIKE %ipho%...
Stiven Gallardo
  • 21
0 votes
0 answers
285 views

Magento 2 Add Custom date filter in UI Grid

I have created a custom grid for my custom table. It has a created_at column. Now I want to filter the entries by 7 days, 30 days, 90 days. ie, a dropdown with options 7days, 30 days, 90 days. How do ...
Jancy Abraham
  • 2,643
0 votes
1 answer
46 views

How to make custom customer attribute filterable in the customer grid?

I've made a patch and this is the code for creating my customer custom attribute: public function apply() { $this->moduleDataSetup->getConnection()->startSetup(); /** @var ...
Attila Naghi
  • 3,736
0 votes
1 answer
50 views

Magento2 product distance sort and filter

I need a custom extension for Magento2 - sort and filter product distance with map. Its extension for m1 i needed to m2 I try converter code m1 to m2 but - but lack of knowledge ( Please help anybody, ...
Amadine
  • 1
0 votes
1 answer
436 views

Magento 2 Admin Orders Date show not actual result

I have Magento 2.4.2-p1 EE. When i filter orders by dates, example: Purchase Date: 12/12/2021 - 12/12/2021 I have result with 777 found orders. But on last page i can see orders with wrong dates for ...
David Young
  • 115
0 votes
2 answers
601 views

How we can add category Filter to assign product grid

I want to add a category filter to the assigned product grid in Magento 2. Please help me out. Thanks in advance.
Magento
  • 1
0 votes
1 answer
527 views

Date range issue in sales order grid in Magento2

In the sales order admin grid when we select a date range in Filter option Magento backend Sales -> Orders, it is not sticking to that date, and showing other dates too in the filter... For example,...
Unknown
  • 561
0 votes
1 answer
77 views

Magento2 Add Custom Sort By Option ( Special Price Low - High)

I Want to Add New Sort By Option Like (Special Price From Low To High). Does any one know how i can do this ?
Sanjay Shiyal
  • 876
0 votes
1 answer
268 views

Get Latest Entry For Duplicate Rows In Collection

I currently have a logs table which has the following rows which use the same order_id: log_id order_id user action 2410 1001318004 test1 Declined 2409 1001318004 test1 Declined Inside my app/code/...
SNAFU
  • 176
1 vote
0 answers
301 views

Filter Grid with Comma Separated Values - Magento2

I'm working on a module where I need to filer store view which is stored as comma-separated values in a custom table. I tried solutions mentioned in Magento 2 -Admin Grid Select filter with comma ...
Nithin
  • 13
0 votes
1 answer
39 views

Custom Sort options for Catalog Dropdown

I created: di.xml on app/code/Filter/Sorting/etc <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="...
Lerry
  • 69
0 votes
0 answers
98 views

Magento 2 shop by price is not showing on sub category pages

Magento 2.3.5-p2 shop by price is not showing on the subcategory page, it is showing on category pages
sumeet bajaj
  • 1,185
0 votes
1 answer
191 views

Only display products with stock when filter is selected

guys so recently I noticed that when I select a filter, for example, the size M some of the products even though they have the size M some of them are out of stock and I was wondering if it's possible ...
DeadSec
  • 157
0 votes
1 answer
630 views

How to add Text Input Filter to custom module (hidden column)

I am trying to add a custom filter to a custom module in admin grid, however I do not want that column to be shown therefore I have tried both ways by adding a column and making visible field to false ...
nix
  • 107
1 vote
1 answer
547 views

Admin Grid is Showing Wrong filter count Magento 2.4.2

I had updated the magento version 2.3.5 to 2.4.2, in the admin when i tried to search the configurable product alone it shows the wrong product count.
Sabareesh
  • 318
-1 votes
1 answer
255 views

I want filter for Most Viewed Products in Magento 2 in Category Page

I want to make a custom filter for Most Viewed Product on Category Page in Magento 2. I have used this code app/code/Hlcategory/Filter/Plugin/Catalog/Block/Toolbar.php public function ...
Prits
  • 586

1
2 3 4 5
…
16

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.