How to Analyze Shopee and Lazada Order Exports

If you sell in Singapore or Malaysia, there's a good chance you run a Shopee store and a Lazada store side by side. Both Seller Centres have dashboards, but each one only sees its own half of your business, the two define their numbers differently, and neither answers the questions you actually care about: how much did both stores sell together last month, which SKUs make money after vouchers and fees, and how many buyers come back?

The order exports answer those questions. This guide covers how to get them, what's in each file, the structural traps that inflate totals, and the questions worth asking once the data is loaded. Amounts are in RM (Malaysia); read S$ if you sell on the Singapore sites.

Getting the exports

Menu names change from time to time and differ between the English and Chinese interfaces, so treat these paths as a guide; if yours looks different, look for the Export button on the orders page.

Shopee: In Seller Centre, go to Orders → My Orders, pick the order status (usually All) and a date range, then click Export. The report is generated in the background; download it from the export history, usually as an Excel file. The date range you can pick at once is limited, so for a full year export month by month or quarter by quarter and stack the files.

Lazada: In Seller Center, go to Orders → Manage Orders, filter by date or status, then Export all orders or the current filter. You'll get an Excel or CSV file.

Platform fees are usually not in the order export. Commission, transaction and service fees live in the finance side: on Shopee under My Income, where you can view and download income reports, and on Lazada under Finance, in the account statements and transaction details. If you want net payout, export that report too.

What's in the Shopee export

Dozens of columns. The ones that matter for analysis (names are from the English interface and vary a little by site and version; money columns often carry the currency, like (MYR)):

What's in the Lazada export

Also dozens of columns, mostly in camelCase: orderNumber, orderItemId, status (delivered, canceled, returned and others), createTime, itemName, variation, sellerSku, unitPrice, sellerDiscountTotal, platformDiscountTotal and paidPrice.

The trap: a row is not an order

This is where most wrong numbers come from, and the two platforms differ.

Shopee: one row per product line. An order with three different products is three rows sharing one Order ID. Order-level fields such as Grand Total, platform vouchers and shipping may repeat on every row of the same order. Summing Grand Total down the column counts multi-item orders two or three times.

Lazada: typically one row per unit. In the common export format there is no quantity column. Buy three of the same item and you get three rows, each with its own orderItemId. Units sold is a row count, not a sum of a quantity column.

Before calculating anything, find an order with several items in your own file and look at how many rows it takes and which columns repeat. Then:

• Order count = distinct Order ID / orderNumber, never the row count.
• Merchandise sales = sum of Product Subtotal on Shopee; sum of unitPrice or paidPrice on Lazada, depending on whether you want before or after discounts.
• Order-level money (totals, shipping, platform vouchers) = de-duplicate by order first, then sum. The techniques in finding duplicates in Excel apply.

Vouchers, rebates and shipping

Every order has at least three prices: list, deal and what the buyer paid. The gaps are funded by different parties:

• Seller-funded discounts (seller vouchers, shop discounts, bundle deals you fund) reduce your revenue.
• Platform-funded discounts (Shopee vouchers and rebates, Lazada platform discounts) lower what the buyer pays but are generally made up to you by the platform, so they don't reduce your revenue.
• Shipping is partly paid by buyers and partly absorbed by you. Keep it out of merchandise sales and track it separately.

Pick one definition of GMV and stick to it. A common one is deal price × quantity, before platform vouchers, with seller-funded discounts reported as their own line.

Returns and cancellations

Cancelled and unpaid orders never produced revenue; exclude them from GMV. Returns and refunds show up in Return / Refund Status on Shopee and in status on Lazada. Partial returns affect only the returned line, so handle them at row level. Report two numbers every month: ordered GMV (cancellations excluded) and net sales (returns also removed). The gap between them is worth watching on its own.

Five questions worth asking

1. GMV by month, both platforms in a stacked bar chart. Campaign months such as 6.6, 9.9, 11.11 and 12.12 usually stand out.
2. Top SKUs by units and by revenue. They're rarely the same list: cheap traffic drivers top the units ranking, while profit items top revenue.
3. Repeat buyers. Group by buyer, count distinct orders, and count buyers with two or more. Shopee has Username (Buyer); Lazada buyer details may be masked or limited in the export, so treat repeat analysis there with caution.
4. Net payout. Using the income or finance report: merchandise sales minus seller-funded discounts minus platform fees, by month. Reconcile against what actually landed in your bank account.
5. Return rate by product, units returned ÷ units sold. Outliers often point to sizing, description or quality issues.

For margin by SKU, keep a two-column cost sheet (SKU, unit cost) and bring the cost onto each order row with XLOOKUP. Map SKU spellings first if the two platforms use different codes for the same product.

Doing it in Excel

1. Standardize both files to the same columns: date, platform, order ID, SKU, product, quantity, amount, status, buyer.
2. Set quantity to 1 on every Lazada row; use Quantity for Shopee.
3. Add a month column with =TEXT(date,"yyyy-mm").
4. Stack the two tables and build a pivot: month in Rows, platform in Columns, amount in Values, cancelled status filtered out. The pivot table tutorial walks through each step.
5. Don't add S$ and RM together. Convert to one currency first.

Asking ChatExcel instead

That workflow has to be repeated every month. Alternatively, upload both exports to ChatExcel and ask in plain language (English or Chinese both work). It reads every sheet and computes answers from the whole file. State the structure once, for example "Shopee rows are product lines and order-level amounts repeat per row; Lazada rows are single units with no quantity column; GMV means merchandise value excluding cancelled orders", and it carries that through the conversation. You can ask for charts or sortable tables, ask for the Excel formula behind a number, download results, or get a merged, cleaned Excel file of both platforms. Next month, add the new exports to the same chat and compare. ChatExcel is paid only, from $29/month on Plus, with no free plan.

Two sanity checks

Before you share a number, check that one month's distinct order count and sales roughly match the Seller Centre dashboard for the same period. If they're far off, you're almost certainly summing order-level amounts across repeated rows or including cancelled orders.