8. Import Tier Prices

Tier pricing is a promotional tool that lets you price items differently in correspondence to their quantity.

Tier prices used for those customers who are willing to order multiple products, and you want to reward them by giving a discount.

You can create tier prices in Store Manager to manage them or import them from a .csv file during products import.

To import tier prices you need to have correct .csv file with tier prices added. The .csv file should also contain product identifier, so you could assign the corresponding tier prices to correct products.

CSV file example

You need to have the product SKU in a .csv file, to which tier price will be applied to. Value for tier price should be as follows:

admin|ALL GROUPS|4|11.0000||admin|ALL GROUPS|8|8.0000

where

admin - value for your website your products will be assigned to

ALL GROUPS - denotes the customer group, to which the tier price will be applied to. Use ‘all groups’ to apply it to all groups.

4 - quantity from which you wish to start the tier pricing

11.0000 - price of the indicated quantity of entities (in our case - for 4 products)

Run the process of products import and it will import your tier prices very quickly.

You need to assign the column "Tier Price" of .csv to the appropriate database field at the 6-th step of import process:

Assign Tier Price field in import wizard

As soon as the import completed, you can check import results at:

Imported Tier Prices

Please, also check for these useful articles:

How to Import Magento Tier Prices