The Most Popular Extension Builder for Magento 2

With a big catalog of 224+ extensions for your online store

How to import Tier Prices in Magento 2

Magento 2 Tier prices is a tool that allow you offering a discount to all customers, or extend the discount to select only customer groups. It permits you to attract customers and encourages them to place an order on your website. However if you have too many products, you should import the pricing data instead of typing the tier prices by hand for each product.


How to import Tier Prices in Magento 2

You can import tier prices by the following steps:

Step 1: Export the Tier Prices Data

  • Sign up your Admin account.
  • On the Admin sidebar, click on System > Data Transfer: Export
  • Under section Export Settings, set Entity Type into “Advanced Pricings”

advance pricing

  • You see Entity Attributes then pull down to the SKU attributes:
    • If your tier prices are relied on a fixed amount, put each product to be exported in the SKU.
    • If your tier prices are relied on a discount percentage, put each. product to be exported in the SKU and separate them by a comma.
  • Pull down in the end and click Continue.
  • Open the file which in the lower-left corner of your browser window and use the following exported data for your importing tier price data:
    • sku
    • tier_price_website
    • tier_price_customer_group
    • tier_price_qty
    • tier_price
    • tier_price_value_type

Step 2: Update the Tier Price data

  • You have to update tier price data for each product because any product with no tier price updates may be removed from the CSV file. Note: No need to re-enter unchanged products.
  • Save the CSV file after updating.

Step 3: Import the Updated Data to Magento store

  • On the Admin sidebar, click on System > Data Transfer: Import
  • Under section Import Settings, set Entity Type into “Advanced Pricings” and set Import Behavior into “Add/Update”.
  • Select the file that you want to import from your device by tapping Choose File on File to Import
  • You can see Check Data in the upper-right corner and then click on it.
  • Final step is clicking on Import to import your file. If it goes wrong, alter each issue with the listed data in the message and try again.

Better Tier Price

Better Tier Price for Magento 2

Boost sales by offering customers lower prices when buying more items

Check it out!

Related Post

Image Description
With over a decade of experience crafting innovative tech solutions for ecommerce businesses built on Magento, Jacker is the mastermind behind our secure and well-functioned extensions. With his expertise in building user-friendly interfaces and robust back-end systems, Mageplaza was able to deliver exceptional Magento solutions and services for over 122K+ customers around the world.

Looking for
Customization & Development Services?

8+ years of experiences in e-commerce & Magento has prepared us for any challenges, so that we can lead you to your success.

Get free consultant
development service

    Explore Our Products:


    Stay in the know

    Get special offers on the latest news from Mageplaza.

    Earn $10 in reward now!

    Earn $10 in reward now!

    go up