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
Step 2: Update the Tier Price Data
Step 3: Import the Updated Data to Magento store

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.