VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: stawebnice on January 12, 2021, 12:27:59 PM

Title: How to add prices to product in multiple currencies to override conversion?
Post by: stawebnice on January 12, 2021, 12:27:59 PM
Hi guys,

please has anyone solution to add prices to products in multiple currencies to avoid currency conversion?

I am trying this with Add price button but it does not save it right. It still prefers shop default currency, so when I have CZK and add price in EUR, it does this (see image)

They do not have system in prices that could use fixed EUR conversion rate, because every product has different price rounded to make it look nice...

In this example, the product should cost 35,59 EUR, but instead it shows 1,12 EUR on web...
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: GJC Web Design on January 12, 2021, 13:12:07 PM
pricesbyCurrency=1       //currency depended selected price; the selected currency determines the selected price of the product if availabe

have u set this in your config?
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: stawebnice on January 12, 2021, 16:49:09 PM
Hi,

nope, thanks!

I have just added it to administrator/components/com_virtuemart/virtuemart.cfg

to the first part under ##shop settings
but it did not change anything (I went to product and then saved the new price in EUR again), but still base price was not calculated correctly

does this belong to a different part of config file or where could be a problem, please?
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: GJC Web Design on January 12, 2021, 16:54:21 PM
Quotedoes this belong to a different part of config file

can go anywhere ..  remember u must also save the VM config after adding it
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: stawebnice on January 12, 2021, 17:00:02 PM
I did go to VM config and save it in the administrator, and have seen the message

Oznámení
Loaded virtuemart default configuration from file virtuemart.cfg

but still the same issue... base price is calculated wrong when I save it and check calculate the cost price checkbox...
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: GJC Web Design on January 12, 2021, 17:23:28 PM
very strange  -- although I use country specific Vat rules on our multi-currency sites
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: stawebnice on January 12, 2021, 17:57:47 PM
I think I got there now = you have the same issue - the base price number is very different from what base price should look like in that selected currency, but overall it shows the sales price right on front-end, so it is just confusing, but it works :)


Thank you!
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: stawebnice on January 12, 2021, 18:10:02 PM
hmm, looking at it now again it, it does not work

it shows base price in the same amount as sales price with VAT
even when I select showing different prices (sales prices without VAT), it shows

could you show me how you enter the price in other currency to make it calculate the right price without VAT, please?
because I usually enter sales price, check the checkbox calculate cost price and save
that works for default shop currency

do you show both price with and without VAT on your eshop in your multicurrency eshop?
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: stawebnice on January 12, 2021, 18:18:58 PM
hmm, I think I figured it out... the process of adding price in different currency is slightly different - you need to enter baseprice in eur (price excl. VAT) then select VAT and just save...
and overlook the fact that the sales price will show in eshop currency and not new currency (e.g. EUR)

and then setup showing prices on prices configuration tab like this>
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: stawebnice on January 13, 2021, 11:29:11 AM
Hm, there actually is a significant issue that I have just noticed  - after adding the price in EUR it overrides the price in CZK:

so, it should be showing the price 890 Kč for CZK, but instead it is showing 932 which was calculated automatically after adding EUR

what to do now?
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: Milbo on January 13, 2021, 14:45:18 PM
The price is always shown in the shop currency. Just do not select the 21% rule.

So lets assume the setting is pricesbyCurrency=0, then it does not make sense to have prices in different currencies. This is for importers. For example a swizz shop buys in Dollar but sells most time to the EU, then he can use an own USD with fixed rate (when he bought it) and sell it with dynamic rate of CHF to EUR.

pricesbyCurrency=1 says, try to use the given currency, if not use the normal shop currency.

So back to the swizz shop (I wrote it actually for a swizz shop). The swizz shop added always two prices, one in CHF, one in EUR. The EUR price is always calculated the normal way. That means that you see the 29 euro recalculated back in Cz Krones. and the price is higher, because it looks like that you entered the EUR price as Brutto.
The swizz shop just wanted "nice prices" in both currencies (the 29,90 for example and not 29,87)
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: Milbo on January 13, 2021, 21:22:57 PM
Quote from: GJC Web Design on January 12, 2021, 13:12:07 PM
pricesbyCurrency=1       //currency depended selected price; the selected currency determines the selected price of the product if availabe

have u set this in your config?

This is now a normal configuration setting in "Pricing".
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: stawebnice on January 14, 2021, 09:55:51 AM
OK - for those who do not understand - you do not need to change this in virtuemart.cfg file anymore, because it is available on Pricing tab of Virtuemart configuration

