How to properly implement product pricing in Opencart?

Question

PHP

The product has additional fields "surcharge" and "discount".
Price=(Price*surcharge)-(Price*Discount).
The price is formed in the controller, but this is not correct, so now there are problems with filtering the goods.
How to implement it in the model?

Answer 1

It's not entirely clear what you mean. Do you have additional columns in the database or what?

Answer 2

Move the logic in the catalog_product model to the getProduct() method