Creating Customer Prices
Overview
Learn how to create your first customer-specific price assignments in the admin panel.
Step-by-Step Guide
1. Navigate to Customer Prices
Go to: Catalog >Customer Prices
2. Click "Add New"
Click the "Add New" button in the top right corner.
3. Fill in Required Fields
Customer
Select the customer from the dropdown. You can search by name or email.
Required: Yes
Product
Search and select the product. Enter product name, SKU, or ID.
Required: Yes Note: Only simple and virtual products are supported. For configurable products, set prices on child products.
Quantity
The minimum quantity for this price tier.
Required: Yes Default: 1
Price Value
The customer-specific price for this product.
Required: Yes Format: Decimal (e.g., 99.99)
Website
Select which website this price applies to.
Options:
- All Websites (ID: 0) - Price applies globally
- Specific Website - Price applies only to selected website
Default: 0 (All Websites)
4. Optional Fields
From Date
Start date for time-based pricing. Leave empty for immediate activation.
Format: YYYY-MM-DD
To Date
End date for time-based pricing. Leave empty for no expiration.
Format: YYYY-MM-DD
Price Application Type
How the price should be applied (configured in Pricesystem Core).
Default: 1 (Replace)
Price Attribute ID
Optional custom price attribute reference for advanced configurations.
5. Save
Click "Save" to create the customer price.
Example: Basic Customer Price
Scenario: Customer "ACME Corp" gets $95 for Product "Widget ABC" (normally $100)
Customer: ACME Corp (customer_id: 123) Product: Widget ABC (SKU: WGT-ABC) Quantity: 1 Price: 95.00 Website: All Websites From Date: (empty) To Date: (empty)Example: Quantity Tier Pricing
Scenario: Customer "Beta Ltd" gets volume discounts
Create multiple entries:
Entry 1: - Customer: Beta Ltd - Product: Widget ABC - Quantity: 1 - Price: 100.00 Entry 2: - Customer: Beta Ltd - Product: Widget ABC - Quantity: 10 - Price: 95.00 Entry 3: - Customer: Beta Ltd - Product: Widget ABC - Quantity: 50 - Price: 90.00The system automatically applies the best price based on cart quantity.
Example: Promotional Price
Scenario: Q1 2025 promotion for specific customer
Customer: Gamma Inc Product: Widget ABC Quantity: 1 Price: 85.00 From Date: 2025-01-01 To Date: 2025-03-31 Website: All WebsitesPrice activates automatically on January 1st and expires on March 31st.
Validation
The system validates:
- Uniqueness: No duplicate entries with same customer + product + qty + dates + website
- Customer Exists: Customer ID must be valid
- Product Exists: Product ID must be valid
- Price Format: Must be valid decimal
- Date Logic: to_date must be after from_date (if both set)