but Max, when do you think could you fix the bug with overriding the default currency price after setting new price in e.g. EUR, please?
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: pinochico on January 14, 2021, 12:51:10 PM
Petro,

should the eshop not have uniform prices == the price in Eur should be adequate in terms of CZK and if this is not contrary to any EU regulation == it is not possible to sell the same product in CZ for 10 EUR and in FR for 20 EUR in one eshop?
Or why is it necessary to create additional prices for the product in other currencies?
I think we would have a problem with that, for example, when connecting to Pohoda.

If you only need to display more prices for one product from one basic price at a time, then just edit the sublayout price.php template and leave one price in the administration.
If you need to change the price based on the defined country of the customer, this is done by the OPC or plugin based on the selected language.
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: stawebnice on January 18, 2021, 15:19:51 PM
Rudo,

I told them about all options and consequences - including the legal ones (since I am a lawyer myself), they want it anyway...

VirtueMart has feature for that, Max and others already use it on other eshops... so this is not something to discuss, please...
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: roman5527 on February 28, 2021, 13:54:42 PM
Hi, Did you solve the problem in any way? I am solving a similar problem with the Slovak - Czech e - shop. Currencies and invoices in € and CZK.

How to change the menu by country? Not on the basis of IP GEO but on the basis of the selected country manually.

well thank you
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: jankoo on October 25, 2022, 12:17:08 PM
did you solve this?
i have the same issue.. what is this mess? i dont understand this at all.
i have eshop in euro. now i want to add czech korun.
i added the currency in the store options. i added the vat calculation for czech.
i click on "add price" in product, and select czech koruns and after fill the price and save it save totally different price..
what is this mess? i want to setup my own price? why is this somehow calulated? and from where? how to disable this.
i tried to change "Prices by Currency" but it do the same..
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: jenkinhill on October 25, 2022, 15:49:36 PM
? Select "Prices by Currency" in Configuration / Pricing
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: jankoo on October 26, 2022, 09:44:03 AM
i have that "Prices by Currency" selected.
and after fill the price "300" i get selling price 1.02
???
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: jenkinhill on October 26, 2022, 17:13:39 PM
Are you correctly entering two prices/currencies for each product?

In the example below I have entered a British Pound cost price of £100 and a Euro price of €33 with no problem except that the currency symbols on the backend always display as the shop default, which here is £.

I also have different tax rates set for each currency for testing purposes.

This is using the test version, VirtueMart 4.0.8 10728 , which may soon be on public release. It also worked OK on older versions I have tested.

(https://i.ibb.co/TrYNt41/prices.png)
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: jankoo on November 11, 2022, 12:47:45 PM
hi. ok. i dont get this at all..

i have currencies enabled. added also to the shop options.

here i had € prices as main. now i added to one product polish zloty price as 125..
after save i get in admin 26.56 price?

and the another i dont get at all.. on the frontpage. after user change currency by module.
it show polish zloty prices on all products.. also on that ones i never setup.
and that one i setup there is also another different price 153,30..

it seems it somehow calculate the prices from somewhere.. but how? but why? how to disable this?

ps: i dont see any image you posted. there is only some blue image not found.
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: jankoo on November 11, 2022, 12:49:24 PM
it dint post my second attachment image from frontpage.. the prices from first images is here the first product with 153,30 price
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: jenkinhill on November 11, 2022, 16:07:24 PM
Hmm - for some reason imgbb deleted my image. Now replaced.

Your product price setup looks the same as mine. But on my site using the VMBeez3 template, with the VM Currencies Selector on the product or category page set to GBP the Pound price is displayed and when set to Euro the € price displays. Exactly as expected.
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: jankoo on November 11, 2022, 21:02:43 PM
ok. let me try to explain for the third time..

yes, our product price setup looks the same because is the same setting layout.. but my prices are doing what they want.

as you can see on the attachement image:

in EURO (blue prices) i put 33, it calculate final price 33, and it show on the page 33 euro price. this works as i would be expecting
but, in PLN (red prices) i put 125, it calculate final price 26.56 and it show on the page 155,30 PLN.. (after change the currency on frontent by user) WHY THA gentle? where are those prices comming from?

and how its possible it shows all other products prices in PLN when i never fill them?? (green price)

pls explain. is this working exactly as expected?
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: pinochico on November 11, 2022, 21:18:34 PM
and where is setup for shop - what is default currency?
and where is setup for currency (EUR, PLN)?

After this you can send question :)
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: jankoo on November 11, 2022, 21:24:21 PM
default currency for eshop is euro..
what setup for currency? there is no setup. i have only enabled euro and pln. 0.00000 exchange rates for both.
from where those crazy pln prices come from and why?
i just want to setup 125, and get 125
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: jankoo on November 12, 2022, 17:48:19 PM
so, no answer now
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: pinochico on November 13, 2022, 03:33:50 AM
Quoteso, no answer now

