Skip to main content

Zoho Books - Data Mapping & Synchronisation

This page will allow you to know the information we map and when from your integration.

Carla Domingos avatar
Written by Carla Domingos
Updated this week

Simple

In the simplest (1st flavour) form of the integration, we map only these elements:

Entity

Sync FROM -> TO

Frequency

Products

ZohoBooks > OP

updated hourly

Sell Orders

ZohoBooks > OP

updated hourly

Full

In the complete (2nd flavour) form of the integration, we map the elements below:

Entity

Sync FROM -> TO

Frequency

Products

ZohoBooks > OP

updated hourly

Suppliers

ZohoBooks > OP

updated hourly

Supplier Products

ZohoBooks > OP

updated hourly

Sell Orders

ZohoBooks > OP

updated hourly

Buy Orders Import

ZohoBooks > OP

updated hourly

Buy Orders Export

OP > ZohoBooks

every 15min

Features

Zoho Region: The Region of the company registered in Zoho

Sync_Stock : The customer can decide to not to sync product stock by having this flag set to False.

Warehouse_ids : If the customer has multiple warehouse sources and wants to only get stock from some, they may select only specific warehouses from Zoho Inventory by clearly stating the warehouse id’s pretended separated by commas. Furthermore, each id should be numerical.

To request these features, please reach out to our customer support team


Products

Optiply

Zoho Books

name

name

skuCode

sku

price

rate

remoteId

item_id

status

If product_type = goods AND status = active

Then optiply.status = enabled

Otherwise optiply.status = disabled

stockLevel (*1)

available_for_sale_stock

UnlimitedStock

if product_type = digital or product_type = service or product_type = digital service
Then “true”
else “false”

createdAtRemote

created_time

Stock can either be pulled as the sum of all warehouses, or select only specific warehouses


Suppliers

Optiply

Zoho Books

name

vendor_name

email

email

remoteId

contact_id

Supplier Products

Optiply

Zoho Books

name

name

skuCode

sku

price

purchase_rate

supplierId

vendor_id

productId

item_id


Sell Orders

Optiply

Zoho Books

totalValue

total

placed

date

remoteId

salesorder_id

If pull all sell orders is set to false, only orders with the status “invoiced”, “partially invoiced” and “closed” will be synced

Possibility to Exclude Sell Orders based on Salesperson ID: If the customer has multiple sources and wants to exclude a couple of sales channels to avoid data duplication, they may exclude all those sales orders from Zoho Books by clearly stating the salesperson id’s.

For example, if a client wants to skip all orders from Amazon with the salesperson Id saved as AMZN and Walmart with the salesperson Id saved as WLMT, the field should be filled AMZN,WLMT.

Sell Order Lines

Optiply

Zoho Books

productId

line_items.item_id

quantity

line_items.quantity

subtotalValue

line_items.rate * line_items.quantity

sellorder_id

salesorder_id

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


Buy Orders Zoho > OP

Optiply

Zoho Books

supplierId

vendor_id

placed

date

completed

Timestamp when order_status became closed

expectedDeliveryDate

expected_delivery_date

remoteId

purchaseorder_id

totalValue

total * exchange_rate

Buy Order Lines

Optiply

Zoho Books

productId

line_items.item_id

quantity

line_items.quantity

subtotalValue

line_items.quantity * line_items.rate * exchange_rate

buyOrderId

purchaseorder_id


Buy Order Optiply > Zoho

Optiply

Zoho Books

supplier.remoteId

vendor_id

Buy Order Lines Optiply > Zoho

Optiply

Zoho Books

optiplyBuyOrderId

reference_number

product.remoteId

item_id

quantity

quantity

Did this answer your question?