NetSuite Connector - Better Data

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 }
      ]
    }
  ]
}