Skip to main content

Questions tagged [filter]

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

Filter by
Sorted by
Tagged with
1 vote
1 answer
23 views

Apply custom product attribute filter directly in layered navigation

I have one text custom attribute for product. I want to apply directly in Category/Search page and also in Layered Navigation. I have tried by override Magento\Catalog\Model\Layer this file but by ...
Jigar Dhaduk's user avatar
0 votes
1 answer
18 views

Magento API Date filter

Is it possible to create a Date filter to fetch orders created only in last two days using API , without hard-coded values ? Something like this: http://<magento_host>/rest/V1/orders? ...
Magento_noob's user avatar
0 votes
0 answers
12 views

Magento 2 : Remove Magento backend Catalog Product search error? I need to search sku to edit listing in product catalog

Please help me, my magento backend has error in Catalog Products, I want to search SKU to edit listings. How to remove this error please? Thanks.
Arlene Decano's user avatar
0 votes
0 answers
32 views

How to add custom filter on category Page in Magento246

Magento246 how to add custom filter with options on category listing page. Like...https://prnt.sc/7ZtTc1kGqVJR
Keval Chauhan's user avatar
0 votes
0 answers
8 views

how to customise sorter.phtml in magento2?

i need to customise the magento2 component sorter.phtml so that it displays all available options in a list (instead of a select element) and each element in the list has its own asc and desc arrows. ...
media.queeries's user avatar
0 votes
1 answer
31 views

Issue with Data Provider date range filter

A custom column is populated when a date range filter from UI is applied. I noticed weird behavior. When I apply a date filter it works fine until I decide to apply the date range I filtered before. ...
Dramorian's user avatar
0 votes
0 answers
31 views

Magento2: How to add a filter for "is_in_stock" on category page layered navigation?

I tried the solution from Magento Stack Exchange, but it only works correctly for one page. If I have 24 products on my page, I can see a total of 24 products (both in stock and out of stock) through ...
Виктория Бойко's user avatar
0 votes
0 answers
26 views

Product page filter

(link to webshop) https://sanitairkamer.nl/mondiaz-aivy-badmeubel-120cm-chai-met-wastafel-solid-surface-urban-midden-1-kraangat-en-spiegelkast-sk77173.html I'd like to re-create the product page like ...
SanitairSuperShop Marketing's user avatar
0 votes
0 answers
20 views

Displaying Date with Timezone Abbreviation in grid But should not affect filter field date format

I'm currently working on a Magento 2.4.5 project and I'm facing an issue with the date column in the Admin Grid. I have a column named "created_at," and I want to display dates in a custom ...
M2 Dev's user avatar
  • 548
1 vote
1 answer
61 views

Magento2: Filtering the catalog by attribute does not accurately display configurable products

Catalog filtering by attribute not shows accurately products who are configurable, when one variant of this products have value matched to filter value, in the catalog are showing all variants of this ...
RatajX's user avatar
  • 11
2 votes
0 answers
42 views

Sorting custom columns from module that extends another module containing all the data (collections, data providers, etc.)

