How aditipokale1/dynamic-pricing-ecom works
This is an end-to-end e-commerce dynamic-pricing workflow: synthetic SKU, traffic, price, sales, and inventory data feed SKU–segment–day features; a demand model and pricing rules evaluate candidate prices for expected profit; recommendations carry audit reason codes and feed run summaries and dashboard exports. The SQLite database is the shared state layer. The README documents the larger pipeline and dashboard capabilities; source excerpts show feature construction, guardrail behavior, recommendation orchestration, and summary aggregation. Some generator-to-generator and export wiring is not shown, so those links are omitted or cited as documented.
Main entry points: schema.sql Pricing database · run_pricing_job.py Recommendation job · build_features.py Feature builder · build_run_summary.py Run summary
Components 17
Data generation
- SKU dimensions
src/generate_dim_sku.py - Inventory facts
src/generate_fact_inventory.py - Traffic facts
src/generate_fact_traffic.py - Shown prices
src/generate_fact_prices_shown.py - Sales facts
src/generate_fact_sales.py - Pricing database
sql/schema.sql - Feature builder
src/build_features.py
Pricing workflow
- Demand model
src/run_pricing_job.py - Recommendation job
src/run_pricing_job.py - Pricing guardrails
src/pricing/rules.py - Profit objective
src/pricing/objective.py - Single-price demo
src/pricing/demo_recommend_one_price.py
Monitoring and reporting
- Run summary
src/build_run_summary.py - Dashboard exports
src/export_for_dashboard.py - Logged-price comparison
src/export_reco_vs_logged.py - Power BI dashboard
dashboards/exports/DynamicPricing_Ecom.pbix
Other components
- Workflow operator
Connections 27
- Workflow operator → SKU dimensions: runs
- Workflow operator → Inventory facts: runs
- Workflow operator → Traffic facts: runs
- Workflow operator → Shown prices: runs
- Workflow operator → Sales facts: runs
- Workflow operator → Feature builder: runs
- Workflow operator → Recommendation job: runs
- Workflow operator → Run summary: runs
- SKU dimensions → Pricing database: writes dimensions
- Inventory facts → Pricing database: writes facts
src/generate_fact_inventory.py - Traffic facts → Pricing database: writes facts
src/generate_fact_traffic.py - Shown prices → Pricing database: writes prices
src/generate_fact_prices_shown.py - Sales facts → Pricing database: writes sales
src/generate_fact_sales.py - Pricing database → Feature builder: provides joined rows
src/build_features.py - Feature builder → Pricing database: writes features
src/build_features.py - Pricing database → Recommendation job: supplies pricing inputs
src/run_pricing_job.py - Recommendation job → Demand model: trains and predicts
src/run_pricing_job.py - Recommendation job → Pricing guardrails: applies rules
src/run_pricing_job.py - Recommendation job → Profit objective: scores profit
src/run_pricing_job.py - Recommendation job → Pricing database: stores recommendations
README.md - Single-price demo → Pricing guardrails: applies rules
src/pricing/demo_recommend_one_price.py - Single-price demo → Profit objective: scores profit
src/pricing/demo_recommend_one_price.py - Pricing database → Run summary: reads recommendations
src/build_run_summary.py - Run summary → Pricing database: writes aggregates
src/build_run_summary.py - Pricing database → Dashboard exports: provides monitoring data
README.md - Dashboard exports → Power BI dashboard: feeds dashboard
README.md - Pricing database → Logged-price comparison: provides comparison data
README.md