Skip to main content
All CollectionsImport / ExportImport
How to import tier pricing groups
How to import tier pricing groups
Updated over 2 weeks ago

Understanding Tier Pricing: Groups and Website Assignments

In this article, we’ll explore tier pricing in greater detail, focusing on its application with groups and website assignments. For a basic introduction to tier pricing and how to set it up, check out this article on improving tier pricing.

In some cases, it’s essential to import tier prices that are specific to customer groups and websites. Below, we’ll walk you through an example and explain how tier pricing works with group and website parameters.


Example 1: Fixed Price Tier Pricing

SKU

Name

Tier Pricing Example

100

Test

0_2_32000_fixed_tierpricing

Header Explanation:

  • 0 = website_id

  • 2 = qty (quantity threshold for the tier pricing to apply)

  • 32000 = customer_group_id (default customer group)

  • fixed = price type (fixed price per unit)

  • tier pricing = label or description


Example 2: Percentage-Based Tier Pricing

SKU

Name

Tier Pricing Example

101

Test 2

0_3_1_percent_tierpricing

Header Explanation:

  • 0 = website_id

  • 3 = qty (quantity threshold for the tier pricing to apply)

  • 1 = customer_group_id (e.g., retailer group)

  • percent = price type (% discount on the base price)

  • tier pricing = label or description


Key Notes:

  • If you’re unsure how to find your customer_group_id, navigate to the Magento backend:
    Customers > Customer Groups
    Here, you’ll find a list of all defined customer groups along with their corresponding IDs.

  • Ensure that tier pricing is imported carefully, as mistakes in group or website assignments can lead to pricing inconsistencies.

By leveraging tier pricing with groups and websites, you can create targeted pricing strategies tailored to specific customer segments and markets.

Did this answer your question?