Edit History

So I used a tool to migrate from opencart to PS ....alas, it's imported all orders in one currency, so I'm trying to clean up using an ODBC connection from MS access.

I've done some updates to an order (as a trial/test), in the main it worke (f9r example, prior to me doing the update, this particular order hwas showing a shipping cost of $0.00) - but when I view the customer order in the Back Office, even though the shipping charge is visible (& now correct), PS is not totalling the shipping cost to the cost of the item(s)?

See here for what I mean $24.27 + $7.95 (shipping ....which was $0.00 prior) = $24.28

Any ideas?

since I've changed some entries in the database, do I need to force PS to regenerate/recalculate the order details?  (& if so, how do I do that?!

So I used a tool to migrate from opencart to PS ....alas, it's imported all orders in one currency, so I'm trying to clean up using an ODBC connection from MS access.

I've done some updates to an order (as a trial/test), in the main it worked - but when I view the customer order in the Back Office, even though the shipping charge is visible, PS is not totalling it to the cost of the item?

See here for what I mean $24.27 + $7.95 (shipping) = $24.28

Any ideas?

since I've changed some entries in the database, do I need to force PS to regenerate/recalculate the order details?  (& if so, how do I do that?!

So I used a tool to migrate from opencart to PS ....alas, it's imported all orders in one currency, so I'm trying to clean up using an ODBC connection from MS access.

I've done some updates to an order (a sa test), but when I view the order int eh Back Office, even though the shipping charge is visible, PS is not totalling it to the cost of the item?

See here for what I mean $24.27 + $7.95 (shipping) = $24.28

Any ideas?