MagePlugins

The Best Extensions Backed By The Best Support Team

Live Demo

Frontend Demo

The offline payment methods of "Check or Money Order" are the only payment methods activated for the demo. This way you don't have to enter any test credit or debit card data, making it easier for you to demo the software.


Backend Demo

  • User: demo
  • Pass: Demo123

Overview

Our Product Base Currency extension enables you to set a base currency on a product level instead of setting it on a website level in the configuration. Prices, special prices, tier prices, customer group prices and catalog price rule discount amounts can be set in a desired base currency for each product.

Features

  • Automated prices (prices, special prices, customer group prices, tier prices) and base currency scope
  • Set a base currency for prices, special prices, customer group prices and tier prices
  • Set a base currency for catalog price rule discount amounts
  • Export base currencies
  • Export prices
  • Export special prices
  • Export customer group prices
  • Export tier prices
  • Import base currencies
  • Import prices
  • Import special prices
  • Import customer group prices
  • Import tier prices
  • Automatic re-indexing after currency rates save

Configuration

The module ties the product price scope that can be set in the Magento configuration to the next attributes: Price, Special Price, Special Price From Date, Special Price To Date, Group Price, Tier Price and Base Currency.

In the admin panel, navigate to: System > Configuration > Catalog > Catalog > Price. Once Catalog Price Scope is changed and saved, the tied attribute scope is updated according to the value chosen.

Managing Currencies

Managing currencies is a Magento native function. It is not something that our extensions add or modify. This document will teach you how to add additional currencies to Magento to use with our extension.

To add or remove the currencies that a customer can select (that you can manage from the admin area), log into the admin panel of your Magento store and go to the following location:

System > Configuration > General > Currency Setup > Currency Options
                        

The currency options panel has a field labeled Allowed Currencies. This is a multi-select box that will allow you to select all of the currencies that you would like to offer on your store. Holding the control Ctrl key, you'll be able to choose every currency that you want to offer. Holding the select key will allow you to select a range of currencies to offer.

The Allowed Currencies' multi-select box will provide you with additional currency options when working within the administrative area.

Setting a Store Wide Default Currency

In this same section you will see Base Currency and Default Display Currency. The display currency will be used in your product details and product lists. This is what customers will see when surfing your store and browsing your lists of products.

The Base Currency is used to communicate pricing to your payment gateway. This will allow you to show prices in one currency with the default display currency, yet transact in a different currency.

Manage Products

In the administrator panel: Catalog > Manage Products. Click "edit product" or create a new one.

Product Base Currency appends the Base Currency attribute at the end of the Prices tab for Simple, Configurable, Virtual, Bundle and Downloadable product types.

Once the Base Currency is changed, the system sets the input currency for the next attributes: Price, Special Price, Group Price and Tier Price.

Catalog Price Rules

In administrator panel: Promotions -> Catalog Price Rules. Click "edit rule" or create a new one. Select the Actions tab.

The system respects the base currencies for products matching the rule criterias, in case of fixed Discount Amount values.

Data Export

Data exporting can be handled with the number of CLI (command line interface) scripts that are built in.

Base Currency

Run the script with your arguments:

php shell/MP/ProductBaseCurrency/Catalog/Product/BaseCurrency/Export.php \
                                --file-path /var/export/Mage Plugins/ProductBaseCurrency/ \
                                --file-filename product-base-currency.csv
                            

Note, The script path is related to the document root in the sample, but can be replaced with the absolute path (to run via cron service for example), file-path directory is always related to the document root.

Run the next command to get the argument description

php shell/MP/ProductBaseCurrency/Catalog/Product/BaseCurrency/Export.php --help
                            

The output data feed var/export/MP/ProductBaseCurrency/product-base-currency.csv should have the next format:

sku,store,currency
                            "HTC Touch Diamond",,EUR
                            "HTC Touch Diamond",default,USD
                            

Price

Run the script with your arguments:

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Price/Export.php \
                                --file-path /var/export/Mage Plugins/ProductBaseCurrency/ \
                                --file-filename product-price.csv
                            

Note, The script path is related to the document root in the sample, but can be replaced with the absolute path (to run via cron service for example), file-path directory is always related to the document root.

Run the next command to get the arguments description

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Price/Export.php --help
                            

The output data feed var/export/MP/ProductBaseCurrency/product-price.csv should have the following format:

sku,store,price
                            "HTC Touch Diamond",,750
                            "HTC Touch Diamond",default,755
                            

Special Price

Run the script with your arguments:

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Special/Export.php \
                                --file-path /var/export/Mage Plugins/ProductBaseCurrency/ \
                                --file-filename product-special-price.csv
                            

Note, The script path is related to the document root in the sample, but can be replaced with the absolute path (to run via cron service for example), file-path directory is always related to the document root.

Run the next command to get the argument's description

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Special/Export.php --help
                            

The output data feed var/export/MP/ProductBaseCurrency/product-special-price.csv should have the following format:

sku,store,price
                            "HTC Touch Diamond",,740
                            "HTC Touch Diamond",default,745
                            

Customer Group Price

Note, the Group Price function is available for Magento CE 1.7.0.0+ only.

Run the script with your arguments:

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Group/Export.php \
                                --file-path /var/export/Mage Plugins/ProductBaseCurrency/ \
                                --file-filename product-group-price.csv
                            

Note, The script path is related to the document root in the sample, but can be replaced with the absolute path (to run via cron service for example), file-path directory is always related to the document root.

Run the following command to get the arguments description

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Group/Export.php --help
                            

The output data feed var/export/MP/ProductBaseCurrency/product-group-price.csv should have the following format:

sku,all_groups,customer_group,website,price
                            "HTC Touch Diamond",,"General",,730
                            

Tier Price

