Case · E-commerce
From a price war to automated profit protection.
An algorithmic system that watches margin against purchase prices and competitors on price-comparison sites in real time.
Model case: we assume the company looks like this and show how much it would yield.
- Model case
- Make
- Apify
- Supabase
- Shoptet
Starting point
Manual price changes in Excel
Every morning the pricing manager opens Heureka, compares prices with 8 competitors and goes back to Excel. Changing prices on 1 200 products takes 3 hours. By then the competition has pulled its prices back.
- Before
Excel and Heureka in the browser
MANUAL PROCESS
- After
Automatic prices
AUTOMATION
What we would build
Pricing system
Competitor monitoring, margin check, price proposal, approval, upload to Shoptet.
- 01
Trigger
Every 30 min
- 02
Data collection
Apify and Heureka data
- 03
Rule
Margin guard + AI
- 04
Upload
Update in Shoptet
- Apify · Pulling data from websites
- Make · Connecting the steps
- Supabase · Price history
- Shoptet · E-shop
Rollout steps
How the rollout would go.
- 01
DAY 01 to 02
Competitor mapping
Picking the 8 main competitors and setting up automatic collection of their prices.
- 02
DAY 03 to 04
Margin rules
Setting the minimum margin, wildcard products and discount rules.
if (margin < min) → keep_price();
- 03
DAY 05 to 07
Approval
A Slack notification for the pricing manager. Approve with one click, or reject.
Model assumptions
Where the result comes from.
We take a typical company from the sector and the situation from the brief, add labelled assumptions and calculate the result. If the inputs change, so does the result, so you can recalculate it for your own company.
Model company
A model e-shop with 1 200 products. The pricing manager compares prices with 8 competitors every day and rewrites them in Excel.
Inputs
- Range
- 1 200 products
- Competitors tracked
- 8
- Manual price changes
- 3 h a day, 5 days a week
- Labor rate (assumption)
- 24 EUR / h
- Monthly revenue (assumption)
- 200,000 EUR
- Average margin (assumption)
- 20 % today, 23 % with the guard
Calculation step by step
- 01
Time on manual changes per week
3 h × 5 days= 15 h
- 02
Time per year
15 h × 52 weeks= 780 h
- 03
Cost of that time per year
780 h × 24 EUR= 18,720 EUR
- 04
Gross profit per month today
200,000 EUR × 20 %= 40,000 EUR
- 05
Gross profit per month with the guard
200,000 EUR × 23 %= 46,000 EUR
- 06
Gross profit increase
46,000 EUR ÷ 40,000 EUR= +15 % (+6,000 EUR a month)
This is a gross saving of time and money. We include the cost of rollout and running only where it is visible in the calculation.
Model results
What would change after rollout.
- Model case
+15 %
Gross profit increase at a margin of 20 % → 23 % and revenue of 200,000 EUR a month
Profit
- Model case
−15 h/week
3 h a day × 5 days. The pricing manager does strategy, not CTRL+C
Time
Your numbers belong in the model, not ours. The calculator shows where to start, and we work out the real values on your data.
Start here
15 minutes is enough for you to know whether it makes sense.
You tell us what is bothering you. We tell you whether we can help, roughly what it costs and where I would start in your place. No presentation.
- jakub@transformuj.ai
- Phone
- +420 773 070 090
- Address
- Legerova 1820/39, Praha 2