Tip: Recalculate currencies in Google Sheets with the GOOGLEFINANCE function

27 Nov 2025

Abicart supports automatic currency conversion via the European Central Bank (ECB). This means that when a customer makes a purchase on the platform, the price of the product can be automatically converted from the currency used by the seller to the currency in which the customer wishes to pay. Exchange rates are taken directly from the ECB and are updated regularly to ensure that prices are up-to-date. Although this feature is available, it is sometimes necessary to recalculate currencies in your own files before importing. The quickest way is probably to use Google Sheets and the GOOGLEFINANCE function: GOOGLEFINANCE can be used to convert currencies in csv files. To do this you can use the formula GOOGLEFINANCE together with the parameter "price" and specify the currency you want to convert from and to.This is what the formula looks like:=GOOGLEFINANCE("CURRENCY:" + from_currency + to_currency, "price")Where "from_currency" is the currency you want to convert from (e.g. "USD" for US dollars) and "to_currency" is the currency you want to convert to (e.g. "EUR" for Euros).Here is an example of how you can use GOOGLEFINANCE to convert a currency in a csv file:Open a new Google Sheet and import your csv file with the currencies you want to convert.Add a new column in the worksheet where you want to display the converted currency.Type the formula =GOOGLEFINANCE("CURRENCY:" + A2 + B2, "price") in the first cell of the new column, where A2 and B2 are the cells that contain the currency you want to convert from and to.Press Enter to see the result of the conversion.Drag the lower right corner of the cell to fill the formula in the rest of the column.Please note that GOOGLEFINANCE can only retrieve financial information in English and may be limited to certain financial information depending on your location. It is also important to remember that financial information may be subject to delays and may be inaccurate or incomplete, so it is important to verify the information before making decisions based on it.Read more about GOOGLEFINANCE here https://support.google.com/docs/answer/3093281?hl=en

Currency

27 Nov 2025

Activate multiple currencies, link currencies to each other, automatically updated exchange rates. How do currencies work in Abicart? All shops must have at least one currency for everything to work. If you have multiple currencies, you choose one currency as your base currency. How many currencies can I have in my shop? We support around 30 different currencies (SEK, EUR, USD, GBP and NOK are the most popular) and there is no limit to the number of currencies you can use. See a list of currencies hereMake sure that the payment methods you use in the shop support the shop's active currencies. Contact the respective payment company to find out which currencies are supported.How do I set the currencies?Go to Settings -> CurrenciesBy default, SEK is already enabled in the store and is displayed as a separate block. The name of the currency is on the left. In the middle there are three icons:A house - shows that this is the shop's current base currencyAn eye - Shows that the currency is visible in the shop.An open padlock - This shows that the currency is manual and not locked to another currency.To the right of the block is an icon with an arrow, click on it and the whole SEK block will fold out. Here you can see the settings for the points we went through above. Settings for a base currency, visible/hidden, and manual/locked. If you only have one currency activated, you don't need to make any settings here, everything is already set correctly. Enable multiple currenciesUnder Settings -> Currencies there is a block at the top titled "Currency settings". There is a list of all supported currencies. In this example, we already have SEK as the base currency and we add EUR as a second currency. Select "EUR: Euro" from the list and then click on "Add".  The currency is now displayed in a separate block below the base currency that is prepended. The following settings are available: EuroThe name of the currency is displayed as well as a link, "Set as default". If you want to use this currency as the base currency (instead of SEK which is already the base currency), click on the link. ActivationBy default, all new currencies you add are hidden. This is so that you can add prices for all products, shipping costs, etc. In order for the currency to be visible in the shop and to be used, you must tick the "Visible" box." Remove this currencyAll currencies that are not base currencies have a link called "Delete this currency". It simply deletes the currency from the store. Pricing If you have multiple currencies there are two ways to set prices, manual or convert. The base currency is always "manual" which means that you have to enter specific prices for all products, shipping costs, etc. By converting prices, you link the currency to the base currency or another manual currency and do not have to enter prices manually for all products in the new currency. In this example, we want to link EUR to SEK. We select "Convert prices" and two new settings appear on the right. Currency exchangeHere a list of all manual currencies is shown and you can choose a currency to which you want to link this currency. In our example, we have only SEK as manual currency and it is already selected. RoundingHere is a function where you can choose to round the prices after they have been converted from the selected currency. Whole numbers, tens, hundreds, or no rounding.This will not work with manual currency Manual or automatic exchange rate?On the right-hand side of the top block of the page are the settings for "Manage exchange rates". The exchange rate is automatically updated dailyThis option allows the European Central Bank to automatically update the currencies every day according to the current exchange rate. Set the exchange rate manually for each currencyThis setting allows you to set your own exchange rate for each pegged currency. Keep in mind that currencies can rise and fall quickly, so if you have manually set exchange rates, you must keep track of the current rates and adjust them manually at regular intervals. Otherwise, there is a risk of having rates that are too low or too high. We recommend using the "Exchange rate automatically updated daily" setting to prevent this.