BO - totals are reported zero in Orders list

[hstpctech]

Hello,

 

I was transferring a small shop to a new host and domain.

 

Since the old prestashop was 1.6.0.9 and the new install is 1.6.0.14, I manually backup and restore each table to migrate the data. The old install has some modules that I want to leave behind, including their related tables.

 

So far I have managed to migrate the customers, orders, and payments. Products are manually imported from a .CSV, and images are FTPed.

 

The only apparent problem is in backoffice end - displaying the list of orders only give total amount of zero for each order. Attached is the screenshot of the Orders list. The amounts are shown properly in order detail view.

 

Listed are the tables I migrated. Clear up each table then import:

customer*

orders

order_carrier

order_detail

order_detail_tax

order_history

order_invoice

order_invoice_payment

order_payment

paypal_customer

paypal_order

 

Does anyone know if I missed a table or two?

 

sincerely,

Andy

 

p.s.:

 

extra checking shown in Customers list each customer lifetime purchase is displayed correctly. The problem only exists in Orders list.

 

Edited April 5, 2016 by hstpctech (see edit history)

[hstpctech]

p.s.:

 

extra checking shown in Customers list each customer lifetime purchase is displayed correctly. The problem only exists in Orders list.

[inovlancer]

Did you find any fix for this?

EDIT: I found the solution here: https://www.prestashop.com/forums/topic/591701-solved-bo-orders-page-total-column-shows-0/

Edited February 27, 2018 by inovlancer (see edit history)