Creating Category Prices

Learn how to create your first category-specific prices for both individual customers and customer groups.

Prerequisites

• Extension installed and configured
• Admin access to Catalog >Category Prices
• At least one category in your catalog
• Customers or customer groups created

Two Types of Category Prices

The extension provides two separate interfaces for different pricing strategies:

1. Customer Prices - Individual customer category pricing
2. Customer Group Prices - Group-based category pricing (Wholesale, Retail, VIP, etc.)

Both types work together using the priority system for conflict resolution.

Creating Customer Category Prices

Step 1: Navigate to Customer Prices Grid

Admin Panel >Catalog > Category Prices > Customer Prices

This shows a grid of all existing customer category prices with columns:

• Category
• Customer
• Quantity
• Price
• Priority
• From Date / To Date
• Website
• Actions (Edit/Delete)

Step 2: Add New Customer Price

Click Add New button in the top right.

Step 3: Fill Required Fields

Basic Information

Category:

• Click the category selector
• Navigate the category tree
• Select the target category
• All products in this category will receive this price

Customer:

• Start typing customer name or email
• Select from autocomplete dropdown
• Or enter customer ID directly

Quantity:

• Minimum quantity for this price tier
• Example: 1 for first tier
• Default: 1

Price:

• Custom price value
• Example: 99.99
• This overrides the regular category price

Optional Fields

Priority:

• Numeric value (0-999)
• Higher values take precedence
• Default: 0
• Examples:
  • 10 - Standard pricing
  • 20 - Promotional pricing
  • 30 - VIP pricing

From Date:

• Start date for price validity
• Leave empty for immediate activation
• Format: YYYY-MM-DD or use date picker
• Example: 2025-01-01

To Date:

• End date for price validity
• Leave empty for no expiration
• Must be after From Date
• Example: 2025-12-31

Website:

• Select website scope
• Use "All Websites" for global pricing
• Or select specific website for regional pricing

Price Application Type:

• How the price should be applied
• Options:
  • Fixed - Absolute price value
  • Discount - Percentage discount
  • Adjustment - Add/subtract from base price

Step 4: Save

Click Save button. The price is now active for the customer and category.

Step 5: Verify

1. Log in as the customer (or use dev headers)
2. Navigate to a product in the category
3. Verify the custom price displays

Creating Customer Group Category Prices

Step 1: Navigate to Customer Group Prices Grid

Admin Panel >Catalog > Category Prices > Customer Group Prices

This shows a grid similar to customer prices but with customer groups instead.

Step 2: Add New Group Price

Click Add New button.

Step 3: Fill Required Fields

Basic Information

Category:

• Same as customer prices
• Select category from tree

Customer Group:

• Select from dropdown
• Options include:
  • General
  • Wholesale
  • Retail
  • NOT LOGGED IN
  • Custom groups you created

Quantity:

• Minimum quantity for tier
• Same behavior as customer prices

Price:

• Custom price for entire group
• Example: 89.99 for wholesale group

Optional Fields

Priority:

• Same as customer prices
• Use higher priority for group prices that should override customer prices
• Example: Set group priority=25 to override customer priority=20

From Date / To Date:

• Same behavior as customer prices
• Schedule group pricing campaigns

Website:

• Same as customer prices
• Regional group pricing

Price Application Type:

• Same options as customer prices

Step 4: Save and Verify

Save and test with a customer in that group.

Creating Quantity Tiers

To create graduated pricing (bulk discounts), add multiple price entries with different quantities:

Example: Wholesale Customer Group Tiers

1. Tier 1 - Small orders

   • Category: Electronics
   • Group: Wholesale
   • Qty: 1
   • Price: 100.00
   • Priority: 10

2. Tier 2 - Medium orders

   • Category: Electronics
   • Group: Wholesale
   • Qty: 10
   • Price: 95.00
   • Priority: 10

3. Tier 3 - Large orders

   • Category: Electronics
   • Group: Wholesale
   • Qty: 50
   • Price: 90.00
   • Priority: 10

4. Tier 4 - Bulk orders

   • Category: Electronics
   • Group: Wholesale
   • Qty: 100
   • Price: 85.00
   • Priority: 10

When a wholesale customer orders 75 items from Electronics, they get the $90 price (Tier 3).

Creating Time-Based Pricing

