This project is read-only.
104
Vote

Ability to assign catalog price per currency

description

And contribution: http://www.nopcommerce.com/boards/t/38848/nopcommerce-380-roadmap-and-estimated-release-date-lets-discuss.aspx?p=3#158021


At the moment prices in currencies that are different to the base currency are displayed as a direct conversion of the base price using the downloaded exchange rates. Some stores don't really work in that way as they need to be able to place themselves correctly in a foreign currency market depending on the country. I.e. for customers in Chile the price should be less than the price for customers in the UK, where standard of living is higher. This of course will need to have proper controls on the checkout to only allow purchases for customers in certain countries with certain currencies.

How it'll be done:
  1. There will be a radiobutton on the product details page (admin area): "Auto convert to other currencies during order processing" and "Set price manually per currency". When the second option is selected, then a store owner will be able to enter prices for all available currencies
  2. Should we do it for tier prices, attribute (product/checkout) price adjustments, special prices, discounts, etc?
Maybe, we should create a new table (general) for storing prices similar to how it's done for localizable properties, custom fields and url records

But it causes significant issue to the current implementation. We store prices/totals/etc for already placed orders only in the primary store currency. This way we'll have to store these values in both used currencies (now have "ExchangeRate" property) - to display proper value to customers on order details pages. It also can cause some issues when calculating discounts/totals/etc.

Each payment gateway also should be rewritten to support distinct currencies. It causes more issue when we have some product prices specified (passed to a payment gateway) in one currency, and other product prices are in other currency (no custom price specified for certain currency abd default one is used).

also see http://www.nopcommerce.com/boards/t/29547/nopcommerce-340-roadmap-and-estimated-release-date-lets-discuss.aspx?p=9#124517

comments

ppytlik wrote May 12, 2011 at 3:29 PM

There should be a way to define additional prices in specific Currency per Product Variant and Tier Pricing. Using Exchange rate is not always ideal, often the price for specific currency or country needs to be tweaked manually.
Who can help me add this feature into nopCommerce?

Gcaeiro wrote Jul 13, 2011 at 8:15 PM

This is also critical for us. We sure can help but it will be the first incursion into nopcommerce so we need someone to guide us in order to jump start and enable this feature asap

ppytlik wrote Aug 1, 2011 at 5:07 PM

I've implemented the basic functionality for this feature into nopCommerce 1.9 - no Admin area working yet to edit these, but once defined in SQL (separate CurrencyPrice & TierCurrencyPrice tables added), the right price is used.
If someone could help with the Admin area then I'd appreciate the assistance - I can provide a change-set for this and SQL schema for the 2 extra tables.
It might make more sense to implement the Admin area using nopCommerce 2.0 (MVC) instead of trying to get it working in 1.9 unless there are users who don't plan to switch to 2.0 and would like to use this feature?

TreeTiger wrote May 3, 2012 at 2:39 PM

Approximately 85% of all our web shop/eCommerce clients are in dire need of being able to manually enter 'fixed product prices per currency'.

osCommerce already has a package/module that can handle exactly that - please take a look at the page below.

http://www.oscommerce.com/community/contributions,4445/page,38

Adding this functionality would be a great help, since most of our clients are requesting this very feature.

Thank you in advance!

soerenlaursen wrote May 13, 2013 at 11:21 AM

Yeah this is a typical requirement from customers

wezzix wrote Jun 3, 2013 at 12:29 PM

I'd like to add the previously mentioned possibility of using a currency conversion table instead of price per product.
It would contain the fields: From price, To currency, To price (and possibly From Currency). The reason for this is that you might have thousands of products, but only a limited number of distinct prices (prices ending in 9 or .99). Every distinct price in the store currency usually corresponds to a single price in a different currency (deviations may exist for some users, but that's where the original solution above could be useful).
This way, you save a lot of time editing every time a price occurs on more than one product.

None of our customers accepts the existing solution based on exchange rate, so for them, this issue is essential.

soerenlaursen wrote Jun 3, 2013 at 1:25 PM

You want to be able to do both. It should be possible to setup rounding rules in case the price is calculated.

niwinkri wrote Jun 20, 2013 at 12:09 PM

yes, rounding rules, or just individual prices for language og currency is really needed. :-)

