Edit History

Yeah this was the same issue I had with the Migration Pro Module for past orders which seemed to not align with payment id's
The tables that need fixing is ps_cart, ps_orders and ps_order_payment under the id_currency column

From what I have found is that the PS1.7 and lower have the currency ID's starting from 0 and PS8 onwards the currency begins with ID 1
So to move the data forwards start from the highest number and work backwards to prevent an overlap in the instruction
Change Currency ID 2 to 3, then 1 to 2, then 0 to 1

SQL you can run to change the data is:
Update ps_orders
SET id_currency = '2'
Where id_currency = '1';

Update ps_order_payment
SET id_currency = '2'
Where id_currency = '1';

Update ps_cart
SET id_currency = '2'
Where id_currency = '1';

Yeah this was the same issue I had with the Migration Pro Module for past orders which seemed to not align with payment id's
The tables that need fixing is ps_orders and ps_order_payment under the id_currency column/field

From what I have found is that the PS1.7 and lower have the currency ID's starting from 0 and PS8 onwards the currency begins with ID 1
So to move the data forwards start from the highest number and work backwards to prevent an overlap in the instruction
Change Currency ID 2 to 3, then 1 to 2, then 0 to 1

SQL you can run to change the data is:
Update ps_orders
SET id_currency = '2'
Where id_currency = '1';

Update ps_order_payment
SET id_currency = '2'
Where id_currency = '1';