Tmall + NetSuite Integration

Your finance team reconciles Tmall orders, Alipay settlements, and promo credits against NetSuite using exports. Weeks pass before you see real P&L.

Oracle ERP Expertise CertifiedTransparent PricingPost Go-Live Support

Tmall logo

The Problem

Alipay settlements in RMB, variable fees, and promo deductions all need to reconcile in NetSuite before you see margins.

The financial complexity is the real challenge. Alipay settlements arrive in RMB with commissions and platform fees already deducted. Singles' Day and Double 12 generate thousands of orders overnight. Manual reconciliation can't keep up, and you won't know how much China contributes to your bottom line until weeks after the fact.

When a Tmall + NetSuite Integration Becomes the Better Fit

ALIPAY SETTLEMENTS POST AS A SINGLE NET NUMBER

Finance books the deposit as revenue, then tries to back into commissions and fees at month-end. Gross revenue, net revenue, and marketplace costs end up mixed together.

EACH SETTLEMENT BREAKS DOWN INTO GROSS REVENUE AND FEES

Every Alipay settlement splits into gross order revenue, Tmall commission, technical service fees, and promotional subsidies — each posting to the correct GL account so margin reporting works from day one.

COMMISSION RATES LIVE IN A SPREADSHEET THAT'S ALWAYS SLIGHTLY WRONG

Your ops team maintains a spreadsheet of Tmall commission rates by category. When rates change or a new tier kicks in, a missed update means wrong cost allocation until someone catches it.

COMMISSION RULES CONFIGURED ONCE AND APPLIED AUTOMATICALLY

Category-level commission rates and fee structures live in the integration layer. Rate changes are updated once and applied going forward without touching NetSuite saved searches or rebuilding formulas.

SINGLES DAY ORDERS DON'T GET RECONCILED FOR WEEKS

Peak events generate thousands of orders in hours. Your team can't manually reconcile that volume in real time, so the China P&L is an estimate until someone clears the backlog.

HIGH-VOLUME EVENTS RUN THROUGH THE SAME AUTOMATED PIPELINE

Whether it's 50 orders or 5,000, settlements decompose and post to NetSuite at the same speed. Peak volume doesn't create a backlog.

TMALL REFUNDS DON'T CONNECT TO ORIGINAL ORDERS IN NETSUITE

Refunds appear in settlement reports as negative lines. Matching them to the original NetSuite sales order is manual detective work that often gets deferred or approximated.

REFUNDS CREATE CREDIT MEMOS LINKED TO THE ORIGINAL TRANSACTION

Each Tmall refund references the original order ID. The integration creates a credit memo in NetSuite linked to the original sales order, reversing revenue and commission on the correct line items.

CHINA REVENUE IS VISIBLE BUT PRODUCT MARGIN IS NOT

Without order-level cost data in NetSuite, you can report total China revenue but not margin by SKU. Tmall fees make some products far less attractive than the top line suggests.

SKU-LEVEL MARGIN FOR THE CHINA CHANNEL IN NETSUITE

Each order line carries the Tmall selling price, commission rate, and allocated fees. Combined with COGS already in NetSuite, you get gross margin by product without building a separate report.

RMB SETTLEMENTS GET CONVERTED MANUALLY AT MONTH-END RATES

Tmall revenue is in RMB but your consolidated books may be in USD, HKD, or SGD. Manual FX conversion at month-end rates means the variance gets absorbed and hoped away.

FX GAIN AND LOSS CALCULATED AND POSTED PER TRANSACTION

Orders record at the RMB transaction rate. Settlements record at the deposit rate. NetSuite calculates the FX impact between the two and posts it to the correct account automatically.

Tmall + NetSuite Integration

What We Need to Scope Tmall + NetSuite

These are the main factors that shape scope, timeline, and implementation approach.

STORE TYPE AND ENTITY MAPPING

Tmall domestic vs. Tmall Global (cross-border) determines subsidiary mapping and how duties, warehouse fees.

ALIPAY SETTLEMENTS AND FEES

Alipay payouts and Tmall commissions can post gross with separate fee entries or as net settlements. Your preference shapes reconciliation.

CAMPAIGN SPIKES AND LOGISTICS

Singles' Day and 618 create order surges needing high-throughput sync. Cainiao tracking may also feed shipping status back into NetSuite.

PRODUCT MASTERING AND REFUNDS

