The filter settings are stored in ui_bookmark table. It has the following columns:
You can delete the row ...
Here is an example module that will allow you specify a product collection for a customized product list element, which you should be able to adapt to your needs. It works by extending the ListProduct ...
I wanted to get the final_price for the product in /product/view/hero.phtml.
So that I could display the stickers based on the discount. Below is what worked for me after spending some time in Magento ...
As products and their logic are seperated from your design/theme, changing the theme is no problem and you will keep everything.
You will probably have to look out for specific functions or ways your ...
I would actually try to do it via SQL because in Magento, relations are done with foreign keys and ON DELETE CASCADE, so that you don't end up with dead data. However, before such an action, always ...