Skip to main content

​
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 FieldBetter Data FieldNotes
items.itemidexternalIdSKU key for catalog import
items.displaynamenameOptional catalog display name
inventorybalance.itemlevels[].skuIdInventory SKU
locations.namelevels[].locationIdExternal location code
inventorybalance.quantityonhandlevels[].quantityOnHandAbsolute stock
inventorybalance.quantityavailablelevels[].quantityReservedUsually derive as onHand - available
vendors.entityidsuppliers[].externalIdSupplier key
transaction.tranidpurchaseOrders[].externalPoNumberPO number
transactionline.itempurchaseOrders[].lines[].skuIdPO line SKU
transactionline.quantitypurchaseOrders[].lines[].quantityPO line quantity
transactionline.ratepurchaseOrders[].lines[].unitCostPO 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 }
      ]
    }
  ]
}