Developer forum

Forum » Ecommerce - Standard features » Currency rate per country

Currency rate per country

Nuno Aguiar
Reply

Hi,

 

We are bullding a website with 8 languages (1 per country) with multiple currencies.

 

Everything works great taking the rates into account, but they need the rate amount to be different per country. Here's what they have:

  • 4 languages that sell in Euro (country 
  • They need different rates for each language/country

 

How could we do that? Can we override the rate amount depending on the website context the page is being requested?

 

Best Regards,

Nuno Aguiar


Replies

 
Nicolai Høeg Pedersen
Reply

When you say rates, you mean price on the product?

The price matrix handles that. You can combine the prices with country (delivery country) or with shop or language. If you combine currency with shop in the matrix, you can have different prices in different countries/languages.

 
Nuno Aguiar
Reply

Hi Nicolai,

 

When I say rates, I mean the rate set on the currency (check attachment). I know we can do that on the price matrix, however the customer has +10.000 products and he is not wanting to do that.

 

I was thinking on having a "Rate 'override'" field on the website if I could somehow override Dynamicweb's method to consider it instead of the one set in the Currency.

 

The customer will still use the price matrix but only for some exception products, not all.

 

Is there someway we could do that?

 

Best Regards,

Nuno Aguiar

Currencies.JPG
 
Nicolai Høeg Pedersen
Reply

Hi Nuno

No, cannot do that. The key on currency is the CurrencyCode (EUR) combined with the LanguageID.

When you have the currency edit, you can shift languages, and you can change the name of the currency based on the language, but not the rate in the UI. You might be able to change the rate on the database for the language - but not 100 sure it works in the frontend/backend.

You could go for a general discount instead for some countries?

 
Nuno Aguiar
Reply

Hi Nicolai,

 

I can't use discounts. In this project we are usig Live Integration for both Discounts, Taxes and Shipping. If we add a DW discount and/or product price different than expected, it get's updated. They don't want live Prices, so we need to account for DW to show the prices from the DB in the product list and product detail pages (only the cart is fully controlled by the ERP)

 

This being said, I was afraid you would say that and it makes perfect sense. But because I need different prices on the product level based on the country, I will try the database approach though. Thanks.

 

If your suggestion does not work, the only thing I can think of is create a SQL procedure and/or a produce save notification that updates the price matrix for the product, creating the necessary prices. The customer would simply have to learn how to identify those.

 

Let me know if you remember anything else I can do.

 

Best Regards,

Nuno

 
Nicolai Høeg Pedersen
Reply

You can make your own priceprovider?

 
Nuno Aguiar
Reply

Hi Nicolai,

 

Maybe we can, but this statement in http://developer.dynamicweb.com/documentation/for-developers/ecommerce/extensibility/providers/price-providers.aspx is what would make it impossible

>> If no PriceProvider exists for a price, the system will fall back to the DefaultPriceProvider (Product Price Matrix)

 

We need to ensure the Price Matrix always takes precedence. We'll try to track it down. At least now I have a few more options to exploit. Thank you for your help.

 

Best Regards,

Nuno

 

You must be logged in to post in the forum