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 |
|
eanCode | upccode |
stockLevel (*) | quantityavailable |
status | If Otherwise “enabled” |
createdAtRemote | createddate |
notBeingBought | If Otherwise “false” |
assembled | If 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
|
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 |