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 | itemid |
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 |
lotSize | ????? |
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 |
We will only sync transactions with: recordtype=”SalesOrd”
Buy Orders - Netsuite to Optiply
Optiply | Netsuite |
remoteID | id |
totalValue | absolut (foreigntotal) |
placed | createddate |
completed | closedate |
expectedDeliveryDate | duedate |
optiplySupplierRemoteID | entity |
We will only sync transactions with: type=”PurchOrd”
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”
Receipt Lines - Netsuite to Optiply
Optiply | Netsuite |
quantity | quantity |
occurred | linecreateddate |
remoteID | uniquekey |