I have the Quantity discount up and running, where if you buy 3 or more products you received $1.00 off each product. The shopping cart shows this and then confirmation email displays the discounts and the credit card transaction shows that the discount has been applied.

When I go and look at the orders_products table the final_price field shows the the same price as the product_price. Shouldn't the final price for each product in an order reflect the discount?

Example:
What the orders_products table looks like for an order:

orders_id Product Price Final Price
1 $5.99 $5.99
1 $9.99 $9.99
1 $6.99 $6.99
2 $5.99 $5.99
2 $7.99 $7.99

What I thought I would find when I looked at the orders_products table:

orders_id Product Price Final Price
1 $5.99 $4.99
1 $9.99 $8.99
1 $6.99 $5.99
2 $5.99 $5.99
2 $7.99 $7.99