smssly wrote Aug 13, 2013 at 6:37 AM

This feature is very important for our customer. It would be exiting to see it added in future version.

kwestground wrote Oct 10, 2013 at 8:38 AM

This is an critical feature for almost every customer we have, I would be realy happy if this feature made it to nopCommerce.

hemant_kamalakar wrote Oct 16, 2013 at 6:14 AM

Is this feature available in current nopcommerce version 3.10?

JohnDillonUk wrote Jun 10, 2014 at 4:35 PM

Can I ask is this feature going to be part of 3.4 then? If so what is the proposed release date of 3.4?
Thanks

saketbongale wrote Jul 23, 2014 at 8:00 AM

Can you please let me know if the feature is available in the latest release?
Thanks in advance.

saketbongale wrote Jul 23, 2014 at 8:19 AM

Just a quick query, can we use Tier prices for this? suppose I set tier price for each country and disable the
_currencyService.ConvertFromPrimaryStoreCurrency(priceBase, _workContext.WorkingCurrency);
in all locations where product prices are displayed to end user.
This will serve two purposes,
  1. I can set fixed price for each country without going through currency conversion, end user will see tier price directly.
  2. I get currency converted values in all my admin reports.
Please correct me if wrong, cause am using Nop for the first time and just going through for last week.
Kindly guide if any one has implemented such thing.

michaeleaton wrote Jan 28, 2015 at 3:47 PM

Voted up. This is something that is actually stopping us using this platform. Is this currently being worked on?

We run websites for different teritories and have different prices dependant on lots of factors so have to use different prices for each location.

Michael

SaraWilson wrote Jan 28, 2015 at 3:54 PM

We really need this feature! Such a bad experience for a user if they get charged an exchange rate after purchasing in what they think is their own currency.

If it's not on the horizon then I think we'll have to look at another solution sadly as the Customer Service contact post purchase would cause too much hassle.

bilgibilisim wrote Mar 7, 2015 at 2:09 AM

This feature is very important!

starlight1971 wrote Mar 8, 2015 at 11:41 AM

Market relevant Prices are such important.
we import products in different currencys and have to sel them also in countries and different currencies.

productprices change depending on countrylaw's, importrules and taxes,

imarch wrote May 12, 2015 at 2:50 AM

This feature is very important to us. Our current website is growing very quickly with a customer following world wide. The current NOP solution will not work for us to position ourselves in other countries and we are now unfortunately actively looking other solutions.

starlight71 wrote Aug 17, 2015 at 8:06 PM

we just created a plugin for currency prices on products , similar to tier price functionality

http://www.giordano.ch/en-us/en-us/produkte/nopcommerce/nopcurrencypriceplugin.aspx

in combination with a other fix on framework.dll we can change the store by the currency selector. so each store has its currency with all currencyrelated shipping and extra costs. each product has its market prices in all currencies and prices have datefrom and dateto values.

have a look

didar_uranov wrote Dec 23, 2015 at 4:17 AM

Good day!
We have a tissue shop and started using nopCommerce as online store. We have tissues from Turkey, Italy, Cyprus, China and some other countries. Tissues from Italy we buy in Euro, in Turkey in dollars. In nopCommerce you can select main currency. When user chooses another currency, the price is converted using currency rates.

Because we have very unstable rate of our national currency, for some items we want to have price only in Euro without conversions.

This is a must have option

simirajsp wrote Aug 9 at 3:08 PM

I am waiting for this option from Nop commerce 3.6 onwards. It is unfortunate that this is not yet implemented. We have implemented the workaround using tier price. Now we are pushed to a corner as we have to support multiple currencies per store. Is this going to be implemented in near future or is there any plugin available?