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)

EntityDirectionFrequency / note
ProductsZohoBooks > OPupdated hourly
Sell OrdersZohoBooks > OPupdated hourly

Full / 2nd Flavor (Prod + Supp + Supp Prods + SO + BO)

EntityDirectionFrequency / note
ProductsZohoBooks > OPupdated hourly
SuppliersZohoBooks > OPupdated hourly
Supplier ProductsZohoBooks > OPupdated hourly
Sell OrdersZohoBooks > OPupdated hourly
Buy Orders ImportZohoBooks > OPupdated hourly
Buy Orders ExportOP > ZohoBooksevery 15min

Fields and columns

Product

Optiply fieldSource field / expression
namename
skuCodesku
pricerate
remoteIditem_id
statusIf product_type = goods AND status = active<br>Then optiply.status = enabled<br>Otherwise optiply.status = disabled
stockLevelavailable_for_sale_stock
UnlimitedStockif product_type = digital or product_type = service or product_type = digital service<br>Then “true”<br>else “false”
createdAtRemotecreated_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 fieldSource field / expression
totalValuetotal
placeddate
remoteIdsalesorder_id

Sell order line

Optiply fieldSource field / expression
productIdline_items.item_id
quantityline_items.quantity
subtotalValueline_items.rate * line_items.quantity
sellorder_idsalesorder_id

Supplier

Optiply fieldSource field / expression
namevendor_name
emailemail
remoteIdcontact_id

Supplier product

Optiply fieldSource field / expression
namename
skuCodesku
pricepurchase_rate
supplierIdvendor_id
productIditem_id

Buy order (Zoho Books to Optiply)

Optiply fieldSource field / expression
supplierIdvendor_id
placeddate
completedTimestamp when order_status became closed
expectedDeliveryDateexpected_delivery_date
remoteIdpurchaseorder_id
totalValuetotal * exchange_rate

The source filter on new buy orders is status not equal to billed or cancelled.

Buy order line (Zoho Books to Optiply)

Optiply fieldSource field / expression
productIdline_items.item_id
quantityline_items.quantity
subtotalValueline_items.quantity * line_items.rate * exchange_rate
buyOrderIdpurchaseorder_id

Buy order (Optiply to Zoho Books)

Optiply fieldSource field / expression
supplier.remoteIdvendor_id

Buy order line (Optiply to Zoho Books)

Optiply fieldSource field / expression
optiplyBuyOrderIdreference_number
product.remoteIditem_id
quantityquantity

Configuration options

  • 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

  1. Identify whether the documented flow is Simple / 1st Flavor or Full / 2nd Flavor.
  2. 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.
  3. Read conditional product and sales-order expressions line by line; their conditions do not establish account-level option values.
  4. 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.