How to import tier prices?

How to import tier prices?

In order to import Tier (Customer Group) prices, the following fields are needed in the import entity with the following fields:

Root Entity



Customer Group Price Entity




Here are some tips on how to find the values for the fields:

1) catalog_product_tier_price.all_groups
The field is responsible for the 'All Groups' value. If it is 1, then, the tier price is valid for all the groups, in the 'catalog_product_tier_price.customer_group_id' column, please, place no value. If you'd like to select a specific customer group, place "0" in this field, and the customer group id in the 'catalog_product_tier_price.customer_group_id' column.
2) catalog_product_tier_price.customer_group_id
The field stands for the customer group ID, which can be located on the Customers > Customer Groups grid. Alternatively, it is possible to enable the 'Convert group_code to group_id' modifier, and import the code values from the file. The module will transform them to IDs automatically.
3) catalog_product_tier_price.website_id
The module expects website ID by default. It can be located in Stores > All Stores > website's page URL. Alternatively, please, enable the 'Website Code to Website Id' modifier to be able to define websites by their codes.

Here is an example of the import file:



You may also check the import file in Google Sheets, following this link.

More use-case scenarios may be found in the article Useful Tips and Popular Import Use Cases.

      • Related Articles

      • How to set different product prices for different customer groups?

        It's possible to set prices per customer groups using the default Magento tier pricing feature. To configure tier prices, navigate to Products → Edit/create a product → Price → Advanced Pricing link. Here, is the Customer Group Price configurations, ...
      • Import and Export Guidelines

        General Information About the Package and Its Tariffs The Import & Export solution is designed for migrating data from one website to another or to/from a different platform, as well as for automated/manual updates of product quantities, prices, and ...
      • Products are being imported without name, price, and other values. How to fix this?

        If the product itself is imported, but additional attributes are missing, the following steps might be helpful to resolve the issue: Step 1. Ensure that the Entity Keys are added as prefixes to the columns' names in the import file. In Magento's ...
      • How to restrict products for specific customer groups?

        The Customer Group Catalog extension offers the capability to hide particular products or categories from the catalog based on customer groups. This feature empowers store administrators to create unique catalogs tailored to specific customers. To ...
      • How can I add the attachments in bulk?

        You may import attachments in bulk and assign them to products via CSV-file import by navigating to Amasty -> Product Attachments -> Mass Attachment Import. To start a new import process, click New Import and follow the next steps: Step 1. Prepare ...