All products with the status (visibility) "Always visible" or "Visible when in stock" / "for sale due to lack of stock" from Lightspeed are shown in Optiply. The products with the status "Hidden" / "Stop selling" are not shown or included in Optiply.
Also, variants whose stock is not tracked are not included in Optiply.
New products are imported with the regular jobs, but may be delayed in Optiply due to Lightspeed's API's 'rate-limit'.
Synchronisation General Board
This is an overview of what and when we synchronise data.
Entity | Sync FROM -> TO | Frequency |
Products | Lightspeed > OP | Every 10 min |
Suppliers | Lightspeed > OP | Every 10 min |
Supplier Products | Lightspeed > OP | Every 10 min |
Sell Orders * | Lightspeed > OP | Every 10 min |
Receipt Lines (Item Deliveries) | OP > LightSpeed | Every 15 minutes
|
* If the order comes with the status = ”cancelled”, we will delete the sellOrder in Optiply.
Mapping Information
Now we show the specifics of how we map data for each entity.
Products
Optiply | Lighspeed |
name | product.title + ' ' + |
skuCode | variant sku |
articleCode | variant articleCode |
price | variant priceExcl |
unlimitedStock | if variant.stockTracking='disabled' THEN unlimitedStock=true otherwise unlimitedStock=false |
stockLevel | variant stockLevel (through product variant) |
status (*1) | if product.visibility='hidden' THEN status=”disabled” otherwise status=”enabled |
(*1) Customer can decide if we should also sync “hidden” products as “enabled”, that is an option and not the default mapping.
Options and features
Products - Sync also “hidden” products to Optiply
An option that allows a customer to decide if we should sync also sync products/variants with visibility=”hidden” to Optiply as “enabled”. By default, we don’t sync those products/variants.
This option will also affect the related supplier products.
Suppliers
Optiply | Lightspeed |
name | if supplier.name exists → name=supplier.name otherwise name=supplier id |
country | country_id.title |
Supplier Products
This data is pulled from the products/variants endpoint
Optiply | Lightspeed |
name | name from webshop product |
sku | variant sku |
price | variant priceCost |
lotSize | if variant.Colli exists and >= 1 THEN lotSize=variant.Colli otherwise lotSize=1 |
supplier | product.supplier |
status | product visibility if 'hidden' → false otherwise → true |
eanCode | variant ean |
articleCode | variant articleCode |
Supplier Product is created with Product Info
Options and features
SupplierProducts lotSize Sync
If the customer wants, he can decide to sync the lotSize. By default, we don’t sync it.
Sell Orders
Optiply | Lightspeed |
status | status |
placed | createdAt |
completed | updatedAt |
totalValue | 0 (TBD) |
We sync Orders with this status:
"processing"
"processing_awaiting_shipment"
"processing_awaiting_pickup"
"processing_partially_shipped"
"processing_partially_picked_up"
"completed"
"completed_shipped"
"completed_picked_up"
"processing_partially_paid",
"processing_awaiting_payment"
If the order comes with the status = ”cancelled”, we will delete the sellOrder in Optiply.
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 | Lightspeed |
quantity | quantityOrdered |
subTotalValue | priceExcl or price * quantityOrdered |
placed | inherited from sell order |
Remove products
Do you want to remove a product?
First, give it the status "Hidden" / "Stop selling" in Lightspeed. The product will disappear from Optiply.
You can then remove the product from Lightspeed.
Composed Products
Lightspeed does not have composed products. Tell us the composition of the combinations. We then ensure that the sales history of the combined product is transferred to the underlying products. We recommend using the Combi Product app to correct the stock of the composed product.
Purchase Orders
Lightspeed does not work with purchase orders. You have to keep track of the orders you have placed via Optiply. When you receive an order from the suppliers, you must close it with us. You can also receive orders in parts.
When an order has already been placed, and you give the product the status 'Hidden', the product will still be purchased. The product is still visible in the placed order, but no longer in Optiply. In the future, Optiply will no longer provide advice for this product.
Booking purchase orders
It is possible to book purchase orders in Lightspeed via Optiply. We then increase the stock in Lightspeed with the number of products received. This is off by default. If you want to make use of this, please let us know. We will then turn on the option for you.
Be aware that you should always process order receipts via Optiply. This is necessary to keep the Inventory Position up-to-date. An incorrect Inventory Position can cause wrong order advice.
Options and features
ItemDeliveries - Optiply to Lightspeed - Update stock in Lightspeed
When a customer creates a delivery in Optiply, we can update product stock in Lightspeed. By default, this feature is off.
Attention: A product in Lightspeed where the stock_recording is turned off.
This will result in a Unlimited_stock is True.
These products will not be visible in Optiply.