Im not there anytime, sorry.
I have a personal live, a girl, dogs, ...
Im not your personal developper

First, if you want any, then send all info and not waiting for my question.... Im not wizzard.

Quotewhat setup for currency? there is no setup.

There is setup. There is setup for Euro and for PLN and if you want any, then you have to send picture for this setup.
It is the first, when I go on customers shop.
But there I don't have admin login == you have to send self.
Or not - then I go away.


Quotefrom where those crazy pln prices come from and why?
i just want to setup 125, and get 125

Yes, when you have default currency PLN.
But your default is Euro and you use convertECB.php
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: jankoo on November 13, 2022, 10:30:42 AM
:D you guys... are sooo fukcing funny. acting like you dont understand :D this vm is epic piece of shit without documentation or tutorials..
so i cant setup my prices in different currencies :D only in one. and all others will be different for users every day based on some currency convert :D
what kind of epic idiot came up with this? pls. i wanna meet.. i wanna that kind of drugs as well :D

the only solution is destroy the content of convertECB.php
then no fukcing calcuations in my prices..

thanks for ZERO advices here. again
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: jenkinhill on November 13, 2022, 14:55:44 PM
You seem to have what we Brits call "attitude". Bad attitudes are not encouraging if you are asking for free advice from other VM users.

The currency prices work fine for me.  convertECB is never updated on my site, maybe because I have a single country set, I have only tested setting different currency pricing (and tax rates). I have no idea why you get different figures for PLN displayed on the products.
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: Jörgen on November 14, 2022, 15:23:32 PM
Afaik you can not have two prices for the same quantity interval ex 0 .. 0, if overlap, and I remember correctly, the lowest price wins.

Currency conversion is made through convertECB.php or fixed conversion rates in your currency table. F.e 4.00 for zloty and 1.00 for euro.

You can assign prices in both euro and zloty but the quantity interval may not overlap.

Please, keep your temper.

Jörgen @ Kreativ Fotografi
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: ee61ny on February 17, 2023, 14:21:11 PM
Hello, it seems I have exactly the same problem, is there any solution on this ? I am on Joomla 3.10.11, php 7.3, Virtuemart 4.0.6 10690.
I have 2 currencies , euro and Bulgarian leva and I have also enabled Prices by currency in price configuration.
I have set different currencies for each shoppergroup, now when I try to add a new price to a product, I add Final Price-Apply No Rules on both tax and discount and check Calculate the COstPrice, selecting euro as currency.
Normally, Cost Price should be the same as Final Price (since no tax or discount rules are applied), but instead, the final price is leva and Cost Price is in euro, how is this possible ?
I would appreciate any help on this,
Thanx in advance
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: pinochico on February 17, 2023, 15:06:41 PM
more picture pls:
- setup for eshop currency
- setup for currencies...
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: ee61ny on February 17, 2023, 15:43:30 PM
Hello, thanks for your answer, I attach eshop currency and setups for currencies. The problem is that final price is in leva and the cost price in euro, even if I select Euro when I assign a price for a different shoppergroup.
Thanks in advance
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: pinochico on February 17, 2023, 15:56:46 PM
f I'm not mistaken, that's standard behavior,
because the base currency is Leva and VM supports virtually multicurrency, but it still converts the end prices to the base currency of the e-shop == Leva

But maybe there is some setting somewhere in the hidden configuration (the .cfg file on the ftp) that disables this - try looking on the forums
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: ee61ny on February 17, 2023, 16:49:45 PM
Hi, thanx for your reply,
this happened when I upgraded from a previous VM3 version to the existing 4.0.6, till then there no issue with that. Even if it is the standard behaviour, how come final price is in leva whereas cost price is in euro ?
I haven't managed to find anything about the hidden configuration that disables this, the only topic close to my issue is this one.
Title: Re: How to add prices to product in multiple currencies to override conversion?
Post by: ee61ny on February 17, 2023, 22:52:47 PM
Hi pinochico, I really appreciate your help, I finally solved it, I found in another topic you mentioned "Better option is download noconverter.php from rupostel.com" .
Fortunately I already use OPC from rupostel, so by enabling noconverter prices are shown as should in backend, thanx once more.