Product data can live in Tmall's backend or through a TP partner. Refunds via Tmall's dispute resolution need auto-reconciliation.

Crash illustration

We can then design an integration that covers the market-specific requirements cleanly.

Mattia

ONE Pacific built a custom wholesale portal powered by Workato, allowing distributors to enter order details on their own without involving our staff.

Mattia Lolli

Chief Operating Officer

D1 Milano

TMALL + NETSUITE

How the Integration Works

Alipay settlement files are parsed into gross revenue, Tmall commissions, and service fees before posting to NetSuite. RMB transactions record at transaction-date rates, and refunds are matched back to original order records.

Settlement Files Parsed Into Fee Components
Each Alipay settlement splits into gross revenue, commission, service fees, and subsidies. Each component routes to a distinct NetSuite GL account.
Commission Rules Applied per Category
Category-level commission rates are configured in the integration. When a settlement posts, the correct rate applies automatically per order line.
Orders and Refunds Linked by Reference ID
Each Tmall order ID carries through to NetSuite. Refunds reference the original order and generate a credit memo that reverses revenue at line level.
RMB Amounts and Conversion Rates Preserved
RMB amounts and the Alipay conversion rate are recorded in NetSuite. FX impact between transaction and settlement rates posts to the FX account.
SKU-Level Cost Data Attached to Order Lines
Each order line carries the Tmall price, commission rate, and fees. Combined with COGS in NetSuite, this enables gross margin reporting by product.

Most Tmall + NetSuite integrations are scoped in under two weeks and live within 8 to 12 weeks. Let's figure out yours.

More Ecommerce Integrations

Showing 6 of 34 Ecommerce Integrations

Tmall + NetSuite Integration

FAQ's

Cost depends heavily on whether you're integrating Tmall Global (cross-border) or domestic Tmall, since they have different API requirements and fee structures. You'll likely need custom development since there aren't pre-built Tmall connectors for NetSuite, plus you'll be handling Alipay settlements (with processing fees around 1% per transaction), Chinese tax invoicing (fapiao), and Tmall's category-specific commission rates that vary from 0.5% to 5%.

Cross-border sellers face additional complexity with bonded warehouse inventory tracking, real-time customs declaration requirements, Tmall's QR code tracking system for authentication, and their strict product approval process that requires unique SKU formatting. Integration challenges include adapting to Tmall's specific settlement cycles and data format requirements, which differ significantly from Western marketplaces.

Each Alipay settlement is decomposed into its component parts: gross order revenue, Tmall commission by category, technical service fees, promotional subsidies, and refund offsets. Each component posts to the correct GL account in NetSuite. The net amount matches the bank deposit, so your reconciliation is clean without manually splitting lump-sum deposits in a spreadsheet.

Plan for 8 to 12 weeks. The first two to three weeks cover scoping: mapping Tmall's settlement report structure to NetSuite GL accounts, defining commission and fee decomposition rules by product category, and configuring multi-currency handling for RMB settlements. Build and testing takes another six to eight weeks, including a parallel run where automated postings are validated against your existing manual reconciliation before cutover.

Alibaba is a B2B wholesale sourcing platform. An Alibaba integration focuses on purchase orders, supplier payments, and landed cost flowing into NetSuite's procurement side. Tmall is a B2C retail marketplace where you sell directly to Chinese consumers. The Tmall integration focuses on sales orders, revenue decomposition, Alipay settlements, and commission tracking on the revenue side of your NetSuite ledger. They are complementary but solve different problems.

It is designed for exactly that scenario. Peak promotional events produce order volumes 10 to 50 times higher than a normal day. The integration processes settlements at the same speed regardless of volume. There is no manual step that creates a bottleneck during peak events, so your China P&L stays current even when daily order counts spike into the thousands.

Yes. Tmall Global is the primary use case for international brands selling into China without a local entity. The integration handles the cross-border settlement flow where Alipay settles in RMB and your bank receives the converted amount. FX rates are tracked per settlement so your NetSuite records reflect the actual conversion, not a month-end approximation.

Commission rates are configured per product category in the integration layer. When an order settles, the integration calculates the commission and technical service fee for each line item and posts them as expense entries against the correct GL accounts. If Tmall changes a rate or you add a new category, the config updates in one place and applies to all future settlements.

Hero background

Ready to connect Tmall and NetSuite?

Our engineers will review your setup, map your systems, and, if it makes sense to move forward, provide a clearly scoped proposal. No pressure.