API Connection
Not tested
Pricing Formula Reference
Auto-calculated price (no override needed)
Logistics =
16 AED/kg · min charge 500gMargin =
min(10% × (base + logistics), 20 AED)Final = base_AED + logistics + margin +
5% VATExample: ₹299, 150g
AED 13.16 + AED 8.00 + AED 2.12 + AED 1.16 = AED 25
⚠️ Override only when needed. Importing a custom price replaces the auto-formula for that product. Leave
custom_price_aed blank to use auto pricing. Each import row will delete then replace any existing override for that product_id.
Step 1 — Download Template
You need the product_id from your BigQuery products table
Field Reference — pricing_overrides table
| product_id | custom_price_aed | override_reason | set_by |
|---|---|---|---|
| p_1234567890 | 45.00 | Seasonal promotion | admin |
* = required · product_id comes from BQ products table · custom_price_aed = final price shown to customer in AED
Step 2 — Upload CSV or Excel
Drop pricing file here or click to browse
CSV and Excel supported
.csv.xlsx.xls