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
• 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”

• 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 for Magento 2

Boost sales by offering customers lower prices when buying more items

Check it out!

Related Post

• How to Import Products in Magento 2
• How to Import All Products with Images
• Export And Import Customers in Magento 2
• How to Setup an Affiliate Program