Run the script with your arguments:

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Tier/Export.php \
                                --file-path /var/export/Mage Plugins/ProductBaseCurrency/ \
                                --file-filename product-tier-price.csv
                            

Note, The script path is related to the document root in the sample but can be replaced with the absolute path (to run via cron service for example), file-path directory is always related to the document root.

Run the following command to get the arguments description

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Tier/Export.php --help
                            

The output data feed var/export/MP/ProductBaseCurrency/product-tier-price.csv should have the next format:

sku,all_groups,customer_group,website,qty,price
                            "HTC Touch Diamond",,"General",,2,725
                            "HTC Touch Diamond",,"General",,3,720
                            

Data Import

Data importing can be handled with a number of CLI (command line interface) scripts built-in.

Base Currency

Run the script with your arguments:

php shell/MP/ProductBaseCurrency/Catalog/Product/BaseCurrency/Import.php \
                                --ftp \
                                --ftp-host ftp.hostname.com \
                                --ftp-user username \
                                --ftp-password password \
                                --ftp-filename remote-product-base-currency.csv \
                                --file-path /var/import/Mage Plugins/ProductBaseCurrency/ \
                                --file-filename product-base-currency.csv
                            

Note, The script path is related to the document root in the sample but can be replaced with the absolute path (to run via cron service for example), the file-path directory is always related to the document root.

Omit the ftp arguments to run the import from the local data feed:

php shell/MP/ProductBaseCurrency/Catalog/Product/BaseCurrency/Import.php \
                                --file-path /var/import/Mage Plugins/ProductBaseCurrency/ \
                                --file-filename product-base-currency.csv
                            

Run the next command to get the argument description

php shell/MP/ProductBaseCurrency/Catalog/Product/BaseCurrency/Import.php --help
                            

The input data feed var/import/MP/ProductBaseCurrency/product-base-currency.csv should have the next format:

sku,store,currency
                            "HTC Touch Diamond",,EUR
                            "HTC Touch Diamond",default,USD
                            

Data Feed Format

Property Description
sku Product SKU
store Store ID or code
currency Currency code

Price

Run the script with these arguments:

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Price/Import.php \
                                --ftp \
                                --ftp-host ftp.hostname.com \
                                --ftp-user username \
                                --ftp-password password \
                                --ftp-filename remote-product-price.csv \
                                --file-path /var/import/Mage Plugins/ProductBaseCurrency/ \
                                --file-filename product-price.csv
                            

Note, The script path is related to the document root in the sample, but can be replaced with the absolute path (to run via cron service for example), the file-path directory is always related to the document root.

Omit ftp arguments to run the import from the localfile-path data feed:

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Price/Import.php \
                                --file-path /var/import/Mage Plugins/ProductBaseCurrency/ \
                                --file-filename product-price.csv
                            

Run the next command to get the argument's description

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Special/Import.php --help
                            

The input data feed var/import/MP/ProductBaseCurrency/product-special-price.csv should have the next format:

sku,store,price
                            "HTC Touch Diamond",,740
                            "HTC Touch Diamond",default,745
                            

Data Feed Format

Property Description
sku Product SKU
store Store ID or code
price Price value

Customer Group Price

Run the script with your arguments:

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Group/Import.php \
                                --ftp \
                                --ftp-host ftp.hostname.com \
                                --ftp-user username \
                                --ftp-password password \
                                --ftp-filename remote-product-group-price.csv \
                                --file-path /var/import/Mage Plugins/ProductBaseCurrency/ \
                                --file-filename product-group-price.csv
                            

Note, The script path is related to the document root in the sample, but can be replaced with the absolute path (to run via cron service for example), the file-path directory is always related to the document root.

Omit the ftp arguments to run the import from the local data feed:

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Group/Import.php \
                                --file-path /var/import/MP/ProductBaseCurrency/ \
                                --file-filename product-group-price.csv
                            

Run the next command to get the arguments description

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Group/Import.php --help
                            

The input data feed var/import/MP/ProductBaseCurrency/product-group-price.csv should have the following format:

sku,all_groups,customer_group,website,price
                            "HTC Touch Diamond",,"General",,730
                            

Data Feed Format

Property Description
sku Product SKU
all_groups Either price should be applied for all groups or not (1 or 0). For Group Price it equals to 0 (or empty)
customer_group Customer group ID or name
website website ID or code
price Price value

Tier Price

Run this script with your arguments:

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Tier/Import.php \
                                --ftp \
                                --ftp-host ftp.hostname.com \
                                --ftp-user username \
                                --ftp-password password \
                                --ftp-filename remote-product-tier-price.csv \
                                --file-path /var/import/Mage Plugins/ProductBaseCurrency/ \
                                --file-filename product-tier-price.csv
                            

Note, The script path is related to the document root in the sample, but can be replaced with the absolute path (to run via cron service for example), the file-path directory is always related to the document root.

Omit the ftp arguments to run the import from the local data feed:

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Tier/Import.php \
                                --file-path /var/import/Mage Plugins/ProductBaseCurrency/ \
                                --file-filename product-tier-price.csv
                            

Run the next command to get the argument's description

php shell/MP/ProductBaseCurrency/Catalog/Product/Price/Tier/Import.php --help
                            

The input data feed var/import/MP/ProductBaseCurrency/product-tier-price.csv should have the following format:

sku,all_groups,customer_group,website,qty,price
                            "HTC Touch Diamond",,"General",,2,725
                            "HTC Touch Diamond",,"General",,3,720
                            

Data Feed Format

Property Description
sku Product SKU
all_groups Either price should be applied for all groups or not (1 or 0)
customer_group Customer group ID or name
website Website ID or code
qty Quantity value
price Price value

The Best Extensions Backed By The Best Support Team