The Complete Guide to Celigo Amazon NetSuite Integration App (2026): FBA Flows & Settlement Reconciliation

Scaling an Amazon channel while running Oracle NetSuite as your central Enterprise Resource Planning (ERP) engine creates immediate operational bottlenecks if managed manually. When transaction volume grows past $5M in Gross Merchandise Value (GMV), exporting Seller Central CSV reports, updating Merchant Fulfilled Network (MFN) tracking numbers, and manually posting Amazon FBA settlement reports into your general ledger destroys profitability.

Manual data entry causes fulfillment delays, triggers stock-outs that damage your Inventory Performance Index (IPI) score, and exposes your financial ledger to audit risk. The Celigo Amazon NetSuite Integration App acts as an automated central nervous system, bridging Amazon Selling Partner API (SP-API) endpoints with NetSuite SuiteTalk web services. Built on Celigo’s integrator.io iPaaS platform, this enterprise integration app automates multi-channel order routing, real-time inventory allocation, FBA inbound logistics, and multi-currency financial settlements.

1. Celigo Amazon Integration App Tier Architecture

Celigo categorizes the Amazon NetSuite Integration App into three pre-built editions based on operational flow complexity and financial automation requirements:

2. Enterprise FBA Logistics: The FBA Inventory Management Bundle

Brands relying heavily on Fulfillment by Amazon (FBA) cannot operate on standard MFN order-routing logic alone. Managing stock across external 3PL networks and Amazon Fulfillment Centers requires specialized inventory transfer and reconciliation protocols.

Celigo offers a dedicated FBA Inventory Management Add-On Bundle that unlocks three critical operational flows:

3. Financial Accounting Mechanics: Automated Settlement Reconciliation

Reconciling Amazon bi-weekly settlement reports is notoriously difficult. Amazon payouts contain thousands of line items representing gross sales, principal refunds, FBA fulfillment fees, referral commission fees, storage surcharges, and inbound placement fees.

The Celigo Premium Edition automates the entire settlement reconciliation loop via a 4-step financial pipeline:

Node.js Pre-Save Hook: Custom FBA vs. MFN Order Routing

When importing Amazon orders into NetSuite, enterprise configurations must route FBA orders to an FBA virtual warehouse location while directing MFN orders to your primary 3PL facility. Celigo enables developers to inject Node.js pre-save scripts to modify incoming payloads dynamically:

// Node.js Pre-Save Script inside Celigo integrator.io
function preSavePage (options) {
  options.data.forEach(function (order) {
    // Check fulfillment channel attribute from Amazon SP-API payload
    if (order.FulfillmentChannel === 'AFN') {
      // Amazon Fulfilled Network (FBA)
      order.custbody_ns_order_type = 'Amazon FBA Order';
      order.location = 205; // NetSuite FBA Virtual Warehouse Internal ID
      order.order_status = 'Pending Fulfillment';
    } else if (order.FulfillmentChannel === 'MFN') {
      // Merchant Fulfilled Network (MFN/FBM)
      order.custbody_ns_order_type = 'Amazon MFN Order';
      order.location = 101; // NetSuite Primary 3PL Facility Internal ID
      order.order_status = 'Pending Approval';
    }

    // Apply custom memo for audit tracking
    order.memo = 'Imported via Celigo Amazon-NetSuite Integration App (SP-API)';
  });

  return {
    data: options.data,
    errors: options.errors
  };
}

4. Multi-Region Global Marketplace Architecture

Brands selling across international Amazon marketplaces (e.g., Amazon US, Amazon UK, Amazon Germany, Amazon Japan) do not need separate ERP instances. Celigo supports connecting multiple global Amazon accounts into a single NetSuite tenant.

5. Enterprise TCO & Managed Support Governance

Budgeting for the Celigo Amazon NetSuite Integration App requires evaluating both recurring platform licensing and initial implementation fees:

Frequently Asked Questions