I have a sales website and I want to add a system that:

Automatically checks product stock.

Applies promotions according to rules (2x1, quantity discounts).

My site is currently made in [PHP / MySQL].

I am looking for recommendations on:

Backend and frontend

Database and structure

Libraries or frameworks that make this easier

Thank you for your advice.