Global Price List Rules

Price List calculator

Overview

The Price List Rule calculator is a powerful pricing engine that enables businesses to define and manage global pricing rules for their products. By configuring a price list, users can establish structured pricing strategies that are automatically applied across multiple products. This feature ensures consistency, flexibility, and efficiency in pricing management, making it easier to scale pricing decisions across diverse product catalogs and customer segments.

Key Benefits

  • Pricing Control: Manage product prices within a price list.

  • Rule-Based Adjustments: Apply global rules to automatically calculate selling prices.

  • Increased Efficiency: Reduce the manual effort involved in updating prices individually.

  • Flexible Pricing Strategies: Configure rules based on markups, discounts, or fixed margins.

How It Works

Each Price List serves as a container for a set of pricing rules associated with products. The system applies defined rules to calculate Selling Prices for each item on a Price List automatically once a day. This allows pricing to be consistently enforced across entire price catalogs. The calculation for each Price List product starts with its cheapest cost price, rules are applied in sequential order from top to bottom.

Types of Rules Supported

Price lists support a variety of global rules, including:

  • Percentage Markup on Cost Price Example: Add 25% markup to all base product costs.

  • Fixed Amount Additions Example: Add R50 to the base cost of every item.

  • Discount from Recommended Retail Price (RRP) Example: Apply a 10% discount on the standard retail price.

  • Fixed Amount Subtractions Example: Subtract R50 from the base cost of every item.

Each rule is applied sequentially and cumulatively, ensuring accurate and predictable pricing outcomes.

Setup Process

  1. Create a New Price List

    • Navigate to the Price List section.

    • Select Create New Price List.

    • Name the Price List, Enable it and select its default type.

    • Save your new Price List.

  2. Import Price List

    • Export products from OrderEazi needed on your new Price List.

    • Click on the import button, top right on the Price List page, and pull through your products.

  3. Define Global Rules

    • Add pricing rules in the table below in the sequence of application.

    • You may view how your rules will be applied by adding a value to the test column.

    • Save your Price List Rules.

  4. Activate Price List

    • Once fully setup you may immediately apply your Price List Rules by clicking the Run Rules Now button. This may take a minute.

    • Upon completion Selling Prices for each Price List item will be calculated. Note that if a product has no cost price its resulting Selling Price will always be zero.

    • A Price Lists Rules are automatically applied daily.

Use Cases

  • Wholesale Pricing: Set a separate price list for wholesale clients with bulk discounts.

  • Regional Pricing: Apply different pricing structures based on geographic regions.

  • Promotional Campaigns: Create time-based price lists for sales events or promotions.

  • Cost-Sensitive Markets: Automatically adjust prices based on fluctuating cost inputs.

Best Practices

  • Test Before Going Live: Use the test values column to validate rules and preview pricing results.

  • Keep Rules Simple and Clear: Complex pricing chains can be hard to maintain; opt for clarity.

Troubleshooting

  • Prices Not Updating?

    • Ensure you have saved your rules.

  • Unexpected Price Outputs?

    • Review the order of rule execution.

    • Check for overlapping or conflicting rules.

Conclusion

The Price List Rules feature streamlines pricing management and empowers businesses to implement consistent, rule-driven pricing across their products. Whether you're adjusting prices in response to market shifts or maintaining customer-specific rates, this tool helps ensure accuracy, transparency, and efficiency.

Last updated