Skip to main content

Magento 2 - Data Mapping & Synchronization

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

Marc de Graaf avatar
Written by Marc de Graaf
Updated over a year ago

Overview

This is a general overview of what and when the data is synchronized.

Entity

Direction

Update Frequency

Products

Magento > Optiply

Every hour (Full Sync)

Product Deletions

Magento > Optiply

Every hour (Full Sync) (*)

Stocks

Magento > Optiply

Every hour

Sell Orders

Magento > Optiply

Every hour

Receipt Lines (Item Deliveries)

Optiply > Magento

Not implemented yet

(*) Deleted products are not retrieved from Magento. We will run a Products Full Sync to check which products are enabled in Optiply and don’t exist in Magento anymore.

Products

Optiply

Magento

name

name

skuCode

sku

articleCode

id

price

price

UnlimitedStock

manage_stock (*1)

stockLevel

qty (*1) (*2)

status

If status=1 Then OP.Status='enabled'

If status=2 Then OP.Status='disabled'

Managing stock on different Product Types

(*1) We cannot get manage_stock or qty from bulk calls, so we need to make a single call for each product (shop_URL/rest/all/V1/stockStatuses/SKU).

The base rule is:

IF manage_stock is TRUE → UnlimitedStock = FALSE

IF manage_stock is FALSE → UnlimitedStock = TRUE

IF product type = simple, this rules apply (normal mapping, on the table bellow)

IF product type is other than Simple then UnlimitedStock is always TRUE.

(*2) By default salable_quantity is mapped for syncing the stock. It is also possible to use quantity. Please contact support if you would like to change this.

Magento Product Types

Product Type Magento

Optiply

simple

(normal mapping)

configurable

unlimited stock = true

Grouped

unlimited stock = true

Virtual

unlimited stock = true

Bundle

unlimited stock = true

Downloadable

unlimited stock = true

Gift

unlimited stock = true

Sell Orders

By default, we only synchronize Completed Sell Orders from Magento to Optiply. It is possible to sync All Order Statuses.

Optiply

Magento

totalValue

subtotal

placed

created_at

completed

updated_at

SellOrderId

increment_id

SellOrderRemoteId

identity_id

Sell Orders Lines

Optiply

Magento

productId

product_id

quantity

qty_ordered

subtotalValue

base_row_total

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.

Purchase orders

Magento has no purchase orders. When you place an order in Optiply, it is not transferred to Magento.

It is important that purchase orders are closed in Optiply upon receipt. You can easily do this on the purchase page under 'Today's & Overdue Orders'. Even when you have received part of an order, it is important to enter it in Optiply, in order to ensure that stock levels remain correct.

Backorders

Optiply can automatically schedule orders with customer backorders. We do this on the basis of negative stock levels. To process negative stock levels in Magento 2 you need to make a number of settings:

  • Set the Out-of-Stock Threshold to 0

  • Allow Backorders

Did this answer your question?