Geek asks and answers

Magento sales_flat_order_item table

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

price, base_price, original_price and base_original_price,

what's the difference between them?

+3
source share
1 answer

The name implies a relationship: original_price is where you started, price is where you end.

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

Screenshot of different values ​​in the fields

+3
source

More articles:


All Articles