ERROR: Price specification not found for currency:

[Jarkko Muhonen]

I updated PrestaShop from 1.6.20 to 1.7.7.2. 

After Migration everything else works fine but I can't open orders because of error in the subject (more specific error in attachment).

Can somebody help me? I have tried to find answer but couldn't find the reason.

[Jarkko Muhonen]

I found the reason. id_currency was 0 in every order. I updated it and it works now.

[corrigerunbug]

Yes, i was having exaclty same issue due migration using Migration Pro and it was solved by changing id_currency from 0 to right ID of currency.

[Ali Samie]

I love you man. you helped me and my friend a lot. i hope to see you in heaven.

Edited July 22, 2022 by stifler97 (see edit history)

[corrigerunbug]

Great

[PPSA]

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';

Edited December 26, 2024 by PPSA (see edit history)

[hokat]

Same problem here on PS 1.7.7.3 with the Classic theme. I have found past orders in ps_orders and ps_order_payment with id_currency = 0.
I updated id_currency to the single currency existting in the shop: id = 1.

Not solved.

In backoffice the orders listing, for those orders only, returns http500.
I have 988 orders and only 31 (the very first orders from 2016 - 2018 period) of them had id_currency = 0. In the backoffice listing of orders, with a setting of showing 20 orders on page, every page loads but the last one and the one before.

[ecentury]

Thank you for posting solution.

Worked for me. Strange that this error only showed a year afer migration, but seems good now.

[Nicolas Unic-3D]

Hello guys.

Could you help me? Im having exactly the same issue.  The ID is "2" here.

Should I dare to open a PHP file to insert data somewhere?

Thanks for your help.

I'm stuck.

[PPSA]

Have you checked what data is in the Database in tables ps_orders and ps_order_payment under the id_currency column/field

[Nicolas Unic-3D]

Hi PPSA,

Thanks for your reply.

Only number 2. So I don't understand what's happening.

Any other idea?

The problem happened when I was updating the status of my orders. I modified quite a lot in a short period of time. And suddenly impossible to access my list of orders.

Weird.

[PPSA]

So from what I have experienced, is that the entire orders list is queried even though it only displays 20,30,50,100 of your choosing.
So you need to go back to the tables ps_orders and ps_order_payment and sort by the id_currency column/field to make sure there is no other values there besides the value "2"
If there is just one pre-existing order with another value that does not tie up to the ps_currency table "2" then it will throw the error you are experiencing.

[Nicolas Unic-3D]

I was doing the modifications in the wrong database 🤪

I've done what you told me in the good one and everything works fine now. Yiiiiiiiihaaaaaaaaaaaaaaaaaa !!!

Thanks a lot for your help man.

You ROCK !