How to Import Magento Tier Prices
Magento tier price is a king of marketing approach for pricing items in different way depending on the quantity of items purchased by the buyer. This helpful option already proven itself as an effective way to sale more products at one time. Hence this results in increasing of your profitability rate.
Just consider - more items purchased, more money earned. On this condition you can allow yourself to reduce price a little bit in order to sell more quantities of goods. Moreover, you can have different pricings for different customer groups and for example encourage loyal clients with better discount rate.
If you already using this option, you might think that you need to add lower pricing depending on number of items bought to multiple goods of your website. It would be nice if Backend allowed you to import through the admin interface, but fortunately there is no such functionality out-of-the-box.
Understanding the importance of this feature out of the range of normal import facilities, it was implemented in Store Manager application.
This is a perfect tool to update extensive data associated to products, including tier prices. Tier price upload with Magento Manager application brings retail discount pricing options along with other products data while their upload or making changes to existing goods.
Magento Tier Prices Import File Example
How in particular it is possible? Basically, it is all about file format.
In case you are updating existing items with special tier pricing, in your file there should be the following columns: SKU and Tier Price.
SKU row is used for product identification and should contain the same distinctive set of numbers and letters as you have used to create goods.
Tier Price column need be formatted in the definite way for the prices to be applied properly. Trier price should contain separated by pipe (or other separator you use) the following elements in the definite order:
- word ‘admin’,
- the name of customer group this Magento tier price should be applied to,
- minimum number of items that should purchase for the indicated price
- the price (usually less than actual product price) that would be charged for each of the indicated number of items in format xx.xxxx.
Here is the example: admin|General|5|490.0000,
where General i the name of the group of clients it should be applied, 5 - number of goods of the same item to be placed in one and the same order and price - 490.0000 which means $490.
In case you need to create various tier pricing for the same product but for different customer groups, you can do it by adding them in the same column, but separating one tier price from another with double delimited symbol (in our case we use pipe separator). For better understanding check the screenshot:
In case you would like to perform tier price import along with upload of all product-related data, beside of the mentioned columns there should be the rows that responsible for product creating and its representation on the front-end.
To get the example of properly-configured file for tier prices import, you can manually add a few of them to products and export it.
When the file is ready, the process of import involves all the steps of Magento import wizard described here -www.mag-manager.com/useful-articles/magento-product-management/magento-import-products
Remember that main thing for successful Magento import of tier prices is to choose correct separator for fields (it should be identical to the one used in the file) and assign corresponding .csv fields columns to database fields.
Tier price is an essential part of in-depth pricing strategies in eСommerce. Encourage customers to buy in bulk and you will sell high volumes of a particular product. Gain higher advantage over your competitors who are still adding tier prices one-by-one!