Take the 2-minute tour ×

There are four price columns in magento 1.6 CE sales_flat_order_item table:

price, base_price, original_price and base_original_price, 

what the difference between them?

share|improve this question
and what about original_price column? –  Ris90 Apr 17 '12 at 11:30
think baby think :) original_price, discounted_price, special_price etc you name it :) the idea is the same base_original -> original –  Anton S Apr 17 '12 at 12:48
I cant find columns "discounted_price, special_price" in my sales_flat_order_item table, but when I do order on special priced product in four columns "price, base_price, original_price and base_original_price" I have same value, my special price. I understand this currency thing with base_ columns, but can't understand your comment about original_price column –  Ris90 Apr 18 '12 at 10:35

1 Answer 1

up vote 2 down vote accepted

The name does imply the relationship: original_price is where you started, price is where you end up.

If you edit the order on the backend to apply custom pricing, you will see the difference in this table. I have attached a screenshot to show where I adjust the last order that came in to have a lower price (444 vs 1750).

Screenshot of different values in the fields

share|improve this answer

Your Answer


