Conversion Function
StoreAutomator provides a Conversion function designed for currency and precious metal price calculations. This can be used in Channel Settings>Common>Price calculations or in Settings>Templates.
In templates when you click add field you can click on the Source field text box and select “conversions” to use this to run exchange calculations to determine price.
As in the next menu, you are asked to select your base currency or channel’s currency,
And in the next selection there are the precious metal conversion functions:
As you can see there are options for both Gold and silver and the options to choose from, converting from and converting to prices per unit gram and ounces. Obtained prices are per unit weight, which is required from your end.
Precious Metals
StoreAutomator can obtain Gold and Silver prices per ounce (or gram) from the internet four times a day and then use this to calculate the price of the jewelry, based on the weight of the item that you have input.
Below is an example of a template that reads the type of metal from a custom field (Silver), then calculates the item’s price by multiplying the weight times the obtained Silver price per gram. If the custom-field does not read as “Silver”, then it will then calculates the item price by multiplying the weight times the obtained Gold price per gram from, the internet:
Currency Exchange
You can easily change the currency of your prices. You can convert currencies, such EUR to USD, and apply the USD prices to your marketplaces. Or vice versa. A complete list of all of our support currencies can be found at Settings>Currency Exchange including the date/time of the last update. Please make sure you use the exact currency code to correctly perform exchange operations.
To convert your price to the desired currency, you need to write a formula for each currency in the template or to the Price Rule field. Here is how to do it for templates:
- Go to the template and click edit
- Click the “add field” button within the template and choose the applicable target field.
- Next, click the source field textbox and add the formula by changing the dropdown from Auto to Manual.
- Type the applicable formula, click Ok and hit the Save button on the template. The formula works from left to right, by first defining your base currency, then converting from the defined currency or converting to the defined currency, and lastly entering the amount. For example, if you need to convert from a base currency of EUR to USD, then you would to use the following formula: Conversions.BaseCurrency.FromCurrency(EUR,100)
This rule means 100 Euro will be converted to USD amount.
- You can also copy the formula from templates and paste it into the price rule field in Channel Settings>Common>Pricing tab.
The formula works from left to right, by first defining your base currency, then converting from the defined currency or converting to the defined currency, and lastly entering the amount.
If you need to convert from EUR to USD, then you need to use the below formula and you can change it to the amount of dollars. As an example, 100 Euros was entered into the formula to see the exchange function easily.
Conversions.BaseCurrency.FromCurrency(EUR,100)
This rule means 100 Euro will be converted to USD amount.
If you need to convert from USD to EUR, you need to use the below formula and you can change the amount of EUR. As an example, 100 USD was entered into the formula to see the exchange function easily.
Conversions.BaseCurrency.ToCurrency(EUR,100)
This rule means 100 USD will be converted to Euro amount.
From the screenshot below, you can see the result of the conversion from 100 USD to EUR and from 100 EUR to USD.
Please note that these rules are applicable to all your marketplace templates.
In the example above, USD and EUR were used but there are other currencies that are available to use as follows,
AED UAE-Dirham
AUD Australia Dollar
BRL Brazil Real
CAD Canada Dollar
CHF Switzerland Franc
CNY China Yuan Renminbi
EGP Egypt Pound
EUR Euro Member Countries
GBP United Kingdom Pound
HKD Hong Kong Dollar
INR India Rupee
JPY Japan Yen
MXN Mexico Peso
QAR Qatar Riyal
RUB Russia Ruble
SAR Saudi Arabia Riyal
SGD Singapore Dollar
TRY Turkish Lira
USD United States Dollar
XAG Silver Ounce
XAU Gold Ounce
Current Conversion prices obtained and the latest update times are listed in the menu Settings>Currency Exchange: