Skip to main content

Vendit - Data Mapping & synchronisation

Vendit Syncronization & Data Mapping

Carla Domingos avatar
Written by Carla Domingos
Updated today


​Synchronisation General Board

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

Entity

Sync FROM -> TO

Frequency (min)

Products

Vendit > OP

60

Suppliers

Vendit > OP

60

SupplierProducts

Vendit > OP

60

Sell Orders

Vendit > OP

60

Buy Orders

OP > Vendit

10

Vendit > OP

60

Receipt Lines (Item Deliveries)

Vendit > OP

60


Products

Optiply

Vendit

name

productDescription

skuCode

productSearchCode

eanCode

productNumber

articleCode

productGui

price

salesPrices

unlimitedStock

useStock

stockLevel

GetChangedStockFromDate.availableStock

notBeingBought

  • if salesVisibilityId=2 and free_stock>0 THEN notBeingBought=true

status

  • if salesVisibilityId=1 THEN status='enabled'

  • if salesVisibilityId=2 and free_stock>0 THEN status='enabled' and notBeingBought=true

  • else disabled

remoteId

productId


Suppliers

Optiply

Vendit

name

supplierName

remoteId

supplierId

emails

supplierEmail

deliveryTime

deliveryDays

Supplier Products

Optiply

Vendit

name

supplierProductNumber

supplierId

supplierId

productId

productId

price

purchasePriceEx

preferred

preferredDefaultSupplier

remoteId

productSupplierId

deliveryTime

expectedArrivalDatetime

minimumPurchaseQuantity

minOrderQuantity


Sell Orders

Optiply

Vendit

totalValue

totalPriceIncVat

remoteId

saleHeaderId

placed

transactionDatetime

Sell Order Lines

Optiply

Vendit

quantity

productQuantity

sellOrderId

saleHeaderId

productId

productId

subTotalValue

productTotalSalesPriceInc

remoteId

saleDetailId


Buy Orders - Optiply to Vendit

Vendit API only allows to create PrePurchaseOrders, and a PrePurchaseOrder is basically a buyOrderLine. So for any buyOrder created in Optiply, we will send the buyOrderLines to Vendit as PrePurchaeOrders with our buyOrderId (sent as optiplyId).

From there, customer will transform them into the final PurchaseOrder.

Buy Order Lines - Optiply to Vendit

Optiply

Vendit

optiplyBuyOrderId

optiplyId

quantity

amount

optiplyWebshopProductId

productId

created_at

creationDatetime

Buy Orders - Vendit to Optiply

Optiply

Vendit

remoteId

purchaseOrderNumber

supplierId

supplierId

placed

orderDatetime

totalValue

sum of lines Amount

expectedDeliveryDate

orderExpectedDeliveryDate

completed

historyPurchaseOrder.deliveryDateTime

Buy Order Lines - Vendit to Optiply

Optiply

Vendit

quantity

amount

subTotalValue

amount * purchasePriceEx

buyorderId

purchaseOrderNumber

productId

productId

remoteId

purchaseOrderNumber_productId

expectedDeliveryDate

expectedDeliveryDate

Receipt Lines - Vendit to Optiply

Optiply

Vendit

quantity

amountDelivered

occured

deliveryDatetime

remoteID

productPurchaseHeaderId


Options and features

SellOrders - Sync only SalesOrders from specific warehouseIds

An option that allows a customer to set a specific list of warehouseIds from where we should get the salesOrders.

It is not possible to change this option in our FE, please report to our CustomerSupport.

Did this answer your question?