Centra logo

Integration between Ongoing WMS and Centra

Table of contents

Introduction

Centra is a eCommerce platform, where you can manage every aspect in your business in one place, including wholesale B2B, online retail B2C, inventory, billing, payments, analytics and more. Integrating Ongoing WMS with Centra will make your warehouse achieve more with greater accuracy. With an integration to Centra, orders and articles will be fetched automatically from the web shop to Ongoing WMS. When an order has been picked the order will be set to "Completed" in Centra. You can extend the integration to include purchase orders, returns and stock values.

Features

Article registry

The article registry will be imported from Centra to Ongoing WMS.

The article number can be set to ean, sku or any combination of sku, size sku and variant sku. Default is sku + variant sku + size sku. The variation you choose must be unique in Centra.

Once a new product is created, it will only be updated if the "last updated time" in Centra is after time of the latest successful synchronization.

Field mapping

Show field mapping

Ongoing WMS field name Centra field name
ArticleDefinition ⇒ ArticleNumbersku+variant sku + size sku*
ArticleDefinition ⇒ ArticleNameProduct ⇒ Product + Product ⇒ Variant + Product + Size (e.g. WinterJacket Black 38)
ArticleDefinition ⇒ BarCodeProduct ⇒ ean
ArticleDefinition ⇒ StatisticsNumberProduct ⇒ harmCode
ArticleDefinition ⇒ CountryOfOriginCodeProduct ⇒ countryOfOrigin
ArticleDefinition ⇒ IsObsoleteProduct ⇒ active (this is only used if the setting to synchronize inactive products has been turned on.)*
ArticleDefinition ⇒ weightProduct ⇒ weight (recalculated to kg, if g is used in Centra.)
ArticleDefinition ⇒ CustomerPriceProduct ⇒ price*

* = effected by filters or settings. The set value might vary, or it might not be used by default.

Filters and settings

By default, any articles matching the following filter/settings in Centra is synced to Ongoing WMS.

Show filters and settings

Filter/Setting Values Default
Sync inactive productsYes/NoNo
Article numberEAN, SKU, or any combination of SKU, variant SKU and size SKU SKU + variant SKU + size SKU
Additional filtersIt is possible to add customised filters to only import some articlesSKU, variant SKU, size SKU must have values
Sync article priceYes/NoNo

Orders

A shipment or an order in Centra can be used to create an order in Ongoing WMS. By default, shipments are used. When an order has been picked, the number of picked items on the order will be reported back and the order will be set to "Completed" in Centra. If serial numbers are used in Ongoing WMS, they will be reported back to Centra.

Note: If changes need to be made to the order lines these changes must be done in Centra! If the order was created by a shipment in Centra that shipment must be cancelled. To ensure that the corresponding order in Ongoing WMS is cancelled automatically by the integration it is recommended to contact the warehouse first and ask them to set the order status to Open. Also if goods have been picked/allocated to the order they must first be removed from the order.
Then a new shipment can be created in Centra with the wanted changes to the order lines. This new shipment will then be synced by the integration to create a new order in Ongoing WMS.

Field mapping

Show field mapping

Ongoing WMS field name Centra field name
OrderInfo ⇒ GoodsOwnerOrderIdShipment ⇒ ShipmentId
OrderInfo ⇒ GoodsOwnerOrderNumberShipment ⇒ ShipmentId
OrderInfo ⇒ CustomerPriceShipment ⇒ grandTotalValue
OrderInfo ⇒ WayOfDeliveryShipment ⇒ shipmentId
OrderInfo ⇒ InvoiceNumberShipment ⇒ proforma
OrderInfo ⇒ InvoiceUrlShipment ⇒ invoices (the latest)
OrderInfo ⇒ ConsigneeOrderNumberShipment ⇒ deliveryNote
OrderInfo ⇒ MarketPlaceShipment ⇒ marketplace_source
OrderInfo ⇒ MarketPlaceOrderNumberShipment ⇒ marketplace_source_id
OrderInfo ⇒ OrderRemarkShipment ⇒ otherComment
OrderInfo ⇒ OrderServicePointCodeShipment ⇒ shipwallet_pickup
OrderInfo ⇒ OrderNotification ⇒ MobilePhoneShipment ⇒ deliveryCell (or deliveryTele if deliveryCell is empty)*
OrderInfo ⇒ OrderNotification ⇒ EmailShipment ⇒ deliveryEmail*
OrderInfo ⇒ OrderTypeB2B or B2C, based on enpoint
Customer ⇒ CustomerNumberShipment ⇒ customerId
Customer ⇒ NameShipment ⇒ deliveryName for B2B and deliveryCompany for B2C
Customer ⇒ AddressShipment ⇒ deliveryAddress (or deliveryCoaddress if this is used)
Customer ⇒ Address2Shipment ⇒ deliveryAddress if deliveryCoaddress is used
Customer ⇒ PostCodeShipment ⇒ deliveryZipcode
Customer ⇒ CityShipment ⇒ deliveryCity
Customer ⇒ CountryStateCodeShipment ⇒ deliveryState
Customer ⇒ CountryCodeShipment ⇒ deliveryCountry
Customer ⇒ EmailShipment ⇒ deliveryEmail
Customer ⇒ TelePhoneShipment ⇒ deliveryTele
Customer ⇒ MobilePhoneShipment ⇒ deliveryCell
TransporerContract ⇒ ServiceCodeshipment.shipwallet_method
Orderline ⇒ ExternalOrderLineCodeShipment ⇒ Products ⇒ lineId
Orderline ⇒ ArticleNumberShipment ⇒ Products ⇒ SKU+ variant SKU + size SKU*
Orderline ⇒ NumberOfItemsShipment ⇒ Products ⇒ qty
Orderline ⇒ CustomerLinePriceShipment ⇒ Products ⇒ price
Orderline ⇒ CurrencyCodeShipment ⇒ orderCurrency

