Before you compare NetSuite fields

Identify the entity, direction and NetSuite environment you want to compare. Check which flows, locations and custom mappings your setup owner selected. Use NetSuite setup for access and connection instructions.

Steps to compare NetSuite fields

  1. Find the entity and direction in the tables below.
  2. Match the NetSuite source identifier to the corresponding Optiply record.
  3. Check the applicable location, status, price and date conditions below that table.
  4. Compare a complete order and its lines rather than matching a field name alone.
  5. Ask your setup owner to confirm any custom mapping or synchronization timing before investigating a mismatch.

Fields in NetSuite product and stock imports

These are the standard field correspondences. Custom product and supplier mappings can replace their standard inputs.

Optiply fieldNetSuite source or rule
remoteIdItem id.
namefullname.
skuCodecustitem_cl_sku.
articleCodevendorname.
eanCodeupccode.
createdAtRemotecreateddate.
stockLevelSum of inventory_item_locations.quantityavailable for the selected locations, rounded to whole units.
priceActive item_prices.price, restricted by filter_product_pricelevel when configured, rounded to two decimals.
statusWith custitem_cl_item_status, code 5 disables the product. Other codes enable it.
notBeingBoughtWith custitem_cl_item_status, codes 1, 3, 7 or 8 set this to true.
assembledCode 4 sets this to true. A matched composition also marks its parent assembled.

Only item types InvtPart and Kit enter the product import. When the custom status field is absent, isinactive supplies the enabled/disabled status.

Stock uses available quantity, not quantity on hand. If several active prices remain eligible, this mapping does not define a price-level priority; confirm the selected price level. stock_location_ids selects locations. Without a location selection, all supplied locations contribute. The stock calculation retains earlier location values between updates.

Product compositions — NetSuite to Optiply

Optiply fieldNetSuite source
remoteIdkit_item_members.id.
composedProductIdparentitem, matched to the imported parent product.
partProductIditem, matched to the imported component.
partQuantityquantity, with a minimum of one.

Both products must resolve before the composition can be imported.

Fields in NetSuite supplier imports

Optiply fieldNetSuite source
remoteIdVendor id.
namecompanyname.
fixedCostscustentity_cl_shipping_amount.
deliveryTimecustentity_cl_lead_time, rounded to whole days and capped at 365. Zero is omitted.
userReplenishmentPeriodcustentity_reorder_period, rounded to whole days. Zero is omitted.

Supplier products — NetSuite to Optiply

Optiply fieldNetSuite source or rule
remoteIditem + _ + vendor.
productId / supplierIdItem and vendor matched to imported Optiply records.
nameItem fullname.
articleCodevendorcode.
pricepurchaseprice, rounded to two decimals.
lotSizereordermultiple, rounded to whole units with a minimum of one.
deliveryTimeleadtime, rounded to whole days and capped at 365. Values of one or less are omitted.
preferredpreferredvendor.

Supplier-product import is controlled by sync_supplier_products. The default is enabled. The item-vendor pair identifies the relationship, not the vendor's article code. The standard input does not supply supplier-product SKU or free stock values.

Fields in NetSuite sales imports

Sell orders — NetSuite to Optiply

Optiply fieldNetSuite source
remoteIdSales order id.
totalValueforeigntotal.
placedcreateddate.
completedclosedate on the newly imported order.

Sales transactions use type SalesOrd. Orders whose tranid starts with b2b, ignoring letter case, are excluded. New orders need usable matched product lines. Existing sales orders and their lines are not updated by this import.

Sell order lines — NetSuite to Optiply

Optiply fieldNetSuite source or rule
productIditem, matched to the imported product.
quantityAbsolute value of quantity, rounded to whole units.
subtotalValueAbsolute value of netamount, rounded to two decimals.

uniquekey identifies the incoming sales line during preparation. Lines enter a new order together with its header. The outgoing nested line contains product, quantity and subtotal, not that source line identifier.

Fields in NetSuite purchase imports

Buy orders — NetSuite to Optiply

Optiply fieldNetSuite source or rule
remoteIdPurchase order id.
supplierIdentity, matched to the imported supplier.
totalValueAbsolute value of foreigntotal.
placedcreateddate.
expectedDeliveryDateduedate.
completedlastmodifieddate for Purchase Order : Pending Bill, Purchase Order : Fully Billed or Purchase Order : Closed.

Purchase transactions use type PurchOrd. The completion rule ignores letter case and surrounding spaces. Other statuses leave completion empty.

otherrefnum helps match orders created in Optiply. It is not a separate reference field sent when creating an imported buy order.

Buy order lines — NetSuite to Optiply

Optiply fieldNetSuite source or rule
remoteIdtransaction + _ + item.
buyOrderIdtransaction, matched to the imported purchase order.
productIditem, matched to the imported product.
quantityAbsolute value of quantity, rounded to whole units.
subtotalValueAbsolute value of netamount, rounded to two decimals.
expectedDeliveryDateduedate.

The purchase-order and item pair identifies the line. Repeated rows for that same pair do not become separate Optiply lines through their NetSuite uniquekey values.

Receipt lines — NetSuite to Optiply

Optiply fieldNetSuite source or rule
remoteIdItem receipt line uniquekey.
buyOrderLineIdcreatedfrom + _ + item, matched to the imported purchase line.
quantityAbsolute value of quantity, rounded to whole units. New receipts need a positive quantity.
occurredImport processing time in the standard mapping.

linecreateddate is prepared as a date called placed, not the receipt's occurred value. Do not use occurred from this mapping as the physical receipt time.

Fields in NetSuite purchase exports

The purchase export prepares these fields for the NetSuite purchase-order connection. Confirm the selected connection with your setup owner before comparing its destination fields.

Optiply valuePrepared export fieldNetSuite correspondence
Buy order IDpurchaseOrderNumber, externalId, descriptionTransaction number, external ID and memo.
Supplier source IDvendorIdMatched vendor entity.id.
placedissueDatetranDate.
Expected delivery datedueDatedueDate.
Product source IDlineItems.itemIdMatched item reference.
Line quantitylineItems.quantityquantity.
Line subtotal divided by quantitylineItems.unitPricerate, rounded to two decimals during preparation.
Configured locationlineItems.locationIdMatched location when configured.

The export groups lines by the original buy order ID. Optional price-export or tax configuration can change which prepared price fields are included. Ask the setup owner which configuration applies. Do not use this table as a resend instruction.

What you see when NetSuite field comparison worked

You can match the selected record and explain its stock, identity, amount and date using the correct entity and direction. Check actual transferred records separately from the Connected label.

Limits of comparing NetSuite fields

Enabled flows, custom fields, selected locations and run timing belong to your connection configuration. A schedule is not fixed by a mapping table.

Purchase-order updates apply to orders that are still open in the imported snapshot. Receipt lines are added, not updated. Missing records in a later input do not by themselves mean that Optiply deletes the corresponding records.

Whole-unit quantities and two-decimal amounts can differ from unrounded NetSuite values. Purchase-line identity differs from receipt identity. Sales updates and receipt timestamps follow the limits described above.

If NetSuite field comparison did not work

First compare the entity, direction, source identifier and configured location or price level. Check that linked parent records exist for compositions, supplier products and order lines.

For a remaining mismatch, use the setup guide to reach the connection owner with the field name and non-sensitive record reference. For a missing exported order, use the original-order check below. Do not retry an export merely because a field differs.