Promotional Pricing

[kpm121]

Hi,

I am looking for a way to change the pricing on products if a promotional code is entered. I will be sending out an email and I would like to have instructions on the email, "to get these special prices enter code xxxx". I tried the discount coupon contribution but this does not seem to be what I am looking for. The discount coupon contributions I have found only gives a fixed discount or percentage discount to the order total not by specific product. I would like to store the products, promotional price and coupon codes in a table and query this table to get the promotional pricing. Does anyone know how I could go about doing this or if anything is available that would handle promotional pricing in this way? Thank you.

 

Kris