Skip to content
+

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

MetricHow it is computed
Cost of goods soldUnits sold × cost per SKU in the Excel fileUses the cost in effect on the order date when the file records cost over time.
Contribution marginNet revenue − cost of goods − marketplace fees − payment fees − seller-paid shipping
COGS coverageOrder 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 adsContribution 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.

MetricDefinitionUnit
Cost of goods soldQuantity 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 coverageShare 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_totalRatio (%)
Contribution marginNet 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 costCurrency
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency

Questions you can answer

QuestionShopee onlyExcel + Shopee combined
Which SKUs sell best?YesYes
Which SKUs lose money after fees?Cost unknownContribution margin per SKU
How far can I trust the profit figure?Cannot be measuredCOGS coverage
Profit after marketplace ads?Cost unknownNet profit after fees and ads

Steps

  1. 1

    Connect Shopee

    Click Connect with Shopee, sign in to your seller account and grant read access; no password to paste.

  2. 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. 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. 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 and Shopee in minutes

Free plan with no time limit · No card required · Sample workspace ready in minutes