Product-Level Tier Pricing with Variant Exclusions

Table of Contents

  1. Business Requirements
  2. Use Case 1: Tiered Final Price Based on Eligible Variant Quantity
  3. Use Case 2: Tiered Percentage Discount Based on Eligible Variant Quantity
  4. Use Case 3: Tiered Fixed Discount Based on Eligible Variant Quantity

Business Requirements

  • Allow merchants to apply product-level tier pricing while excluding specific variants from the pricing rule.
  • Calculate quantity tiers using only eligible variants of the selected product.
  • Prevent excluded variants from contributing to quantity calculations and tier qualification.
  • Allow one or more variants of the same product to be excluded from a tier pricing rule.
  • To set either pricing, percentage discounts, or fixed discounts only to eligible variants.

Use Case 1: Tiered Final Price Based on Eligible Variant Quantity

Cart Example

Product Variant Quantity Base Price Final Unit Price Line Total Note
Pure White Basic Tee White / Small 10 $100 $80 $800 Total eligible quantity (10 + 8 + 7 = 25) qualifies for the 25+ tier, resulting in a final price of $80 per unit. The excluded variant (Premium Gold Edition) retains its original price.
Pure White Basic Tee White / Medium 8 $100 $80 $640 As above
Pure White Basic Tee White / Large 7 $100 $80 $560 As above
Pure White Basic Tee Premium Gold Edition (Excluded) 10 $150 $150 $1,500 Excluded from Tier Calculation
Total $3,500

Note: Only eligible variants contribute to quantity calculations.

Rule Configuration

Setting Value
Pricing Type Tiered Final Price
Condition Quantity Clubbed Across Eligible Variants
Product Pure White Basic Tee
Excluded Variants Premium Gold Edition

Pricing Tiers

Pure White Basic Tee

Eligible Qty Final Price
5 $95
10 $90
25 $80
50 $75
70 $65

Use Case 2: Tiered Percentage Discount Based on Eligible Variant Quantity

Cart Example

Product Variant Quantity Base Price Discount % Final Unit Price Line Total Note
Pure White Basic Tee White / Small 20 $100 20% OFF $80 $1,600 Total eligible quantity (20 + 15 + 15 = 50) qualifies for the 50+ tier, applying a 20% discount to eligible variants only.
Pure White Basic Tee White / Medium 15 $100 20% OFF $80 $1,200 As above
Pure White Basic Tee White / Large 15 $100 20% OFF $80 $1,200 As above
Pure White Basic Tee Premium Gold Edition (Excluded) 10 $150 Not Eligible $150 $1,500 Excluded from Tier Calculation
Total $5,500

Note: The excluded variant (Premium Gold Edition) does not count toward the quantity threshold and receives no discount.

Rule Configuration

Setting Value
Pricing Type Tiered Percentage Discount
Condition Quantity Clubbed Across Eligible Variants
Product Pure White Basic Tee
Excluded Variants Premium Gold Edition

Pricing Tiers

Product: Pure White Basic Tee

Eligible Qty Discount
10+ 5% OFF
25+ 10% OFF
40+ 15% OFF
50+ 20% OFF

Use Case 3: Tiered Fixed Discount Based on Eligible Variant Quantity

Cart Example

Product Variant Quantity Base Price Discount / Unit Final Unit Price Line Total Note
Pure White Basic Tee White / Small 15 $100 $10 OFF $90 $1,350 Total eligible quantity (15 + 15 + 10 = 40) qualifies for the 40+ tier, resulting in a $10 discount per unit.
Pure White Basic Tee White / Medium 15 $100 $10 OFF $90 $1,350 As above
Pure White Basic Tee White / Large 10 $100 $10 OFF $90 $900 As above
Pure White Basic Tee Premium Gold Edition (Excluded) 10 $150 Not Eligible $150 $1,500 Excluded from Tier Calculation
Total $5,100

Note: Excluded variants (Premium Gold Edition) retain their original pricing and do not contribute to quantity calculations.

Rule Configuration

Setting Value
Pricing Type Tiered Fixed Discount per Unit
Condition Quantity Clubbed Across Eligible Variants
Product Pure White Basic Tee
Excluded Variants Premium Gold Edition

Pricing Tiers

Product: Pure White Basic Tee

Eligible Qty Discount / Unit
10+ $3 OFF
25+ $7 OFF
40+ $10 OFF
50+ $15 OFF