Data foundation for multi-channel e-commerce brands
Updated
A data foundation is one database that holds every order, settlement and stock movement from every sales channel, under rules the business has agreed, so that every report gives the same number. Big Tre builds it for Thai e-commerce brands that sell on Shopee, Lazada, TikTok Shop, Shopify, LINE and in stores. It connects read-only to the systems the brand already uses and refreshes every day.
What it includes
| Part | What the brand gets |
|---|---|
| Written rules | A rulebook of how the business counts: which order statuses are sales, how cancelled and returned orders are treated, how sets and bundles split into items, which discounts the seller pays and which the platform pays. Each rule is confirmed with the team on real orders |
| Sales | Orders from every channel, de-duplicated, one row per item, daily |
| Settlements and fees | What each platform paid out, with commission, service, transaction and payment fees itemised, matched to the bank |
| Stock | One stock figure per SKU across channels, with returns, transfers, free gifts and set deductions handled the same way every time |
| Profit | Margin per SKU and per channel after fees, vouchers and returns. Cost of goods comes from the brand's own cost sheet or ERP |
| Dashboards | Sales, margin, stock cover and campaign results by channel |
| Reports | The weekly and monthly reports the team builds by hand, produced in the Google Sheets layout the team already uses |
| Alerts | Low stock before an oversell, counts that drift between channels, platform fee changes |
Why the rules come first
Most reporting projects fail on definitions, not software. When one report counts paid orders and another counts placed orders, both are correct and neither agrees. Big Tre writes each definition down once and applies it to every channel. A number that looks wrong can be traced to the rule that produced it.
How long it takes
| Phase | What is done | Typical timing |
|---|---|---|
| Rules and foundation | Systems connected, rules written and confirmed, first month reconciled | Weeks 1 to 6 |
| Dashboards and reports | Dashboards and the team's recurring reports, first produced by Big Tre | Weeks 1 to 6 |
| Automation | Alerts, reports sent on a schedule, every new payout matched automatically | Months 2 to 4 |
Each phase ends with something the team uses. The AI data analyst reads from the same foundation.
What it connects to
Order management systems (Zort and Shipnity today, BigSeller on request), marketplace settlement reports, Shopify, Google Sheets and Drive, and store POS. ERPs (Odoo, ERPNext, SAP Business One), accounting software (Express, PEAK, FlowAccount), ad accounts and carriers are connected when needed. Status of each is on integrations.
Where the data is kept
In Google Cloud (BigQuery) in the Singapore region, in a separate dataset per client. Big Tre reads from the client's systems and never writes to them.
Price
Setup from about 60,000 baht, then from about 14,000 baht a month to run it. See pricing.
Start with the free AI Readiness Health Check or write to hello@bigtre.business.