How to import Tier Prices in Magento 2

The Most Popular Extension Builder for Magento 2

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

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.

tierprice

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.

Magento 2 Better Tier Price!

Related Post

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:

Subscribe

Stay in the know

Get special offers on the latest news from Mageplaza.

Earn $10 in reward now!

Earn $10 in reward now!

comment
iphone
go up