Pricing Ideas

Please allow me to present my ideas on how pricing could be improved in the future. What I will not be going into is the coding side I welcome any and all comments :)

Firstly, the system we have now is quite basic to the point that it would be difficult to be more simple. The Sell Price on each product has been enough to get most people started, but when anything more is required things get complicated.

My idea to improve this is to provide a pricing layer on top of the existing one, which is always the first place to check for a valid price, price validity being something else I hope to address with this idea. If a valid price is not found at this first point the price at the product level is used instead.

The new pricing layer allows for more than one price against a single product, along with the following fields:

  • Quantity - should include a greater-than/less-than/equals modifier which will allow quantity-based pricing.
  • Validity
    • From date/time - if blank is considered from the beginning of time.
    • End date/time - if blank is considered until the end of time.

This will allow for much more flexibility in terms of pricing, even though ideally there would be yet another pricing layer on top of this allowing customer-specific product prices to be set but I understand that might be a little over-kill :)

Please let me know what your thoughts on this are.