🔗 EasyEcom: Data Mapping & Synchronisation

This guide details the data flow between EasyEcom and Optiply. It outlines what data is synchronised, the frequency of updates, and the specific field mappings used for each entity.

⏱️ 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
Supplier Products	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

⚠️ Limitation: Product Deletions. Deleted products are not currently retrieved from EasyEcom API, so Optiply cannot identify or remove them automatically.

⚙️ Options and Features

Global - Add Tax Rate to Buy Price

Feature: Allows you to include the product's tax value in the buy price when exporting Buy Orders to EasyEcom.
Variable: send_tax_rate (Default: False).
Function: If enabled (True), the tax rate is grabbed from the product and added to the unitPrice before the order is sent to EasyEcom.

🗺️ Data Mapping Details

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

1. 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`

2. Product Compositions

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

Kits and Combos are mapped the same way as assembled products.

Deleted products are not retrieved from EasyEcom. So any products deleted from EasyEcom will not be updated or deleted from Optiply.

3. Suppliers

Optiply	EasyEcom
name	`vendor_name`
remoteId	`vendor_code`

Locations are also mapped as suppliers. Info is picked from products.company (name) and products.c_id (remoteId)

4. Supplier Products

Optiply	EasyEcom
name	`product_name`
remoteId	`cp_id`
skuCode	`sku`
eanCode	`product_id`
status	`active`
supplierId	`vendor_code`
price	`cost`

5. 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)

6. Sell Order Lines

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

7. Buy Orders (EasyEcom → OP)

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

The orders will be set to completed when po_status_id in [4, 5, 7]

8. 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`

9. Buy Orders (OP → EasyEcom)

Optiply	EasyEcom
product.article_code	`items.sku`
quantity	`items.quantity`
subTotalValue / quantity	`items.unitPrice`*

*unitPrice can include tax if the flag send_tax_rate=True.
tax_rate will be mapped from product and added to the unit price before exporting BuyOrders to EasyEcom.

10. 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`

❓ Frequently Asked Questions (FAQs)

Why can't I see deleted products?

The EasyEcom API does not currently provide a way to identify deleted products. Therefore, if you delete a product in EasyEcom, it will remain visible in Optiply. You may need to manually archive it in Optiply.

Are Kits and Combos supported?

Yes. Optiply identifies any product with sub-products (cp_sub_products_count > 0) as an "Assembled" product. This covers both Kits and Combos.

How fast is the sync?

Data flows from EasyEcom to Optiply every 30 minutes. Purchase Orders created in Optiply are exported to EasyEcom every 10 minutes.

Can I include tax in my Purchase Orders?

Yes. You can enable the send_tax_rate option. When active, Optiply calculates the tax based on the product settings and adds it to the unitPrice sent to EasyEcom.

EasyEcom Data Mapping and Synchronisation