* = effected by filters or settings. The set value might vary, or it might not be used by default.

Filters and Settings

By default, any orders matching the following filter in Centra are synced to Ongoing WMS.

Show filters and settings

Filter/Setting Values Default
Create orders in Ongoing WMS based on orders or shipments in Centra (Note that we only can report back on shipments, not orders.)Order/Shipment/BothShipment
When to capture shipments (Capturing means that Ongoing WMS will send a request to Centra to charge the customer.)Never/On Import/On CompleteNever
Aditional filtersIt is possible to add customized filters to only import some orders, e.g. paid orders or only after successfull captureNo filter

Purchase orders

Purchase orders (also known as inorders) will be sent from Centra to Ongoing WMS. When the inorder has been received in Ongoing WMS, the number of received items will be reported back to Centra.

Field mapping

Show field mapping

Ongoing WMS field name Centra field name
InOrderInfo ⇒ GoodsOwnerReferencePurchaseOrder ⇒ deliveryId
InOrderInfo ⇒ GoodsOwnerOrderNumberPurchaseOrder ⇒ id
InOrderInfo ⇒ ReferenceNumberPurchaseOrder ⇒ orderId
InOrderInfo ⇒ InDatePurchaseOrder ⇒ ETA
InOrderSupplier ⇒ SupplierNamePurchaseOrder ⇒ supplierName
InOrderLine ⇒ ArticleNumberPurchaseOrder ⇒ products ⇒ SKU + variant SKU + size SKU
InOrderLine ⇒ NumberOfItemsPurchaseOrder ⇒ products ⇒ quantity
InOrderLine ⇒ NumberOfItemsPurchaseOrder ⇒ products ⇒ quantity*cost
InOrderLine ⇒ CurrencyCodePurchaseOrder ⇒ products ⇒ costCurrency

Filters and Settings

Show filters and settings

Filter/Setting Values Default
Aditional filtersIt is possible to add customized filters for purchase ordersNo filter

Returns

Returns that are made on an outbound order in Ongoing WMS can be reported back to Centra with the returned number of items and a comment per row. Note that you can only leave one comment per order row in Centra. It two items from the same order row have different return causes in Ongoing WMS, e.g. one is too small and one is defect, both return causes will be set on the order row.

Field mapping

Show field mapping

Ongoing WMS field name Centra field name
Order ⇒ PickedOrderLines ⇒ ExternalOrderLineCodeproduct
Order ⇒ PickedOrderLines ⇒ ReturnedNumberOfItems - ReportedReturnedNumberOfItemsquantity
Order ⇒ PickedArticleItems ⇒ Return Cause*comment

* = effected by filters or settings. The set value might vary, or it might not be used by default.

Filters and Settings

Show filters and settings

Filter/Setting Values Default
Return stock (makes the returned item go back in stock in Centra)Yes/NoNo
Include return comment to return casueYes/NoNo

Stock values

The stock values can be reported from Ongoing WMS to Centra and the available number of items in Centra can be imported to Ongoing WMS (this will not change the stock value in Ongoing WMS). Ongoing WMS set the physical number of items in Centra, the available number of items is calculated by Centra. The stock value is only updated if the physical number of items in Centra is not equal to the available stock value in Ongoing WMS.

The stock levels in Centra are also changed when Ongoing WMS reports purchase orders or orders to Centra, therefore it's not recommended to synchronizes the stock values more often than once a day.

Field mapping

Show field mapping

Ongoing WMS field name Centra field name
NumberOfItems - NumberOfLockedItems + il.AllocatedNumberOfItems*physicalStock (this value is written to Centra)
Article ⇒ ExternalNumberOfItems availableStock (this value is read from Centra)*

* = effected by filters or settings. The set value might vary, or it might not be used by default.

Filters and Settings

Show filters and settings

Filter/Setting Values Default
Synchronize stock to CentraYes/NoNo
Import Centras' "available stock" to "external number of items" in Ongoing WMSYes/NoNo
Report picked, but not yet collected, items as in stockYes/NoNo

Default Set Up

The default synchronization interval is 15 minutes and contains synchronization of

Ongoing WMS orders are reported back to Centra shipments as the tracking link is received from the shipping platform. This is done by the call updateShipment to set the delivered quantity and picked serial numbers and the call CompleteShipment to mark the shipment as completed. If updateShipment is not successful, completeShipment will not be called.

Preparations

Ask your contact at Centra to provide us with API information. We require both a "host" and a "secret". If you are using multiple end-points, we will require one host and secret for each end-point. If you want to include purchase orders, returns or stock sync in the integration, or do any other changes to the default setting described above, let us know!

Please see this guide on how to set up an integration between Centra and your Ongoing WMS.