I am building a web price updates page for an e-commerce website, and would like to create a form where I can update products within the product group selected(via a drop down menu), by any percentage that is input by the user. There are 200 different product groups all containing a list of products that are stored within a database that is already connected to the webpage and displays a list of products, web price etc. I would like to be able to select a particular group from the drop down menu, then apply the percentage increase, that the user has input into the form, to the group of products selected.
Hope this makes sense any help would be greatly appreciated.