If a customer bought a product with special price (catalog price rule), the special price will be saved in sales_flat_order_item table. I wonder if the original price is also saved in this table? If so, in which database field it is saved in? I've looked through the whole table and I couldn't find where the original price is.

I found a column called Original Price. But it saves the special price as the original price.

  • you have found it if you have checked the same table – Piyush Jun 28 '17 at 10:23
  • Do you mind to tell me which column in this table the original price is saved in? I've look at each column by now. it display the same price (special price) in all columns. – Magento Learner Jun 28 '17 at 10:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.