Schedule prices for specific date ranges:

Example: Seasonal Campaign

Summer Sale (June-August):

• Category: Outdoor Furniture
• Group: General
• Qty: 1
• Price: 199.99
• Priority: 20 (higher than standard pricing)
• From Date: 2025-06-01
• To Date: 2025-08-31
• Website: All Websites

This price activates automatically on June 1st and expires after August 31st.

Priority System in Action

Scenario: Conflict Resolution

Setup:

1. Customer "John Doe" is in "Wholesale" group
2. Create customer price: John + Electronics + Qty 1 + $95 + Priority 10
3. Create group price: Wholesale + Electronics + Qty 1 + $90 + Priority 20

Result:

• Group price wins (priority 20 >10)
• John pays $90

Configuration Override

Navigate to: Stores >Configuration > Pricesystem > Categoryprice Settings > Price Select Rule

• Select by priority - Use priority field (default)
• Customer price first - Always prefer customer prices (ignores priority)
• Group price first - Always prefer group prices (ignores priority)

Change this setting to control global behavior.

Bulk Product Coverage

Understanding the Efficiency

Traditional Product Pricing:

• Category "Electronics" has 500 products
• Set custom price on 500 products individually
• Total entries: 500

Category Pricing:

• Category "Electronics" has 500 products
• Set custom price on 1 category
• Total entries: 1

New Products Auto-Inherit

When you add a new product to a category that has category pricing:

1. Product is assigned to category
2. Product automatically inherits category price
3. No manual price entry needed

This is the key advantage for growing catalogs.

Common Workflows

Workflow 1: VIP Customer

Goal: Give customer #12345 special pricing on Premium Products category

1. Navigate to Catalog >Category Prices > Customer Prices
2. Click Add New
3. Category: Premium Products
4. Customer: Search "12345" or name
5. Qty: 1
6. Price: 299.99
7. Priority: 30 (high priority for VIP)
8. Save

Workflow 2: Wholesale Group Discounts

Goal: 15% discount for wholesale customers on all categories

For each major category:

1. Navigate to Catalog >Category Prices > Customer Group Prices
2. Click Add New
3. Category: [Category Name]
4. Group: Wholesale
5. Qty: 1
6. Price Application Type: Discount
7. Price: 15 (15% off)
8. Priority: 15
9. Save

Repeat for all categories or use Import/Export add-on for bulk.

Workflow 3: Promotional Campaign

Goal: Black Friday sale on all categories for all customers

For each category:

1. Navigate to Catalog >Category Prices > Customer Group Prices
2. Click Add New
3. Category: [Category Name]
4. Group: General
5. Qty: 1
6. Price: [Discounted price]
7. Priority: 25
8. From Date: 2025-11-29
9. To Date: 2025-12-02
10. Save

Prices activate automatically on Black Friday and expire after Cyber Monday.

Grid Management

Filtering

Use grid filters to find prices:

• Filter by Category
• Filter by Customer/Group
• Filter by Date Range
• Filter by Website
• Filter by Priority

Mass Actions

Select multiple rows and:

• Delete selected prices
• Export selected to CSV (with Import/Export add-on)

Inline Editing

Click directly on cells to quick-edit:

• Priority
• Price
• Dates

CSV Export (For Customers)

If enabled in configuration, customers can download their prices:

Customer Dashboard >My Prices > Download CSV

CSV contains:

• Category names
• Quantities
• Prices
• Date ranges
• Websites

This helps customers track their custom pricing agreements.

Troubleshooting

Price Not Showing

Check:

1. Date range valid? (from_date ≤ today ≤ to_date)
2. Website matches? (customer on correct website)
3. Customer logged in? (for customer-specific prices)
4. Customer in correct group? (for group prices)
5. Product in correct category?
6. Cache cleared? (Flush Magento cache)

Wrong Price Applied

Check:

1. Priority system configuration
2. Multiple conflicting prices? (check priority values)
3. Product has product-specific price? (might override category price)
4. Pricesystem Core price resolution order

Can't Save Price

Check:

1. All required fields filled?
2. Date format correct?
3. Category exists?
4. Customer/Group exists?
5. Website ID valid?
6. Admin permissions?

Next Steps

• Category Customer Pricing Details
• Category Group Pricing Details
• Priority System Configuration
• Import/Export Guide