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 Then Otherwise |
stockLevel (*1) |
|
UnlimitedStock | if |
createdAtRemote |
|
Stock can either be pulled as the sum of all warehouses, or select only specific warehouses
Suppliers
Optiply | Zoho Books |
name | vendor_name |
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 |