Order Totals Not Updating

[seanhsueh]

Hi there.

 

Thanks in advance for any help.

 

I've been attempting to make changes to orders by manually changing the information through phpmyadmin.

 

Let's say I'm viewing a past order in ACCOUNT_HISTORY_INFO.php. When i change PRODUCTS_QUANTITY in ORDERS_PRODUCTS, the total will change correctly for that individual line item. However, the SUB-TOTAL and TOTAL don't reflect the change.

 

I've tried making the changes in ORDERS_TOTALS but that doesn't seem to have an impact either.

 

Where is this information stored? Or is there a cache I need to clear? Perhaps a script that needs to be rerun?

 

Because I'm linking my oscommerce store with an offline system, I must be able to adjust orders, customers, etc. using only phpMyAdmin and SQL.

 

Thanks again for the help. I've included a screenshot of the issue in question.