Precios dinámicos
It automates optimal price calculations by balancing key needs: strategy-based pricing, profit margin limits via markups, market trend responses through competitor assessment, and consumer appeal via psychological rounding
David Škarka
Autor de la plantilla
- Purpose: Acts as the initial data retrieval step.
- Function: It fetches product attributes from the Product Catalogue based on the EAN code and identifies if a product is a Key Value Item (KVI) or has an active Promotion.
- Key Tables:
- Product Catalogue: Stores basic info like name and category.
- Key Value Items: Explicitly flags high-priority items.
- Promotions: Sets individual promoted prices with time validation.
- Purpose: Analyzes the competitive landscape to inform pricing.
- Function: It filters competition data by product name and calculates critical aggregates: Minimum, Maximum, Average, and Median for both base and promotional prices.
- Aggregator: aggregateCompetition assigns node transforms raw lists into actionable statistical values.
- Purpose: Determines the specific logic used to calculate the "rough" price.
- Function: Based on product category or input flags, it selects one of eight available strategies.
- Example Strategies:
- Cost-plus: Sets price based on total cost plus a predefined margin.
- Relative positioning: Follows competitor prices, adjusting them up or down by a percentage.
- Competition Matching: Aligns the price directly with competitive offers.
- Goal/Stock/Change Oriented: Adjusts prices based on sales performance and inventory levels.
- Purpose: Ensures the calculated price does not fall below a sustainable threshold.
- Function: Specifically for KVIs, it compares the strategy-calculated price against the warehouse total cost plus a minimum markup. It outputs the higher of the two values to protect margins.
- Purpose: Performs "smart rounding" to create consumer-attractive prices.
- Function: This script-based rule finds the highest price near the target that ends in a favored digit (e.g., .99, .95) without exceeding an acceptable price reduction threshold (e.g., 10% below the rough price).
- Start: Receives initial product and warehouse data.
- Product Prep: Runs Get Product to define KVI and promotion status.
- Market Analysis: Runs Competition Assessment to get median market prices.
- Pricing Strategy: Runs Choose Strategy to calculate the base target price.
- Margin Check: Applies Markup Limiting to ensure the price stays above the cost floor.
- Optimization: Applies Generate Prices for psychological rounding.
- End: Outputs the final optimized price and the strategy used to reach it.
Más plantillas
Ver otras plantillas
Automatización de las reclamaciones de indemnización
Automatice la gestión integral de las reclamaciones de indemnización por accidentes laborales mediante el análisis de informes médicos basado en inteligencia artificial: extraiga los datos clínicos que necesite y tome automáticamente todas las decisiones posteriores.
Pruebas A/B
Descubra una forma sencilla de asignar un grupo de prueba para realizar pruebas A/B en sus decisiones.
Precios basados en el riesgo
Descubra una forma sencilla de aplicar una matriz de precios basada en riesgo adecuada en función del tipo de cliente.
blog
