Changing the main currency

[cpuin]

Hi,

I'm from Bulgaria.From 01.01.2026 we're going to accept EURO as a main currency in the country.

Now I use only BGN as currency.

My question, which is the easiest and proper way to change the main currency?

What I thing is that I have to enable second currency, the EUR. Is it going to calculate automatically the prices?

Thank I'd like to disable BGN and the main currency to be EUR.

Please, advice!

I have two sites PS 8.1 and 1.7.6

Thank you in advance

Edited November 19, 2025 by cpuin (see edit history)

[El Patron]

The short answer: yes, you can change your shop’s default currency from BGN to EUR. PrestaShop supports this, but there are a few things you need to understand before switching.

Recommended method

1. Add EUR as a new currency.
2. Set the correct conversion rate between BGN and EUR. PrestaShop will calculate prices automatically based on that rate.
3. Set EUR as the default shop currency.
4. Check product prices, shipping rules, and payment methods.
5. After confirming everything works, disable BGN.

This is the safest approach on both PS 8.1 and PS 1.7.6.

Cons and things to watch out for

• Product prices will be recalculated using the conversion rate. If rounding is not ideal, you may need to adjust individual prices.
• Old orders will remain in BGN. This is normal because PrestaShop stores the original order currency.
• Payment modules may need to be reconfigured or re-saved so they recognize EUR as the new default currency.
• Some carrier rules or free-shipping limits may have been set in BGN. Review these after switching.
• A few themes or custom modules might have hard-coded currency symbols that you need to update manually.

[cpuin]

Many thanks!

[cpuin]

On 11/20/2025 at 1:01 AM, El Patron said:

The short answer: yes, you can change your shop’s default currency from BGN to EUR. PrestaShop supports this, but there are a few things you need to understand before switching.

Recommended method

1. Add EUR as a new currency.
2. Set the correct conversion rate between BGN and EUR. PrestaShop will calculate prices automatically based on that rate.
3. Set EUR as the default shop currency.
4. Check product prices, shipping rules, and payment methods.
5. After confirming everything works, disable BGN.

This is the safest approach on both PS 8.1 and PS 1.7.6.

Cons and things to watch out for

• Product prices will be recalculated using the conversion rate. If rounding is not ideal, you may need to adjust individual prices.
• Old orders will remain in BGN. This is normal because PrestaShop stores the original order currency.
• Payment modules may need to be reconfigured or re-saved so they recognize EUR as the new default currency.
• Some carrier rules or free-shipping limits may have been set in BGN. Review these after switching.
• A few themes or custom modules might have hard-coded currency symbols that you need to update manually.

I just have followed your instruction.After adding EUR everything was OK.But when I changed the default currency I got a warning that probably I have to change each price manually.I confirmed, and unfortunately it was like this.Now the prices are the same they were in BGN, but with EUR sign.

[El Patron]

2 hours ago, cpuin said:

I got a warning that probably I have to change each price manually.I confirmed, and unfortunately it was like this.

Yes, you will need to change the prices to reflect EURO as the warning informed you.

[cpuin]

On 12/29/2025 at 3:50 PM, El Patron said:

Yes, you will need to change the prices to reflect EURO as the warning informed you.

Meaning, this conversion ratio doesn't help me at all? If so, I understand.

Can you advice with the correct database query for divide to 1.95583 and round to second symbol after the comma, I want to change all prices.

Thank you a lot in advance!

[El Patron]

On 12/30/2025 at 4:08 PM, cpuin said:

Meaning, this conversion ratio doesn't help me at all? If so, I understand.

Can you advice with the correct database query for divide to 1.95583 and round to second symbol after the comma, I want to change all prices.

Thank you a lot in advance!

Generic SQL: convert BGN → EUR (simple products)

Assumptions

• Prices were originally entered in BGN
• Default currency is now EUR
• Table prefix is ps_ (change if different)
• Conversion rate: 1 EUR = 1.95583 BGN
• Rounded to 2 decimals

