I have a personal project I’m planning and I came to a small hurdle.
I want to have an item with a price that will be the default for all
clients/users. However, in my business I have some clients that are
grandfathered in to some special pricing. In the case of these
grandfathered in cases, I’ll manually plug their special price in my
admin section. Then all they will see is their special pricing while the
regular users/clients see the default price.
My current thoughts are to have a separate table called custom_pricing
with fields product_id, client_id, price and then tap into that. The
product table would have product_id and price.
What is the best and simplest way to design and implement this?