Welcome to our guide for a seamless connection between WooCommerce 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 utilises a standard data mapping structure, and custom mapping options are not available for this connection.
Overview
Entity | Sync FROM -> TO | Frequency |
Products | Woocommerce > OP | updated hourly (*) |
daily full sync (*) |
|
|
Product Deletions | Woocommerce > OP | updated daily (*1) |
Stocks | Woocommerce > OP | updated hourly and on sell orders |
Sell Orders | Woocommerce > OP | updated hourly |
Receipt Lines (Item Deliveries) | OP > Woocommerce | every 15 minutes |
(*) Woocommerce API versions below 5.6 do not allow a modified_at filtering, and for that reason, we need to have a different sync process depending on the API version.
If API versions < 5.6, then we run a daily full sync for Products.
Otherwise, for version > 5.6, we will get Product updates every hour.
(*1) Deleted products/variants are not retrieved from Woocommerce. We will run a Products Full Sync to check which products are enabled in Optiply and don’t exist in Woocommerce anymore.
Options and features
SubTenants
The customer can have a main shop from where we pull Products and SellOrders, and a secondary Woocommerce shop to pull only SellOrders, using the main shop Products. This only works if Products have the same SKU on both shops so we can map the sellOrderLines on both shops.
Because SubTenants like that will use the main shop Products, the sync for Products on the secondary shop needs to be “turned of” using this flag:
sync_products: false
SellOrders - Sync only Completed Orders from Woocommerce
An option that allows a customer to decide if we should sync All Order status to Optiply or only “Completed”.
(pullAllOrders default false)
Item Deliveries Optiply to Woocommerce - Update stock in Woocommerce
When a customer creates a delivery in Optiply, we can update product stock in Woocommerce.
(By default, we don’t do this)
It is not possible to change these options in our App. Please report to Customer Support if you want to make any changes.
Products (*)
Optiply | Woocommerce |
name | name |
skuCode | sku |
articleCode | id |
price | price |
unlimitedStock | If Otherwise |
stockLevel | stock_quantity |
status | If |
(*) If is a secondary shop (subTenant) we don’t sync products from that secondary shop, it will sync only orders and map them using sku.
Products with type “variable“ aren’t mapped, as they serve as parent product (without any purchases) for variant products.
Remove products
Do you want to remove a product? First, give it the status "enable = false" in WooCommerce. The product will disappear from Optiply. After that, you can remove the product from WooCommerce.
Sell orders
As with products, the placed sales orders are also passed on to us within a few minutes (through webhooks).
Optiply | Woocommerce |
totalValue | total |
placed | date_created_gmt |
completed | date_modified_gmt |
remoteId | id |
Sell order lines
Optiply | Woocommerce |
optiplyProductRemoteId |
|
quantity |
|
subtotalValue |
|
(*1) If it is a secondary shop (subTenant), products come from the main shop, and we map orders from the second shop with
line_items.sku.By default, only Sell Orders with status Completed are synced
Sell Orders are deleted when the status is changed to: Cancelled, Refunded or Failed
We do not sync OrderLine changes in any way, line deletions or new lines added to existing Orders will not be updated in Optiply.
Supplier information
It is not possible to keep track of supplier information in WooCommerce. This is therefore not available via the API and we cannot read it. Supplier data is managed in Optiply.
Booking in Purchase Orders
Because WooCommerce has no purchase orders, you have orders on receipt journal entry in Optiply. Inventories are not automatically adjusted in WooCommerce after booking. If you do want this, please let us know via support@optiply.nl. We adjust this for you, after which the stock is easily updated without adjusting this per product in WooCommerce.