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:
- 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. - 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. - 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.
Tier price records are uniquely identified by the combination of entity_id, all_groups, customer_group_id, qty, and website_id. Duplicate records with identical values are not allowed. If a matching record exists, it will be updated; otherwise, a new record will be created.
The import file does not require entity_id and value_id fields for creating or updating tier price records.
A minimal import file may include only tier price-related fields, for example:
A minimal import file may include only tier price-related fields, for example:
Related Articles
Import and Export Guidelines
General Information About the Package and Its Tariff Plans 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, ...How can I output tier prices in the feed?
Since v.4.1.0 of Product Feed extension, it is possible to add tier prices to the feed. You can find the 'amasty/module-product-feed-subscription-functionality' package for installing in composer suggest. Please note that the module is available as a ...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, ...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 Fix the "Syntax error or access violation: 1072 Key column 'customer_group_id' doesn't exist in table" issue?
The outlined error is related to the amasty_groupcat_rule_product table, which is used by the Customer Group Catalog extension and serves as an index table. Data gets written into it only after performing a full Magento reindex. However, some issues ...
Announcements
⚡ Have you enlarged the functionality of the Amasty extension with your own code? Share your improvements with us!
At Amasty, we understand that some of our clients require customized features to perfectly align the extension with their business needs. If you have developed new functionality within an Amasty module and would like to share it, please submit a ticket