Optiply Help Center

All CollectionsIntegrationsEasyEcom

EasyEcom Data Mapping and Syncronization

EasyEcom Data Mapping and Syncronization

Here you can see how we map your data and when

Written by Carla Domingos

Updated this week

Synchronisation General Board

Entity	*Sync FROM* -> TO**	Frequency (min)
Products	EasyEcom > OP	every 30 minutes
Product Deletions	EasyEcom > OP	Not available at this moment
Suppliers	EasyEcom > OP	every 30 minutes
SupplierProducts	EasyEcom > OP	every 30 minutes
Sell Orders	EasyEcom > OP	every 30 minutes
Buy Orders	EasyEcom > OP	every 30 minutes
OP > EasyEcom	every 10 minutes
Receipt Lines	EasyEcom > OP	every 30 minutes

Mapping Information

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

Products

Optiply	EasyEcom
name	`product_name`
skuCode	`sku`
price	`cost`
unlimitedStock	False
stockLevel	`inventory`
assembled	If `cp_sub_products_count`>0 THEN `True`Else `False`
status	`active`
remoteID	`cp_id`
articleCode	`product_id`
createdAtRemote	`created_at`

Product Compositions

Optiply	EasyEcom
remoteId	`cp_id`
composedproductid	`cp_id`
partQuantity	`sub_products.quantity`
partproductid	`sub_products.cpId`
createdAtRemote	`created_at`

Suppliers

Optiply	EasyEcom
name	`vendor_name`
remoteId	`vendor_code`

Sell Orders

Optiply	EasyEcom
totalValue	`total_amount`
placed	`order_date`
remoteId	`order_id`

We do not sync Order changes in any way, order line changes, line deletions or new lines added to existing Orders will not be updated in Optiply.

By default, we will map all status Sell Orders except Canceled (id=9)

Sell Order Lines

Optiply	EasyEcom
productId	`suborders.sku`
quantity	`suborders.item_quantity`
subtotalValue	`suborders.selling_price`
remote_id	`suborders.suborder_id`

Buy Orders (EasyEcom> OP)

Optiply	EasyEcom
Id	id
supplier id	supplier_name > get the Id from the name
placed	created
remoteId	id
completed	DateNow

Orders will be set to completed when the status is completed

Buy Order Lines

Optiply	EasyEcom
productId	`po_items.original_quantity`
quantity	`po_items.original_quantity`
subtotalValue	`po_items.item_price`*`po_items.original_quantity`
buyOrderId	`po_id`
remoteId	`po_items.purchase_order_detail_id`

Buy Orders (OP > EasyEcom)

Optiply	EasyEcom
Id	`referenceCode`
supplier_remoteId	`vendorId`
product.article_code	`items.sku`
product.quantity	`items.quantity`
	`items.unitPrice`
created_at	`expDeliveryDate`
“I”	`createOrUpdate`

Receipt Lines

Optiply	EasyEcom
quantity	`grn_items.received_quantity`
occurred	`grn_created_at`
buyOrderLineId	`grn_items.purchase_order_detail_id`
remoteId	`grn_items.grn_detail_id`