Edit Formula
Build your formula by adding parts below
×
⚡ Smart Shortcuts — click to auto-build
Use shortcuts above or add parts manually below ↓
Or build manually
To convert % to decimal: divide by 100
Common patterns: Math.ceil(mrpRaw/50)*50 · Math.round(sellerPrice) · Math.max(0, commPct-incentive)
Live Preview
Cost ₹
Markup %
Discount %
Incentive %
Result of this formula:
×
⚠ You'll be logged out in 5:00 due to inactivity.
Dashboard
Total SKUs
0
Across all brands
Active Brands
0
Threshold Breaches
0
Not ignored
Commission Models
3
Myntra · PPMP · CC
Profit by Brand & Commission Model
BrandMarketplaceModelSKUsAvg CommissionAvg Net Profit (₹)Status
GST: 5% if SP < ₹2,500 · 18% if SP ≥ ₹2,500. Ajio CC = commission only.
Myntra
Ajio — PPMP
Ajio — CC
Amazon
Structure
Live Calculator
Category Profit Thresholds
Alert when Net Profit in ₹ drops below this amount for any SKU
Set minimum profit in Rupees (₹). Example: Set ₹500 for Lehenga Choli — any SKU earning less than ₹500 net profit triggers a daily alert.
⚠ Active Breaches
Alert Settings
Not configured — alerts will log to console only
Myntra (Category + Slab)
Ajio (PPMP & CC)
Amazon (Fixed %)
Myntra charges by category + selling price slab. Set the level per category for logistics, edit commission cells, and Save.
Commission % — Category × Price Slab × Level
Myntra
Ajio (PPMP only)
Amazon
🟢 Forward (GT Charges)
Level0–12–99100–300300–500500–10001000–2000>2000 ★
★ Most common column (SP > ₹2000). All values editable — changes auto-save to database.
🔴 Return (Reverse Fees)
LevelReturn Fee (₹)
Filters:
+ Add Row
Auto-fill: Select Brand → Category (Myntra auto-sets Level) → fill Cost & Markup → MRP / SP / GST / Commission % / Net Profit ₹ all compute live. Icons: ⚠️ Breach   🔕 Ignored   Healthy
Img Style ID Brand / Model Category Level (Myntra) Cost ₹ Markup % MRP ↗ SP ↗ GST ↗ Comm % ↗ Net Profit ₹ ↗ Status / Act
Wireframe Builder
Define calculation rows per marketplace
Add row:
🔗 Fetch from tables:
+ Add row:
Variables available in expressions:
cost · markup · mrp · discount · custPaid · gtCharge · sellerPrice · gstRate
taxableAmt · tcs · tds · commPct · effCommPct · commAmt · gstOnComm
retFee · collFee · pgFee · retProv · payout · profit · incentive · retPct
Functions: getMynFwd(level, sp) · getMyntraComm(cat, sp) · autoGST(sp) · Math.round() · Math.ceil()
Row Types
INPUT→ User enters a number (cost, markup, discount)
FORMULA→ Math expression you define (click ✎ Edit Formula)
OUTPUT→ Final result shown vs threshold
LOOKUP → Auto-fetched from live tables — GT charges, commission %, reverse fees, collection fee
How LOOKUP works:
🔗 GT Forward Charges — reads from Logistics → GT Charges table using Customer Paid price band
🔗 Reverse Charges — reads from Logistics → Reverse Fees table using SKU level
🔗 Commission % — reads from Commission Settings using category × seller price slab
🔗 Collection Fee — reads from Logistics settings (fixed ₹61 by default)
If Myntra changes a rate — update it in Logistics or Commission Settings. The wireframe fetches automatically.
🔒→ Protected row — cannot be deleted
🔍 Agentic Bug Detector
Runs every formula, checks for errors, validates results
User Access
Control who can view and edit pricing data.
NameEmailRoleAddedAction
📧 Email Settings (EmailJS)
Paste your keys from emailjs.com — no code editing needed
🧪 Test Emails
Sent when a new user is added
Sent on password reset
Sent on threshold breach
☁ Database (Supabase)
Cloud sync across all devices
✓ Connected — all data saves automatically.
ℹ App Info & Data
Versionv6.0
SKUs
Brands
Users
Data size