Boost your customer loyalty effortlessly Learn more

Shopping cart

Importing Tier Prices in 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

You can import tier prices by the following steps:

How to import Tier Prices in Magento 2

Step 1: Export the Tier Price 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 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

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

Reference: Magento 2 User Guide

It comes to the end of tutorial: Importing Tier Prices in Magento 2.

PDF Invoice samples for Magento 2

mageplaza pdf invoice

Want to apply these above Invoice templates for your store?

See how

Please leave comments if you have any questions, feedbacks.

Comments for Importing Tier Prices in Magento 2

You also may like these Magento 2 Extensions

One Step Checkout

$199
92 reviews

Layered Navigation

$99
52 reviews

SEO

FREE
32 reviews

Gift Card

$199
5 reviews

Reward Points

$149
4 reviews

Affiliate

$149
12 reviews