Order Items Table - Edit Order Item

[niall08]

When thwe administrator edits the tax amount of an item that has been ordered, the entry in the ac_OrderItems table is not being updated.

Where is this edited value stored?

The gross figure is correct, but I need access to the edited order item prices..

[mazhar]

Did you checked I think if you save the order item after editing it should update the order item price in database. Make sure that after saving the order item you refreshed the table to view recent changes.

[niall08]

Hi Mazhar,
Yes, if you edit the product price and save it is updated in the ac_OrderItems table.
I see where I was making the error..

I was using the "TaxAmount" field rather than the separate record for the tax - and using a calculation from the ShipMatrixRate table for the shipping cost - neither of which changed, unlike the separate records for Tax and Shipping in the ac_OrderItems table.

Now, is this assumption correct - the OrderItemTypeId for a product is 0, for tax is 3, and for shipping is 1???

[mazhar]

yes you are right. Product = 0, Shipping = 1 ,Tax = 3

[niall08]

Thanks Mazhar - that's also made my SQL query ALOT lighter..