Back to Templates
AUTOMATION LOGIC
Dynamic Pricing Rules Engine
A logic matrix to define automated price adjustments based on triggers like inventory and time.
LIVE PREVIEW
| Rule ID | Trigger Condition | Threshold | Action | Max Adjustment Cap | Priority |
|---|---|---|---|---|---|
| RULE-01 | Inventory Level | < 10 Units | Increase Price +10% | +20% | 1 (High) |
| RULE-02 | Competitor Price | < My Price | Match Price | -15% Floor | 2 (Med) |
| RULE-03 | Time of Day | 18:00 - 22:00 | Increase Price +5% | +10% | 3 (Low) |
| -- | -- | -- | -- | -- | -- |
| -- | -- | -- | -- | -- | -- |
Instructions
- 1Set Floors: Always define a minimum price (floor) to protect margin.
- 2Prioritize: If two rules conflict (Low Inventory but Low Competitor Price), which wins?
- 3Test: Dry run rules on historical data before going live.
Pro Tip
You can import the downloaded CSV directly into Google Sheets, Excel, or Airtable. The formatting is universal.
About this Template
Map out your algorithmic pricing strategy before you code it.
Key Features
Trigger Logic: If-This-Then-That.
Safety Caps: Prevent runaway pricing.
Common Use Cases
Ecommerce: Stock-based pricing.
Ride Sharing: Surge logic.
Frequently Asked Questions
What is a 'Floor'?
The absolute minimum price you will accept.