Combine an Excel cost file with Shopee to see real profit per product
Shopee gives you revenue, fees and returns, but it does not know what you paid for your stock. Without cost of goods there is no profit. The fastest fix is to keep a cost table by SKU in an Excel file and upload it next to your Shopee connection. DataxLand joins cost to every order line by product code and computes cost of goods sold, contribution margin and profit after ads for each product, and it tells you how much of your revenue still has no cost so you can fill the gaps. The file can also carry packaging costs or monthly fixed costs if you want.
Free plan with no time limit · No card required · Sample workspace ready in minutes
Why combine
- Without cost of goods, every profit report is just revenue minus fees; a best-selling product may be losing money.
- Purchase prices change by batch; Excel lets you record cost over time so each month's profit is more accurate.
- COGS coverage tells you how much of the profit figure you can trust before you base a decision on it.
Metrics you only get by combining
| Metric | How it is computed |
|---|---|
| Cost of goods sold | Units sold × cost per SKU in the Excel fileUses the cost in effect on the order date when the file records cost over time. |
| Contribution margin | Net revenue − cost of goods − marketplace fees − payment fees − seller-paid shipping |
| COGS coverage | Order line revenue with a known cost ÷ total order line revenueBelow 100% means some SKUs have no cost yet; Si lists those SKUs. |
| Net profit after fees and ads | Contribution margin − allocated ad spendAd spend comes from Shopee's daily ads stream. |
Standard metrics from the analytics packs
Once both sources map to the same model, these metrics run on the joined data with one definition.
| Metric | Definition | Unit |
|---|---|---|
| Cost of goods sold | Quantity times unit cost on the order date (half-open validity interval). SKUs without a cost count as 0; see COGS coverage. Returned lines do not reverse their COGS. | Currency |
| COGS coverage | Share of line revenue (after discounts) coming from SKUs that have a cost. Below 100% means the profit metrics are overstated.= line_net_with_cost / line_net_total | Ratio (%) |
| 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 |
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
Questions you can answer
| Question | Shopee only | Excel + Shopee combined |
|---|---|---|
| Which SKUs sell best? | Yes | Yes |
| Which SKUs lose money after fees? | Cost unknown | Contribution margin per SKU |
| How far can I trust the profit figure? | Cannot be measured | COGS coverage |
| Profit after marketplace ads? | Cost unknown | Net profit after fees and ads |
Steps
- 1
Connect Shopee
Click Connect with Shopee, sign in to your seller account and grant read access; no password to paste.
- 2
Upload the Excel file
Upload an .xlsx file: one sheet per table, column names in the first row, plus a data_dictionary sheet describing each column.
- 3
Review Si's mapping
Si proposes how the SKU column in the file matches Shopee product codes and asks about codes that do not match; you approve.
- 4
Build and read the dashboards
The Products and P&L overview dashboards show profit per SKU and COGS coverage; upload the file again when purchase prices change.
Frequently asked questions
Which columns does the cost file need?
At minimum the SKU code and the unit cost. Add an effective date if cost changes by batch. A data_dictionary sheet describing each column helps Si get it right the first time.
How do I update costs?
Upload the new file; the next build uses the new costs. If you want costs to update on a schedule, keep the cost table in Google Sheets instead of Excel.
Which plan can combine two sources?
The Free plan accepts a single Excel file. Combining two or more sources needs the Starter plan (up to 3 sources) or above; see pricing for the number of sources and the refresh schedule of each plan.
Dashboard templates that use this source
Connect Excel →Connect Shopee →Ask Si about your Excel data →Ask Si about your Shopee data →
Other combinations
- Combine Excel orders with Facebook Ads for shops that sell through a fan page
- Combine Freshdesk with Shopee to manage customer support by order
- Combine Shopee with Facebook Ads to see your blended ROAS
- Combine Shopee with Lazada to manage profit across both marketplaces in one place
- Combine TikTok Shop with Shopee to compare real profit across both marketplaces
Combine Excel and Shopee in minutes
Free plan with no time limit · No card required · Sample workspace ready in minutes