This reference lists field mappings documented for this integration.
Important: Your enabled data flows and configuration can differ. Only the fields listed below are covered by this guide; other fields are not automatically implied to synchronise.
Read the mapping columns
The Optiply field column names the Optiply-side field in every table. The direction shown for a flow determines whether data moves into or out of Optiply; the other column gives the corresponding source field or documented transformation.
Synchronisation schedule and direction
The source labels separate Simple (1st Flavor) and Full (2nd Flavor) boards. Each listed row retains its source flavor; the cadence is not proof that a flow is enabled for an account.
Simple / 1st Flavor (Prod + SO)
Entity
Direction
Frequency / note
Products
ZohoBooks > OP
updated hourly
Sell Orders
ZohoBooks > OP
updated hourly
Full / 2nd Flavor (Prod + Supp + Supp Prods + SO + BO)
Entity
Direction
Frequency / note
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
Fields and columns
Product
Optiply field
Source field / expression
name
name
skuCode
sku
price
rate
remoteId
item_id
status
If product_type = goods AND status = active<br>Then optiply.status = enabled<br>Otherwise optiply.status = disabled
stockLevel
available_for_sale_stock
UnlimitedStock
if product_type = digital or product_type = service or product_type = digital service<br>Then “true”<br>else “false”
createdAtRemote
created_time
Product stockLevel is optional: the customer can choose whether it is mapped, and the documented default is to map it. This field-level choice is distinct from Sync_Stock, whose default is not stated; neither statement establishes your account’s setting.
Sell order
Optiply field
Source field / expression
totalValue
total
placed
date
remoteId
salesorder_id
Sell order line
Optiply field
Source field / expression
productId
line_items.item_id
quantity
line_items.quantity
subtotalValue
line_items.rate * line_items.quantity
sellorder_id
salesorder_id
Supplier
Optiply field
Source field / expression
name
vendor_name
email
email
remoteId
contact_id
Supplier product
Optiply field
Source field / expression
name
name
skuCode
sku
price
purchase_rate
supplierId
vendor_id
productId
item_id
Buy order (Zoho Books to Optiply)
Optiply field
Source field / expression
supplierId
vendor_id
placed
date
completed
Timestamp when order_status became closed
expectedDeliveryDate
expected_delivery_date
remoteId
purchaseorder_id
totalValue
total * exchange_rate
The source filter on new buy orders is status not equal to billed or cancelled.
Zoho Region: the region of the company registered in Zoho; no default is stated.
Sync_Stock: a client can set this to False to stop product stock syncing; no default is stated.
Warehouse_ids: for multiple warehouse sources, select Zoho Inventory warehouses using numeric IDs separated by commas; no default is stated.
Purpose
This guide lists Zoho Books field mappings and the two documented schedule flavors; it does not establish account configuration or enabled flows.
Prerequisites
For warehouse-specific stock selection, the source describes numeric Zoho Inventory warehouse IDs separated by commas. Confirm the registered Zoho region and any selected options for the account.
Steps
Identify whether the documented flow is Simple / 1st Flavor or Full / 2nd Flavor.
Match the entity and direction to the corresponding schedule and mapping; buy-order import (Zoho Books to Optiply) and export (Optiply to Zoho Books) are separate flows.
Read conditional product and sales-order expressions line by line; their conditions do not establish account-level option values.
Check the documented filters for new incoming buy orders and any salesperson exclusions when interpreting the described scope.
Mapping qualifiers
The sell-order source states: if “pull all sell orders” is false, sync only orders with status invoiced, partially invoiced, or closed. It also describes excluding orders from selected sales channels by entering salesperson IDs (comma-separated examples are shown in the source). Neither paragraph states the value configured for a particular account. Sell Order changes, line edits, deleted lines, and new lines added to existing orders are not updated in Optiply.
Expected result
For new incoming buy orders, the source specifies a filter excluding records whose status is billed or cancelled.
Limitations
The source gives no default for Zoho Region, Sync_Stock, or Warehouse_ids; it does not establish account-specific settings. The source describes sales-order filters conditionally: when “pull all sell orders” is false, only orders with status “invoiced”, “partially invoiced”, or “closed” are synced. A customer may exclude sales channels by listing salesperson IDs. These statements describe conditions, not which settings are enabled for an account. Sell-order changes and edits to existing lines are not updated in Optiply.
Errors and recovery
This reference does not provide a connection-recovery procedure or confirm successful execution. If the flow, flavor or sample fields are missing, the comparison remains unresolved; do not infer a mapping from another entity or direction.