Magento 2: How to reset filters in product grid?
The filter settings are stored in ui_bookmark
table. It has the following columns:
bookmark_id
,user_id
,namespace
,identifier
,current
,title
,config
,created_at
,updated_at
You can delete the row with your user_id
, or just truncate that table.
Alternatively you can use https://github.com/magenizr/Magenizr_ResetUiBookmarks which does exactly the same what you have explained above. This module will add a reset button on the Account Settings page in the backend. Once you hit the Reset UI Bookmarks button, it will delete all records from ui_bookmark
based on the current user_id
.