Important: This article describes documented integration mappings and defaults, not your account’s current configuration. Only the fields listed below are covered; other fields are not implied to synchronise.
Reading the mapping tables
The Optiply field column identifies the field in Optiply. For an inbound flow it is the destination; for an outbound flow it is the origin. The second column gives the corresponding external field or documented transformation. Read each table with its entity and direction.
Synchronisation schedule and direction
The table below shows documented directions and frequencies where the source names an object. It does not confirm which flows are active for your account.
| Entity | Direction | Frequency / note |
|---|---|---|
| Products | ZohoInv > OP | each 60 minutes |
| Product Compositions | ZohoInv > OP | each 60 minutes |
| Suppliers | ZohoInv > OP | each 60 minutes |
| Supplier Products | ZohoInv > OP | each 60 minutes |
| Sell Orders | ZohoInv > OP | each 60 minutes; all orders except drafts by default |
| Buy Orders | ZohoInv > OP | each 60 minutes |
| Assembly Orders | Zoho Inventory > OP | Mapping section gives no interval |
| Buy Orders | Optiply > Zoho Inventory | Named mapping; interval not identified |
| Assembly Orders | Optiply > Zoho Inventory | Not sent by default; interval not identified |
| Buy Order Deletions | ZohoInv > OP | each 60 minutes |
| Buy Order Lines(including Deletions) | ZohoInv > OP | each 60 minutes |
| Receipt Lines (Item Deliveries) | ZohoInv > OP | each 60 minutes |
The integration overview also contains an outbound 15-minute schedule entry without an entity and names ZohoBooks as its destination. The named mappings below identify Buy Orders and Assembly Orders going to Zoho Inventory; the source does not associate that 15-minute entry with either object, so its interval is not assigned to those flows here.
Mapped fields
Product
| Optiply field | Source field / expression |
|---|---|
name | name |
skuCode | sku |
price | rate |
articleCode | purchase_description |
status | if product_type = goods AND item_type = inventory AND status = active Then status = enabledOtherwise status = disabled |
eanCode | ean |
UnlimitedStock | False |
stockLevel | actual_available_for_sale_stock |
remoteId | item_id |
createdAtRemote | created_time |
This guide omits the assembled field because the cited source does not establish its default mapping behavior.
For stockLevel, the source documents stock syncing as true by default and warehouse_ids as allWarehouses by default. If a warehouse selection is specified, the source describes numerical warehouse IDs separated by commas; it does not provide an aggregation formula.
Product composition
| Optiply field | Source field / expression |
|---|---|
composedProductId | composite_item_id |
partProductId | mapped_items.item_id |
partQuantity | mapped_items.quantity |
remoteId | mapped_items.mapped_item_id |
Receipt line
| Optiply field | Source field / expression |
|---|---|
Ocurred | Date |
Quantity | line_items.quantity |
BuyOrderLineId | optiplyBuyOrderLineId |
remote_id | receive_id |
Sell order
| Optiply field | Source field / expression |
|---|---|
totalValue | total |
placed | date |
remoteId | salesorder_id |
With the documented pullAllOrders default of true, all Sell Orders except drafts are included. When that option is false, only orders with salesorders.order_status == "closed" are included. This describes documented behavior, not your account’s active setting.
Sell order line
| Optiply field | Source field / expression |
|---|---|
productId | line_items.item_id |
quantity | line_items.quantity |
subtotalValue | line_items.rate * line_items.quantity |
Supplier
| Optiply field | Source field / expression |
|---|---|
name | contacts.contact_name |
email | contacts.email |
remoteId | contacts.contact_id |
The source filters these contacts to contact_type = "vendor".
Supplier product
| Optiply field | Source field / expression |
|---|---|
name | name |
skuCode | sku |
articleCode | upc |
eanCode | ean |
price | purchase_rate |
supplierId | vendor_id |
productId | item_id |
Buy order (Zoho Inventory to Optiply)
| Optiply field | Source field / expression |
|---|---|
buyOrder.supplierId | op supplierId |
buyOrder.placed | date |
buyOrder.completed | Timestamp when order_status becomes “closed” |
buyOrder.expectedDeliveryDate | expected_delivery_date |
remoteId | purchaseorder_id |
buyOrder.totalValue | total * exchange_rate |
Buy order line (Zoho Inventory to Optiply)
| Optiply field | Source field / expression |
|---|---|
productId | line_items.item_id |
quantity | line_items.quantity |
subtotalValue | line_items.quantity * line_items.bcy_rate * buyorder_exchange_rate |
buyOrderId | purchaseorder_id |
Multiple Zoho Inventory Buy Order lines for the same product are represented as one Optiply line with the quantities summed.
Buy order (Optiply to Zoho Inventory)
| Optiply field | Source field / expression |
|---|---|
buyOrder.supplierId | vendor_id |
The source says payment terms are sent with the purchase order when the corresponding documented option is set; it does not state a default for that option.
Buy order line (Optiply to Zoho Inventory)
| Optiply field | Source field / expression |
|---|---|
product.remoteId | item_id |
quantity | quantity |
Assembly order (Zoho Inventory to Optiply)
| Optiply field | Source field / expression |
|---|---|
totalValue | total |
remoteID | bundle_id |
placed | date |
completed | DateNow |
expectedDeliveryDate | expected_bundle_date |
supplierId | Related Optiply Supplier Product with supplier_type=producer for that product |
Zoho Inventory Assembly Orders have no supplier of their own. The source says the related Optiply Supplier Product with supplier_type=producer supplies the supplier; without that record, the assembly will not sync to Optiply. The source marks the Optiply order complete when Zoho status is bundled.
Assembly order line (Zoho Inventory to Optiply)
| Optiply field | Source field / expression |
|---|---|
optiplyWebshopProductArticleCode | composite_item_id |
quantity | quantity_to_bundle |
subTotalValue | total |
Assembly order (Optiply to Zoho Inventory)
| Optiply field | Source field / expression |
|---|---|
optiplyBuyOrderLineId | reference_number |
buyOrder.placed | date |
buyOrderLine.product.remoteId | composite_item_id |
wp.name | composite_item_name |
buyOrderLine.quantity | quantity_to_bundle |
composition | partProduct.remoteId |
partProduct.name | name |
buyOrderLine.quantity * partQuantity | quantity_consumed |
One Optiply Assembly Order with multiple lines is exported as one Zoho Inventory Assembly per order line. The Optiply order is marked complete when all related Zoho Assemblies are complete. The documented export is not sent by default without a target warehouse; assembly export also cannot handle serial numbers on composed products or their parts.
Documented integration options
These source option names describe integration-level behavior, not customer-facing controls. Defaults below do not confirm which options are active for your account.
| Option | Documented default | What the source says |
|---|---|---|
Sync_Stock | true | The source permits stockLevel syncing to be disabled; its documented default is enabled. |
warehouse_ids | "allWarehouses" | The source permits a selection of numerical warehouse IDs, separated by commas. |
pullAllOrders | true | Includes all Sell Orders except drafts by default; when false, only closed orders are included. |
export_warehouse_id | NULL | Assembly Orders from Optiply are not sent by default; the named option is for a specific Zoho Inventory warehouse. |
Trace a documented field: Product stockLevel
Purpose
Use a read-only sample to compare one Zoho Inventory item’s documented stock source field with Optiply stockLevel.
Before you start
Have read-only values for the same product’s Zoho item_id and actual_available_for_sale_stock, plus the corresponding Optiply stockLevel if available. Record the warehouse scope represented by each value when known. Do not share credentials or private records.
Steps
- Match the same product using the sample’s item identifier.
- Find
stockLevelin the Product table above. - If an Optiply
stockLevelvalue is available, compare it with the Zoho source value only when both refer to the same product and compatible warehouse scope. The documented field path itself requires no calculated warehouse total. - If the warehouse scope is unknown, do not infer an aggregation formula or an expected numeric result. Treat
allWarehousesonly as the documented default, not proof of your account’s setting.
Fields and columns
actual_available_for_sale_stock: the documented Zoho stock input for the selected scope.- Optiply Product
stockLevel: the destination value to compare only against compatible warehouse scope.
The documented Product mapping is stockLevel from actual_available_for_sale_stock. The source documents stock syncing as enabled by default and warehouse_ids as allWarehouses by default. A specified selection uses numerical warehouse IDs separated by commas.
Expected result
For the same product and compatible warehouse scope, an Optiply stockLevel value that matches the mapped Zoho actual_available_for_sale_stock is consistent with the documented field path. The source gives no formula for combining warehouse values and does not prove which warehouse scope is active for your account.
Limitations
The documented defaults are not live configuration. Assembly Orders imported from Zoho require an Optiply Supplier Product with supplier_type=producer for the product; outbound Assembly Orders are not sent by default without a target warehouse. These are separate from the stockLevel field check.
Errors and recovery
Confirm that both values refer to the same product and that the sample’s warehouse scope is known. If the scope is missing, the sample differs, or you need an account-specific result, ask Optiply Support to review the read-only example. Do not change integration options based on this guide.
When your setup differs
Integration settings, selected data flows, and approved custom mappings can change what is synchronised. Contact Optiply Support if you need the exact mapping for your environment.