Skip to main content

NetSuite Data Mapping & Syncronization

Detailed information on what is mapped from Netsuite

Carla Domingos avatar
Written by Carla Domingos
Updated over a week ago

This page will allow you to know the information we map and when from your integration.

Synchronisation General Board

This is an overview of what and when we synchronise data.

Entity

Sync FROM > TO

Frequency (in min)

Products

Netsuite > OP

60

Product Compositions

Netsuite > OP

60

Suppliers

Netsuite > OP

60

Supplier Products

Netsuite > OP

60

Supplier Products Deletions

Netsuite > OP

60

Stocks

Netsuite > OP

60

Buy Orders

Netsuite > OP

60

OP > Netsuite

10

Sell Orders

Netsuite > OP

60

Receipt Lines (Item Deliveries)

Netsuite > OP

60


Mapping Information

Now we show the specifics of how we map data for each entity.

Products

Optiply

Netsuite

remoteId

Id

name

fullname

skuCode

custitem_cl_sku

articleCode

vendorname

price

Inventory_Item_Locations.price

eanCode

upccode

stockLevel (*)

quantityavailable

status

If custitem_cl_item_status = “Prepare” THEN “disabled”

Otherwise “enabled”

createdAtRemote

createddate

notBeingBought

If custitem_cl_item_status in ["Ending","Ending (Supplier)","Offline / Order Item"] THEN “true”

Otherwise “false”

assembled

If custitem_cl_item_status = "Warranty/Part" THEN “true”

Otherwise “false”

We will only sync Items where: itemtype=”InvtPart”

(*) The customer can decide if we should sync stock from AllWarehouses or a specific list of Warehouses (Locations)


Suppliers

Optiply

Netsuite

name

companyname

remoteId

Id

fixedCosts

custentity_cl_shipping_amount

leadTime

custentity_cl_lead_time

We will only sync suppliers when: Vendors status is Active=true.

Supplier Products

/item_vendor

Optiply

Netsuite

name

item.fullname

remoteId

Concat(item + vendor)

price

purchaseprice

articleCode

vendorcode

status

“enabled”

minimumPurchaseQuantity

item.reordermultiple

deliveryTime

item.leadtime

preferred

preferredvendor


Sell Orders

Optiply

Netsuite

totalValue

foreigntotal

remoteID

id

placed

createddate

completed

closedate

We will only sync transactions with: type=”SalesOrd”

Sell Order Lines

Optiply

Netsuite

optiplyWebshopProductArticleCode

item

quantity

absolut(quantity)

subtotalValue

absolut(netamount)

remoteId

uniquekey


Buy Orders - Netsuite to Optiply

Optiply

Netsuite

remoteID

id

totalValue

absolut (foreigntotal)

placed

createddate

completed

If status in [

"Purchase Order : Fully Billed",

"Purchase Order : Pending Bill",

"Purchase Order : Closed"

] THEN completed = lastmodifieddate

expectedDeliveryDate

duedate

optiplySupplierRemoteID

entity

We will only sync transactions with: type=”PurchOrd”

Options and features

BuyOrders - Send buyOrders to a specific locationId in Netsuite

An option that allows a customer to define "locationId" to where we send the buyOrders when posting them from Optiply to Netsuite.

(send_locationId default null)

It is not possible to change this option in your app. Please report to our Customer Support if you want to set it up.

Buy Order Lines - Netsuite to Optiply

Optiply

Netsuite

optiplyWebshopProductRemoteID

item

quantity

absolut(quantity)

subtotalValue

absolut(netamount)

remoteID

uniquekey

expectedDeliveryDate

duedate

We will only sync transactions with: recordtype=”PurchOrd”


Buy Orders - Optiply to Netsuite

Optiply

Netsuite

optiplyBuyOrderId

otherrefnum

optiplySupplierId

vendor.id

placed

tranDate

expectedDeliveryTime

dueDate

Buy Order Lines - Optiply to Netsuite

Optiply

Netsuite

optiplyWebshopProductId

item.id

quantity

quantity

subtotalValue / quantity

UnitPrice


Receipt Lines - Netsuite to Optiply

Optiply

Netsuite

quantity

quantity

occurred

linecreateddate

remoteID

uniquekey

Did this answer your question?