QLS - Data Mapping & Synchronization

Welcome to our guide for a seamless connection between QLS and Optiply. This article is designed to provide you with a clear understanding of how data flows, ensuring your operations run smoothly and efficiently. It's important to note that this integration utilizes a standard data mapping structure, and custom mapping options are not available for this connection.

Overview

Entity	Direction	Update Frequency
Products	QLS > OP	30 minutes
Product Deletions	QLS > OP	updated daily (default)
Suppliers	QLS > OP	30 minutes
SupplierProducts	QLS > OP	30 minutes
SupplierProducts Deletions	QLS > OP	30 minutes
Sell Orders	QLS > OP	30 minutes
Buy Orders	QLS > OP	30 minutes
Buy Orders	OP > QLS	15 minutes
Receipt Lines (Item Deliveries)	QLS > OP	30 minutes

Products

Optiply	QLS
articleCode	`id`
name	`name`
skuCode	`sku`
eanCode	`ean`
price	`price_store`
assembled	`bundle_product`
stockLevel	`amount_available` - `backorders.amount`

Suppliers

Optiply	QLS
name	`name`
remoteId	`id`

Supplier Products

Optiply	QLS
name	`name`
skuCode	`sku`
eanCode	`ean`
price	`price_cost`
lotSize	`product_master_cartons.amount`

Multiple supplier (products) is supported

Sell Orders

Optiply	QLS
totalValue	0
placed	`createdAt`
remoteId	`id`

Sell Order Lines

Optiply	QLS
productId	`optiplyWebshopProductArticleCode`
quantity	`amount_ordered`
subtotalValue	`price_store`

Buy Orders (QLS > Optiply)

Optiply	QLS
Id	`id`
supplier id	`supplier_name` > get the Id from the name
placed	`created`
remoteId	`id`

Buy Order Lines

Optiply	QLS
productId	`products.id`
quantity	`products.amount_expected`
subtotalValue	`products.amount_expected` * `price_cost`
buyOrderId	`id`

BuyOrderLines are sorted ascending when sent to QLS.

Buy Orders (Optiply > QLS)

Optiply	QLS
Id	`customer_reference`
supplier_name	`supplier_name`
product.article_code	`products.product_id`
product.quantity	`products.amount_expected`

Receipt Lines

Optiply	QLS
quantity	`amount_received`
ocurred	`created`
buyOrderLineId	`optiply.buyOrderLineId`
remoteId	`receipt_id`

Buy Orders v2 (QLS > OP)

Optiply	QLS
Id	`id`
supplier id	`supplier_name` > get the Id from the name
placed	`created`
remoteId	`id`

Buy Order Lines v2

Optiply	QLS
productId	`purchase_order_products.products.id`
quantity	`purchase_order_products.amount`
subtotalValue	`products.amount_expected * price_cost`
buyOrderId	`id`

Receipt Lines v2

Optiply	QLS
quantity	`purchase_order_products.purchase_order_label_products`.`amount`
ocurred	`purchase_order_products.purchase_order_label_products.created`
buyOrderLineId	`optiply.buyOrderLineId`

Receipt Lines come from BuyOrderLinesById_v2 endpoint, in purchase_order_products.purchase_order_label_products tag

Buy Orders v2 (OP > QLS)

Optiply	QLS
Id	`customer_title`
supplier.remoteId	`suppliers`
product.article_code	`purchase_order_products.fulfillment_product_id`
product.quantity	`purchase_order_products.amount`
created	`deliveries.estimated_arrival`