Menu

Showroom Intelligence Dashboard • Powered by Dôr

Dashboard
7 showrooms ready to sync
Onboarding · Data Sync

Get MCM House data flowing into Dôr.

Three ways to sync — pick what fits your stack. Every feed you connect replaces modelled numbers with live showroom truth.

Step 1 · Pick your path

Three ways to connect

Tier 1

CSV Upload

The everyone-can-do-this option.

Best for: Pilot showrooms, manual POS exports

  • Drag & drop in browser
  • Pre-built MCM templates
  • Exact-header validation
  • Live row count + errors
Jump to CSV
Tier 2

Scheduled SFTP

Set it and forget it.

Best for: Nightly exports from your finance/BI team

  • Dedicated SFTP folder
  • S3 / GCS / Azure / Drive
  • 15-min ingest SLA
  • Email alerts on failure
Jump to Scheduled
Recommended
Tier 3

Direct API · Dôr

Real-time sync.

Best for: Dôr sensors + Shopify / Lightspeed / Cin7

  • Dôr sensor feed
  • Native POS connectors
  • Webhook ingest
  • 1,000 req/min
Jump to Direct

Step 2 · Track progress

Your live data coverage

Foot traffic…
Sales / POS…
SKU catalogue…
Showrooms live…
Day 0

Upload / connect

CSV, SFTP, or Dôr API handshake

Day 0–1

Validate & map

Dôr verifies columns and types

Day 1–3

Backfill 12 months

Historical showroom data ingested

Day 3

Dashboard live

Insights flowing in real time

No live rows yet — the dashboard is running on modelled figures.

Recent ingest activity

Nothing ingested yet.

Tier 1

CSV Upload

Drag, drop, done — works with any spreadsheet export.

Required columns

SKU file

sku_idproduct_namecategorycollectionpricecostlead_time_weeks

Sales file

transaction_idshowroom_idtimestampsku_idqtyunit_pricediscounttender_type

Optional · unlocks consultant leaderboard

consultantdelivery_suburb
v1 requires exact header match. Use showroom_id values matching the seven MCM House showrooms below.
mcm-house-armadalemcm-house-paddingtonmcm-house-balgowlahmcm-house-fortitudemcm-house-claremontmcm-house-byron-baymcm-house-noosa
Tier 2

Scheduled SFTP

Set it and forget it — we pull every hour, alerts on failure.

Register your drop location and we'll run every file through the same validator as browser uploads. Add an https drop URL (S3 / GCS pre-signed link, or an HTTPS mirror of the SFTP folder) so scheduled pulls can run automatically — the SFTP host details are stored alongside it for your ops team.

Connection details are stored server-side in Lovable Cloud and never exposed to the browser bundle.
Tier 3

Direct API · Dôr

Real-time sync via Dôr sensors and native POS connectors.

Recommended

Your Dôr team ID and API key are already stored as encrypted secrets — connect a source to start streaming.

Dôr Sensors
live
Shopify POS
live
Lightspeed Retail
live
Cin7 / Core
beta
Square
live
Xero
beta
NetSuite
Soon
Afterpay / Zip
Soon

Live ingest endpoint

POST sales, traffic or SKU rows here from Dôr, your POS or any middleware. Every accepted row lands in Lovable Cloud and the dashboard updates in real time.

POST /api/public/ingest?dataset=sales

x-api-key: —
curl -X POST "/api/public/ingest?dataset=sales" \
  -H "x-api-key: YOUR_INGEST_KEY" \
  -H "content-type: application/json" \
  -d '{"rows":[{"transaction_id":"T-1001","showroom_id":"mcm-house-armadale","timestamp":"2026-02-14","sku_id":"SOF-100","qty":1,"unit_price":5400,"discount":0,"tender_type":"Credit Card","category":"sofas_modulars"}]}'
Accepts JSON { rows: [...] }, JSON { csv: "..." }, or a raw CSV body.