NetSuite Connector

Set up NetSuite import integration and field mapping.

Overview

Map NetSuite records into Better Data import payloads through your ETL layer. Start with catalog and suppliers, then add inventory and purchase orders.

Common Mapping

NetSuite Field	Better Data Field	Notes
items.itemid	externalId	SKU key for catalog import
items.displayname	name	Optional catalog display name
inventorybalance.item	levels[].skuId	Inventory SKU
locations.name	levels[].locationId	External location code
inventorybalance.quantityonhand	levels[].quantityOnHand	Absolute stock
inventorybalance.quantityavailable	levels[].quantityReserved	Usually derive as onHand - available
vendors.entityid	suppliers[].externalId	Supplier key
transaction.tranid	purchaseOrders[].externalPoNumber	PO number
transactionline.item	purchaseOrders[].lines[].skuId	PO line SKU
transactionline.quantity	purchaseOrders[].lines[].quantity	PO line quantity
transactionline.rate	purchaseOrders[].lines[].unitCost	PO line cost

Example Transformation Output

{
  "purchaseOrders": [
    {
      "externalPoNumber": "PO-100245",
      "supplierId": "SUP-ACME",
      "destinationLocationId": "DC-WEST",
      "status": "PENDING",
      "lines": [
        { "skuId": "SKU-001", "quantity": 500, "unitCost": 4.25 }
      ]
    }
  ]
}