Hello,
i want to programm a new Magento Module, that increases or decreases all product prices per Category (eg. increase 2 % or 0.15 € ).
Now i want to know how to select the category and which SQL-Table is neccessary for updating. Basically i want an overview over all Categorys and Products like the category table on the left side when clicking on category.
I want to choose the category i want to update and then all products in that category should get an update.
How can i display that table in my module and how should i update the products for that category?
Thank you
Chris