Skip to main content
All CollectionsIntegrationsOdoo
Odoo - Data Mapping & Synchronization
Odoo - Data Mapping & Synchronization

This article describes in detail what and how data is used for the connection with Odoo.

Marc de Graaf avatar
Written by Marc de Graaf
Updated over 5 months ago

Synchronisation General Board

This is an overview of what and when we synchronise data.

Entity

Sync FROM > TO

Frequency

Products

Odoo > OP

30min

Product Deletions

Odoo > OP

30min

Stocks

Odoo > OP

30min

Product Compositions

Odoo > OP

30min

Suppliers

Odoo > OP

30min

Supplier Products

Odoo > OP

30min

Supplier Products Deletions

Odoo > OP

30min

Sell Orders

Odoo > OP

30min

Sell Order Deletions

Odoo > OP

30min

Buy Orders

Odoo > OP

30min

OP > Odoo

15min

Buy Order Line Added

Odoo > OP

30min

Buy Order Line Changes

Odoo > OP

30min

Buy Order Line Cancellation

Odoo > OP

30min

Receipt Lines (Item Deliveries)

Odoo > OP

30min

Flags

We provide several customizable options based on customer requests. Below are the key flags we can adjust:

  • use_templates: Determines whether products are created based on predefined templates.

  • sell_price_with_taxes: When set to true, product prices will be synced with taxes already included.

  • sync_purchase_price: Controls whether the purchase prices of products will be synced.

  • average_purchase_price: This flag enables syncing of the average cost for Supplier Products.

  • pullAllOrders: If set to false, only sell orders with the status “sale” or “cancel” (for deletions) will be pulled. If true, all orders will be pulled regardless of status.


Mapping Information

Products

Optiply

Odoo

remoteId

product.id

name

product.name

skuCode

product.default_code

articleCode

product.code

price

product.tax_string

stockLevel

product.qty_available - product.outgoing_qty

status

IF product.status = true

THEN status=enabled

Otherwise status=disabled

eanCode

product.product.barcode

assembled

If product.product.bom_count > 0 : true
(field in production module)


Product Compositions

Optiply

Odoo

composedProductId

mrp.bom.parent_product_tmpl_id

partProductId

mrp.bom.product_id

partQuantity

mrp.bom.product_qty

remoteId

mrp.bom.id


Suppliers

Optiply

Odoo

name

res.partner.display_name

remoteId

res.partner.ID

emails

res.partner.email_normalized

Supplier Products

Optiply

Odoo

name

product.name

remoteId

optiplySupplierId_optiplyProductId

price

product.supplierinfo.price

skuCode

product.supplierinfo.product_code

status

product.supplierinfo.start_date < now and product.supplierinfo.end_date > now

minimumPurchaseQuantity

product.supplierinfo.min_qty

deliveryTime

product.supplierinfo.delay

supplier_id

optiplySupplierId

product_id

optiplyProductId


Sell Orders

Optiply

Odoo

totalValue

sale.order.amount_untaxed

remoteID (*1)

sale.order.id

placed

sale.order.date_order

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

Sell Order Lines

Optiply

Odoo

product_id

sale.order.line.product_id

quantity

sale.order.line.product_uom_qty

subtotalValue

sale.order.line.price_subtotal

remoteID

sale.order.line.id

sellOrderId

sale.order.line.order_id


Buy Orders - Odoo to Optiply

Optiply

Odoo

optiplySupplierId

purchase.order.partner_id

placed

purchase.order.date_order

completed

date.now() when total sum of buyOrderLine Products =

expectedDeliveryDate

purchase.order.date_planned

totalValue

purchase.order.amount_total

remoteId

purchase.order.id

Buy Order Lines - Odoo to Optiply

Optiply

Odoo

subtotalvalue

purchase.order.line.price_subtotal

quantity

purchase.order.line.product_qty

remoteId

purchase.order.line.id

buyOrderId

purchase.order.line.order_id

productId

purchase.order.line.product_id

Buy Orders Optiply to Odoo

Optiply

Odoo

optiplySupplierRemoteId

partner_id

optiplyBuyOrderId

name

completed

effective_date

expectedDeliveryDate

date_planned

Buy Orders Lines Optiply to Odoo

Optiply

Odoo

quantity

product_qty

optiplyProductRemoteId

productId

Receipt Lines - Odoo to Optiply

Optiply

Odoo

quantity

purchase.order.line.product_qty

occured

purchase.order.line.date

remoteID

purchase.order.line.id

Did this answer your question?