🔗 Lightspeed C-Series: Data Mapping & Synchronisation

This guide details the data flow between Lightspeed C-Series and Optiply. It outlines synchronisation frequencies, available configuration options, and specific field mappings for each entity.

⏱️ Synchronisation General Board

The following table outlines the data entities and their update frequency.

Entity	Direction	Frequency
Products	Lightspeed C-Series → Optiply	Every 10 min
Suppliers	Lightspeed C-Series → Optiply	Every 10 min
Supplier Products	Lightspeed C-Series → Optiply	Every 10 min
Sell Orders	Lightspeed C-Series → Optiply	Every 10 min
Sell Order Deletions	Lightspeed C-Series → Optiply	Every 10 min (*1)
Stock Updates (Item Deliveries)	Optiply → Lightspeed C-Series	Every 15 min (*2)

(*1) Deletion Logic: By default, if an order status changes to "cancelled" In Lightspeed, we delete the order in Optiply.
(*2) Stock Updates: This feature ("Update stock in Lightspeed") is off by default. When enabled, creating a delivery in Optiply updates the product stock in Lightspeed C-Series.

⚙️ Options and Features

The following settings can be customised. Please contact Customer Support to adjust these variables, as they cannot be changed in the front-end.

1. Sync Hidden Products

Variable: sync_products_hidden (Default: false)
Function: By default, products with visibility set to "Hidden" in Lightspeed are mapped as "Disabled" in Optiply. Enabling this option allows hidden products/variants to sync as "Enabled" (active).

2. SellOrders - Delete orders based on a custom status list

Variable: sellorders_delete_statuses (Default: "cancelled")
Function: Define a custom list of Lightspeed statuses that should trigger an order deletion in Optiply.

3. Update Stock in Lightspeed

Function: When a Goods Receipt (Item Delivery) is processed in Optiply, we can push the new stock level back to Lightspeed C-Series. This must be requested manually.

4. SupplierProducts lotSize Sync

The customer can decide to sync lotSize. By default, we don’t sync it.

5. 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.

6. 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.

7. 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.

8. 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.

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.

🗺️ Data Mapping Details

1. Products

Source: Product Variants

Optiply	Lightspeed C-Series	Logic / Notes
Name	`product.title` + `title_variant`	Concatenated.
SKU Code	`variant sku`	-
Article Code	`variant articleCode`	-
Price	`variant priceExcl`	-
Unlimited Stock	`variant.stockTracking`	If `'disabled'` → True. Else → False.
Status	`product.visibility`	If `'hidden'` → Disabled. Else → Enabled.
Stock Level	`variant stockLevel`	-
Remote ID	`variant id`	-

2. Suppliers

Optiply	Lightspeed C-Series	Logic
Name	`supplier.name`	If name exists → `supplier.name`. Else → `supplier id`.
Country	`country_id.title`	-
Remote ID	`id`	-

3. Supplier Products

Source: Data is pulled from the Products/Variants endpoint.

Optiply Field	Lightspeed C-Series Field	Logic / Notes
Name	`title`	From webshop product.
SKU Code	`variant sku`	-
Price	`variant priceCost`	Maps to the Cost Price.
Lot Size	`variant.Colli`	If `Colli` exists >= 1 → `Colli`. Else → 1.
Supplier	`product.supplier`	-
Status	`product.visibility`	If `'hidden'` → False. Else → True.
EAN Code	`variant ean`	-
Article Code	`variant` articleCode
Remote ID	`variant id`	-

Note on Lot Size: We verify if the Lightspeed field "Colli" is populated to determine the Lot Size.

4. Sell Orders

Optiply Field	Lightspeed C-Series Field	Notes
Status	`status`	See list of synced statuses below.
Placed Date	`createdAt`	-
Completed Date	`updatedAt`	-
Total Value	`0`	(TBD) Currently set to 0 on the order header.

Synced Statuses:

We only sync orders with the following statuses:

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

⚠️ Limitation: We do not sync order changes. Order line changes, deletions, or new lines added to existing orders will not be updated in Optiply.

5. Sell Order Lines

Optiply Field	Lightspeed C-Series Field	Logic
Quantity	`quantityOrdered`	-
Subtotal Value	`priceExcl`	Or calculated: `price * quantityOrdered`.
Placed Date	-	Inherited from Sell Order.

❓ Frequently Asked Questions (FAQs)

My hidden products are not showing up. Why?

By default, "Hidden" products in Lightspeed are mapped as "Disabled" in Optiply. If you want to order stock for hidden products (e.g., new collections not yet live), ask Support to enable the sync_products_hidden option.

Does Optiply update my stock in Lightspeed?

Only if you request the "ItemDeliveries - Optiply to Lightspeed" feature. By default, this is off. When enabled, receiving goods in Optiply will push the new stock count to Lightspeed C-Series every 15 minutes.

What is the "Colli" field?

"Colli" is a field often used in Lightspeed C-Series (Dutch: Collomoduul) to denote package size. Optiply maps this field to Lot Size. If your Colli is set to 6, Optiply will advise ordering in multiples of 6.

Lightspeed C Series- Data Mapping & Synchronisation