Where is Magento order data stored?

magento magento-1.6
robgt picture robgt · Nov 12, 2012 · Viewed 56k times · Source

I am running Magento 1.6.2 and have an intermittent error cropping up with some sales orders. The customer is being charged correctly, but the Magento admin page when viewing the sale reports incorrect values. I understand why it is doing it incorrectly - I have a 10% discount off a full section of products on my website, and it is because of this that something is going wrong.

Again, the customer is paying the correct (discounted) amount, but the data must be being stored incorrectly in the magento database because looking at it in the admin system doesn't total the values correctly. The Catalog Price Rule that applies the 10% discount is not accounted for in the displayed totals.

To add to my woes, we use Zynk to bring data in from Magento to our Sage 200 backoffice system, and the data getting imported into that system is also missing the 10% discount, making reconciliation of order payments and Sage invoices a complete pain.

The only thing I can think is that somewhere somehow the data is being stored in the magento database incorrectly (not having had the 10% discount applied to it) so when Zynk collects the data, it is incorrect.

Can anyone help me understand where I can find the order data in the Magento database so I can see what was stored for a specific Magento order number - I can at least begin to debug this then, maybe?

If someone has details of where to find the code used by Magento to perform the order database transactions, specifically where the discounts should be applied before storing the data, that would be a big help too.

Cheers!

Answer

Piotr picture Piotr · Nov 12, 2012

Orders data are saved in database tables sales_flat_order and sales_flat_order_item

Discounts are applied in Mage_SalesRule_Model_Validator

Related questions

Magento Indexes Issue - Can't reindex

I have a problem with index management inside my Magento 1.6.2.0 store. Basically I can't get them to update. The status says Processing but it says like that for over a 3 weeks now. And when I try to reindex I am …

Read More
Magento Exception Error: Invalid method Mage_Catalog_Block_Product_View_Type_Simple::displayProductStockStatus()

i tried to install a theme to my magento system and when i try to open a product page its shows me an error: Exception printing is disabled by default for security reasons. please help me the error: Invalid method …

Read More
Magento - get rule from coupon code

I have to retrieve the rule associated to a coupon code in order to display in quote the discount percentage of that rule. the simplest way is to calculate directly from quote amounts, but i want to retrieve directly the …

Read More