All Collections
Integrations
Shopify
Shopify - Data Mapping & Synchronization
Shopify - Data Mapping & Synchronization

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

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

Welcome to our guide for a seamless connection between Shopify 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

Shopify > OP

Hourly

Suppliers (Shopify: Vendors)

Shopify > OP

Hourly (when enabled)

Supplier products

Shopify > OP

Hourly (when enabled)

Sell orders

Shopify > OP

Hourly

Sell order lines

Shopify > OP

Hourly

Item deliveries

OP > Shopify

Every 15 minutes

Mappings

Products

The product information that is forwarded to Optiply from Shopify is shown below in an overview. This information is only imported for "active" products (the information for products with the status "inactive" are not imported).

Optiply

Shopify

name

product.title + variant.title

SKU

variant.sku

article code

variant.product_id

price

variant.price

stock level

variant.inventory_quantity

status: enabled

product.status: active

status: disabled

product.status: archived or product.status: draft

EAN code

variant.barcode

Composite products

Shopify has no composite products. Do you want to insert a composite product? Then it is possible to pass on the composition of combinations to us via a CSV file. We will then ensure that the sales history of the composite product within Optiply is transferred to the underlying products

Delete products

We check for deleted products daily. Deleted products will be removed from Optiply. To delete a product, give the product an "inactive" status in Shopify.

Suppliers

Optiply

Shopify

name

product.vendor

We only match Vendor by the vendor names on products.

Supplier products

Optiply

Shopify

supplierId

product.vendor

skuCode

product.sku

eanCode

product.barcode

price

inventory_items.cost (0 if NULL on Shopify)

status

product.stat

Lot size and MOQ

Lot size and MOQ are not available in Shopify. You can enter them manually in Optiply, or send us a list and we will upload them for you.

Shopify only handles one supplier per product. If you would like to work with multiple suppliers per product, contact our support team. We will turn supplier product synching off and you can manage your supplier products in Optiply.

Purchase orders

Shopify does not manage purchase orders, therefore you have to manage purchase orders in Optiply. When you receive an order from a supplier, close it in Optiply. It is also possible to receive orders in parts so that you can process them clearly.

Sell orders

Optiply

Shopify

total value

order.total_price

placed

order.processed_at

By default we sync Sell Orders Closed, and Deletions.

If you want to get all Sell Orders Status, we can get Created as well, just let us know if you need this info.

Sell order lines

Optiply

Shopify

subtotal value

order.line_items.price

quantity

order.line_items.quantity

We don’t sync Order Updates, line deletions, or line changes to synced Orders.


Quick links

Did this answer your question?