I have two custom columns in UI grid (let's call them subscribed_customers" and "unique_purchases") created in particular listings that retrieve value from the database with logic. ...
Dramorian's user avatar
0 votes
0 answers
19 views

Filter by updated_at - Magento 1.6

everyone. How's it going? I need help with a filter issue. It's not working as I expected. I'm trying to list orders from after 2023-12-06, but it's returning orders from 2019, 2020, 2021, etc. Can ...
Paulo Andrade's user avatar
0 votes
0 answers
25 views

Only one row data is showing repeteadly in magento admin custom extension after upgrade to 2.4.6

I have one custom extension named jes.It was working fine in 2.4.0 version.In adminhtml the data is showing repeatedly. Like if there are 8 rows of different id then in 8 rows same data is shown. When ...
Tisha Jhanwar's user avatar
0 votes
0 answers
10 views

Filter Product Grid Column Based on SQL calculation

I have a custom column within the Product Grid that states whether a product is In Stock or Out of Stock, based on whether or not the Salably Quantity is greater than zero. While I have managed to get ...
A. Andersen's user avatar
0 votes
0 answers
16 views

Add new filter in the Panel column of the Product Catalogue

I want to add a new search filter in the product admin panel, but I don't know where to enable this option, if anyone has any idea if this can be enabled per individual user or only the super admin ...
Erick Vernaza's user avatar
2 votes
1 answer
189 views

Change Active filter position Magento 2

I want to update the Active filter position from left side to right side just above the product listing. Please guide me how can i do that. Current Position: On left side Required Position: I want to ...
Sunny Rahevar's user avatar
4 votes
0 answers
311 views

How to group by elasticsearch results/Remove duplicate items from Elasticsearch results

I need to customize my elasticsearch query based on a custom attribute. I have a product attribute with code product_code, I have added this attribute to search and in elasticsearch results, the value ...
Jaimin Sutariya's user avatar
1 vote
1 answer
75 views

Filter adjustment

I have a Porto theme and I would like to adjust filter a little bit. Is there an easy way with some settings, or I should do it completely bespoke? In following picture you will find what I would like ...
XraySensei's user avatar
0 votes
1 answer
46 views

Magento 2 : Make custom grid table appear only data that have been filtered

I have a custom module created to show list of backorder product, the list appear like this as you can see on the grid table above under the column payment status there is 2 type of status which is ...
Mohd Farhan Bin Ramli's user avatar
0 votes
0 answers
26 views

How to add category filter in using $fieldset->addField without component?

I want to know about the way of adding category chooser using $fieldset->addField. What should I do? I try as follows. Magento 2 Add category chooser without UI component but error is occurred as ...
Malcom's user avatar
  • 11
0 votes
3 answers
487 views

Magento 2.4.6 building custom admin grid filter issue

I built my own custom admin grid. It renders the data correctly, however when I tried to filter on an input, I am receiving the following error from the ajax request: Status code 500 Error: TypeError:...
Attila Naghi's user avatar
  • 4,033
0 votes
1 answer
176 views

How to hide layered navigation filter if all products in category have the same value?

Imagine having a category with 10 products, all having the same weight of 2 lbs. Weight filter will still show in layered navigation as: Weight 2 lbs (10) How to remove such attributes from layered ...
vladPavlov's user avatar
2 votes
1 answer
181 views

Mgento Admin Grid Multi select "," seperated value filter not working in custom grid Magento 2?

I create custom grid that include Website field and customer group fields are multiselect. At Filter apply also need to set as multiselect that not working for me. here I share my listing xml file ...
Jay Parmar's user avatar
0 votes
1 answer
33 views

Product attribute in Model

I have an attribute product that is a multiple select. I need to fill it with many operation options to select from, like a thousand or more. Is there the possibility to put this multiple selection in ...
Camilo Torres's user avatar
0 votes
1 answer
245 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's user avatar
  • 101
0 votes
1 answer
120 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's user avatar
  • 17.5k
0 votes
1 answer
253 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?
GerranoMargeno's user avatar
0 votes
1 answer
546 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 ...
GStiven's user avatar
  • 41
2 votes
2 answers
482 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's user avatar
  • 187
2 votes
1 answer
174 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's user avatar
  • 161
2 votes
0 answers
52 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's user avatar
2 votes
4 answers
2k 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's user avatar
  • 51
1 vote
0 answers
91 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's user avatar
  • 440
2 votes
0 answers
50 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's user avatar
1 vote
1 answer
109 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's user avatar
  • 2,813
2 votes
2 answers
17 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's user avatar
  • 21
2 votes
1 answer
311 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's user avatar
2 votes
2 answers
117 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's user avatar
0 votes
1 answer
96 views

Rename Shop by and clear all text in left side Magento2

I want to change the text SHOP BY and clear all from the left sidebar in the list page, Below is the screenshot
kiran's user avatar
  • 597
0 votes
0 answers
68 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's user avatar
0 votes
2 answers
660 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 ...
user avatar
1 vote
3 answers
1k 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's user avatar
0 votes
2 answers
1k 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's user avatar
  • 625
0 votes
1 answer
544 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's user avatar
  • 440
0 votes
1 answer
116 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's user avatar
0 votes
2 answers
354 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%...
GStiven's user avatar
  • 41
1 vote
0 answers
556 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's user avatar
0 votes
2 answers
693 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's user avatar
  • 4,033
0 votes
1 answer
92 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's user avatar
0 votes
1 answer
740 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's user avatar

1
2 3 4 5
16