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

  • Apply product-level quantity discounts while excluding specific variants.
  • Prevent excluded variants from contributing to quantity tier calculations.
  • Allow multiple variants to be excluded from the same pricing rule.
  • Continue applying discounts to eligible variants only.
  • Maintain original pricing for excluded variants regardless of cart quantity.
  • Support premium, clearance, bundle, and special-edition products that require separate pricing.

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

Cart Example

Product Variant Quantity Base Price Final Unit Price Line Total Applied Tier Note
Pure White Basic Tee White / Small 20 $100 $75 $1,500 50+ Included in Tier Calculation
Pure White Basic Tee White / Medium 15 $100 $75 $1,125 50+ Included in Tier Calculation
Pure White Basic Tee White / Large 15 $100 $75 $1,125 50+ Included in Tier Calculation
Pure White Basic Tee Premium Gold Edition (Excluded) 10 $150 $150 $1,500 Excluded Excluded from Tier Calculation
Total $5,250

Quantity Calculation

Variant Qty Counted Toward Tier
White / Small 20
White / Medium 15
White / Large 15
Premium Gold Edition 0 (Excluded)
Total Eligible Quantity 50

Result: 50 eligible units qualify for the highest pricing tier.

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

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

Note: Only eligible variants contribute to quantity calculations. Excluded variants do not count toward quantity thresholds and retain their original pricing.

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

Cart Example

Product Variant Quantity Base Price Discount % Final Unit Price Line Total Applied Tier Note
Pure White Basic Tee White / Small 20 $100 20% OFF $80 $1,600 50+ Included in Tier Calculation
Pure White Basic Tee White / Medium 15 $100 20% OFF $80 $1,200 50+ Included in Tier Calculation
Pure White Basic Tee White / Large 15 $100 20% OFF $80 $1,200 50+ Included in Tier Calculation
Pure White Basic Tee Premium Gold Edition (Excluded) 10 $150 No Discount $150 $1,500 Excluded Excluded from Tier Calculation
Total $5,500

Quantity Calculation

Variant Qty Counted Toward Tier
White / Small 20
White / Medium 15
White / Large 15
Premium Gold Edition 0 (Excluded)
Total Eligible Quantity 50

Result: 50 eligible units qualify for the highest discount tier.

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

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

Note: Excluded variants do not contribute to quantity calculations and do not receive percentage discounts.

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 Applied Tier Note
Pure White Basic Tee White / Small 20 $100 $15 OFF $85 $1,700 50+ Included in Tier Calculation
Pure White Basic Tee White / Medium 15 $100 $15 OFF $85 $1,275 50+ Included in Tier Calculation
Pure White Basic Tee White / Large 15 $100 $15 OFF $85 $1,275 50+ Included in Tier Calculation
Pure White Basic Tee Premium Gold Edition (Excluded) 10 $150 $0 OFF $150 $1,500 Excluded Excluded from Tier Calculation
Total $5,750

Quantity Calculation

Variant Qty Counted Toward Tier
White / Small 20
White / Medium 15
White / Large 15
Premium Gold Edition 0 (Excluded)
Total Eligible Quantity 50

Result: 50 eligible units qualify for the highest fixed discount tier.

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

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

Note: Excluded variants retain their original pricing while eligible variants receive fixed discounts based on combined eligible quantity.