E-commerce
Connect Shopee to DataxLand
DataxLand's own Shopee connector reads your shop's orders, order lines, settlements (escrow), returns, products and daily ads through the Shopee Open Platform. You click "Connect with Shopee" and sign in to your seller account; no password or API key to paste. DataxLand then computes net revenue after vouchers and refunds, the real platform and payment fees from settlements, and profit after fees per product and ad campaign. Fees of orders not yet settled are flagged as provisional instead of being treated as final.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Shopee
- Find the SKUs that sell well on Shopee yet lose money after platform fees, seller-paid shipping and ads.
- Compare profit after fees on Shopee with TikTok Shop, Lazada and your website in one dashboard.
- Track return rate per product and get a Telegram or Slack alert when it crosses a threshold.
- Put the ad revenue Shopee reports next to the revenue you actually receive.
What data you get
Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.
| Stream (table) | Contents |
|---|---|
| orders | Orders with status, created and updated times, payment method, shop and platform vouchers. |
| order_items | Each order line (SKU, quantity, list and discounted price) for revenue and profit per product. |
| escrow_details | Settlement per order - amount received, fixed, service, payment and shipping fees. |
| returns | Return and refund requests, reasons and refunded amounts. |
| products | Products and variations (SKU), to join with your cost table. |
| ads_daily | Daily spend, impressions, clicks and the ad revenue Shopee reports. |
Connection details
| Sign-in method | Sign in with your account (OAuth), no password to paste |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Data read | orders, order_items, escrow_details, returns, products, ads_daily |
| Developer | DataxLand |
| License | MIT |
| Technical docs | Connector documentation ↗ |
Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.
Metrics computed from this source
Real definitions from the analytics packs; dashboards and Si share them.
| Metric | Definition | Unit |
|---|---|---|
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| GMV (gross merchandise value) | Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds). | Currency |
| Valid orders | Orders that were not cancelled (standard status other than cancelled). | Count |
| Marketplace fees | Marketplace commission and service fees, allocated to lines by line revenue. | Currency |
| Payment fees | Marketplace transaction fees and payment gateway fees, allocated to lines by line revenue. | Currency |
| Seller-paid shipping cost | Outbound shipping cost paid by the shop, allocated to lines by line revenue. | Currency |
| Contribution margin | Net revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return cost | Currency |
| Net profit after fees and ads | Net revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spend | Currency |
| Return rate | Returned orders divided by valid orders.= returned_orders / Valid orders | Ratio (%) |
| Provisional fee rate | Share of fees (marketplace, payment, shipping) not yet settled, which may still change.= provisional_fees / (Marketplace fees + Payment fees + Seller-paid shipping cost) | Ratio (%) |
| Ad spend | Total advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to. | Currency |
| Platform-reported ROAS | Ad-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spend | Number |
Connect Shopee in 3 steps
- 1
Connect with Shopee
In the workspace choose Add source → Shopee, click Connect with Shopee, sign in to your seller account and grant read access.
- 2
Choose data
Keep the six default streams and pick a start date (empty means the last 90 days). Buyer name, phone and address columns are marked for hashing.
- 3
Review and build
Si proposes a mapping to the standard retail model; you fix the highlighted parts, approve, build, then ask Si about profit by channel and product.
Limits and caveats
- Shopee data has no product cost; add a cost table from Excel or Google Sheets to get contribution margin. The cost coverage metric shows how much revenue already has a cost.
- The connection goes through DataxLand's app on the Shopee Open Platform. If the button is not yet open for your account, start with an Excel export from Seller Centre and switch later.
- Orders, returns and products load incrementally by update time; settlements come per period, so fees of recent orders may still be provisional.
- The Free plan takes Excel files only; marketplace connections need a paid plan.
Frequently asked questions
Can DataxLand see buyer details?
Personal-data columns are hashed on load and masked before they reach Si. No dashboard, API or MCP tool returns buyer personal data.
Where do platform fees come from?
From each order's settlement (escrow). Unsettled orders use provisional fees, flagged so you know the number is not final.
How often is data refreshed?
On the schedule you set within your plan, from monthly to hourly; 15 or 30 minutes only when every source of the workspace loads incrementally.
I have several Shopee shops.
Each shop is its own source in the workspace and counts toward your plan's source limit; dashboards combine or split by shop.
Dashboard templates that use this source
Connect Shopee and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes