Hi, I'm just looking for some feedback and advice on a promotions system my client wants to add to her ecommerce website.
Ok so my products table will contain a price field (I was going to include a sale price field but maybe it's not required).
Basically the client what to create a promotion and say select a percentage discount and possibly apply it to all products or maybe by category. So I figured a promotions table that stores the percentage discount as a field, a category field for the category id and then 2 fields for start and end dates.
I guess on the front end pages there is a check to see if there is an active promotion running and then anywhere I am displaying product price I do a php calculation for the discounted price, I then store this as a session and use this session in all my ecart server behaviours. So I would need to do an IF statement to see if a discounted price exists then use that otherwise use the regular price in the ecart server behaviours?
What do you think of this? Is is straight forward enough, or do you think I am missing crucial logic that prevent my idea from working well on the website?