NetSuite for E-Commerce: the advanced architecture for smooth operations at scale

Marketplace payouts            Connector / SuiteScript           NetSuite GL
(Shopify, Amazon, Walmart) ──>  (split fees, tax, discounts) ──>  (mapped accounts + bank rec)

Fulfillment / delivery event ──>  ARM ──>  Revenue recognition plan ──>  Deferred revenue released

Navigating the payout maze

Each marketplace treats fees, reserves, and withholding differently. The connector layer normalizes them; ARM recognizes the revenue correctly.

• Shopify. Gross sales, discounts, collected sales tax, and Shopify Payments fees split to their respective GL accounts and reconcile to the deposit.
• Amazon FBA. Rolling reserves, FBA fulfillment fees, storage fees, and promotional coupons are accounted for, with revenue recognized when the product ships to the consumer rather than when Amazon releases cash weeks later.
• Walmart Marketplace. Fee structures and return withholdings map to the corresponding cost accounts, preserving gross-margin clarity across channels.

Costing methods

NetSuite supports Average (moving weighted average, the default), FIFO, LIFO, and Standard costing, plus Group Average, Lot, and Specific for serial- or lot-tracked goods.

• FIFO (First-In, First-Out). Suits fast-moving or perishable goods, matching the oldest costs against current revenue first.
• Weighted average. For brands with frequent but moderate cost shifts, NetSuite recalculates the average unit cost on each receipt, smoothing short-term volatility into a stable cost base for daily margin analysis.
• Standard, Group Average, Lot, and Specific. Standard costing for predictable manufacturing variance analysis; Group Average, Lot, and Specific for serial- or lot-tracked goods.

True landed cost allocation

A product does not cost what the factory charges. True viability requires rolling all secondary costs into the asset value. NetSuite tracks and capitalizes:

• Ocean and air freight
• Customs duties, tariffs, and clearing fees
• Inland trucking and terminal handling

On receipt, NetSuite allocates these landed costs across items by weight, volume, or value. When the item later sells on Shopify, the COGS recognized is the true landed cost, so gross-profit metrics hold up.

1. 1

   Data extraction and cleanse

   Strip historical transactional bloat and normalize master data (vendors, customers, clean SKU maps).

2. 2

   Trial balance mapping

   Migrate historical financials as clean, verified summary journal entries rather than importing millions of individual historical orders.

3. 3

   Parallel testing

   Run NetSuite alongside the legacy system to confirm that SuiteScripts, FreeMarker templates, and revenue recognition behave exactly as expected before go-live.

This is what keeps the transition on budget and on timeline: nothing goes live until it has matched real-world output in parallel.