-- Convert base product prices from BGN to EUR
UPDATE ps_product
SET
  price = ROUND(price / 1.95583, 2),
  wholesale_price = ROUND(wholesale_price / 1.95583, 2);

-- Convert shop-scoped prices (used even in single-shop installs)
UPDATE ps_product_shop
SET
  price = ROUND(price / 1.95583, 2),
  wholesale_price = ROUND(wholesale_price / 1.95583, 2);

⚠️ Important
This SQL only updates simple product base prices.

If you use any of the following, additional SQL statements are required because prices are stored in other tables:

• Product combinations / attributes (size, color, etc.)
• Specific prices (sales, discounts)
• Cart rules / vouchers with fixed amounts
• Shipping prices stored in the database

• Make a full database backup first
• Test on staging if possible
• Put the shop in maintenance mode
• Do NOT modify historical orders

Edited January 2 by El Patron (see edit history)

[Miroslav Kolev]

На 29.12.2025 г. в 15:50, El Patron каза:

Да, ще трябва да промените цените, за да отразявате еврото, както ви информира предупреждението.

Здравейте, Дали намерихте решение на проблема. Аз също имам 3 магазина единия който е без опции се конвертира. но тези с опциите не помръдват. не знам как да се справя.

[ivenkov]

On 1/5/2026 at 7:53 AM, Miroslav Kolev said:

Здравейте, Дали намерихте решение на проблема. Аз също имам 3 магазина единия който е без опции се конвертира. но тези с опциите не помръдват. не знам как да се справя.

Най-лесно е през CLI директно да промените цените, както е написал El Patron на 2 януари. Току що го направих и работи. Не забравяйте да направите backup преди промяната, за да можете да се върнете, ако има проблем.

[Miroslav Kolev]

това е несериозно аз имам и опциии-атребути

[El Patron]

On 1/2/2026 at 9:36 AM, El Patron said:

• Product combinations / attributes (size, color, etc.)
• Specific prices (sales, discounts)
• Cart rules / vouchers with fixed amounts
• Shipping prices stored in the database

 

35 minutes ago, Miroslav Kolev said:

this is frivolous, I also have options-attributes

as I mentioned above, you will need to make other changes, this should not be a surprise now.  It's best you open your own topic to get help rather than using others post.

[4presta]

Hi. One topic per recurring query is enough.  To change the default currency and correctly convert currencies, a small SQL query is enough. As already written. Don't know what to do? Write to me and I will make the changes for free.

RU: 

Привет! Одной темы достаточно для одного повторяющегося вопроса. Чтобы изменить валюту по умолчанию и корректно конвертировать валюты, достаточно небольшого SQL-запроса. Как уже написано. Не знаете, что делать? Напишите мне, и я внесу изменения бесплатно.

 

[cpuin]

Hi,

I have managed to change the currency successfully following these steps:

 

1. Add EUR as a new currency.

2. Set the correct conversion rate between BGN and EUR. PrestaShop will calculate prices automatically based on that rate. (optional, even if you don't do it when switch off BGN, the prices will remain the same w/out change )

3. Set EUR as the default shop currency.

4.Disable BGN.

You will see that after these steps, the prices will remain the same as they were, but in the new currency EUR.

5. Than you need to execute the following SQL queries:

-- Convert base product prices from BGN to EUR 

UPDATE ps_product
SET
  price = ROUND(price / 1.95583, 2),
  wholesale_price = ROUND(wholesale_price / 1.95583, 2);

Convert shop-scoped prices (used even in single-shop installs) 

UPDATE ps_product_shop
SET
  price = ROUND(price / 1.95583, 2),
  wholesale_price = ROUND(wholesale_price / 1.95583, 2);

Now, everything should be ok.

I realized that you need also to make two additional steps:

6. Change the prices of the transport!

7.  Payment methods -> Settings:

These were unchecked and I had to check them, because the currency was changed.

 

 

Edited 16 hours ago by cpuin (see edit history)