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, shipments and articles will be fetched automatically from the web shop to Ongoing WMS. When a shipment has been picked the shipment will be set to "Completed" in Centra. You can extend the integration to include purchase orders, returns and stock values. Note that a shipment in Centra corresponds to an order in Ongoing WMS.
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
| Ongoing WMS field name | Centra field name |
|---|---|
| ArticleDefinition ⇒ ArticleNumber | sku+variant sku + size sku* |
| ArticleDefinition ⇒ ArticleName | Product ⇒ Product + Product ⇒ Variant + Product + Size (e.g. WinterJacket Black 38) |
| ArticleDefinition ⇒ BarCode | Product ⇒ ean |
| ArticleDefinition ⇒ StatisticsNumber | Product ⇒ harmCode |
| ArticleDefinition ⇒ CountryOfOriginCode | Product ⇒ countryOfOrigin |
| ArticleDefinition ⇒ IsObsolete | Product ⇒ active (this is only used if the setting to synchronize inactive products has been turned on.)* |
| ArticleDefinition ⇒ weight | Product ⇒ weight (recalculated to kg, if g is used in Centra.) |
| ArticleDefinition ⇒ CustomerPrice | Product ⇒ 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.
| Filter/Setting | Values | Default |
|---|---|---|
| Sync inactive products | Yes/No | No |
| Article number | EAN, SKU, or any combination of SKU, variant SKU and size SKU | SKU + variant SKU + size SKU |
| Additional filters | It is possible to add customised filters to only import some articles | SKU, variant SKU, size SKU must have values |
| Sync article price | Yes/No | No |
Shipments
A shipment in Centra is used to create an order in Ongoing WMS. Note that the integration will not sync orders from Centra, only shipments. When an order has been picked in the WMS, the number of picked items on the order will be reported back and the corresponding shipment 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! The shipment in Centra 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 in Ongoing WMS. 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
| Ongoing WMS field name | Centra field name |
|---|---|
| OrderInfo ⇒ GoodsOwnerOrderId | Shipment ⇒ ShipmentId |
| OrderInfo ⇒ GoodsOwnerOrderNumber | Shipment ⇒ ShipmentId |
| OrderInfo ⇒ CustomerPrice | Shipment ⇒ grandTotalValue |
| OrderInfo ⇒ WayOfDelivery | Shipment ⇒ shipmentId |
| OrderInfo ⇒ InvoiceNumber | Shipment ⇒ proforma |
| OrderInfo ⇒ InvoiceUrl | Shipment ⇒ invoices (the latest) |
| OrderInfo ⇒ ConsigneeOrderNumber | Shipment ⇒ deliveryNote |
| OrderInfo ⇒ MarketPlace | Shipment ⇒ marketplace_source |
| OrderInfo ⇒ MarketPlaceOrderNumber | Shipment ⇒ marketplace_source_id |
| OrderInfo ⇒ OrderRemark | Shipment ⇒ otherComment |
| OrderInfo ⇒ OrderServicePointCode | Shipment ⇒ shipwallet_pickup |
| OrderInfo ⇒ OrderNotification ⇒ MobilePhone | Shipment ⇒ deliveryCell (or deliveryTele if deliveryCell is empty)* |
| OrderInfo ⇒ OrderNotification ⇒ Email | Shipment ⇒ deliveryEmail* |
| OrderInfo ⇒ OrderType | B2B or B2C, based on enpoint |
| Customer ⇒ CustomerNumber | Shipment ⇒ customerId |
| Customer ⇒ Name | Shipment ⇒ deliveryName for B2B and deliveryCompany for B2C |
| Customer ⇒ Address | Shipment ⇒ deliveryAddress (or deliveryCoaddress if this is used) |
| Customer ⇒ Address2 | Shipment ⇒ deliveryAddress if deliveryCoaddress is used |
| Customer ⇒ PostCode | Shipment ⇒ deliveryZipcode |
| Customer ⇒ City | Shipment ⇒ deliveryCity |
| Customer ⇒ CountryStateCode | Shipment ⇒ deliveryState |
| Customer ⇒ CountryCode | Shipment ⇒ deliveryCountry |
| Customer ⇒ Email | Shipment ⇒ deliveryEmail |
| Customer ⇒ TelePhone | Shipment ⇒ deliveryTele |
| Customer ⇒ MobilePhone | Shipment ⇒ deliveryCell |
| TransporerContract ⇒ ServiceCode | shipment.shipwallet_method |
| Orderline ⇒ ExternalOrderLineCode | Shipment ⇒ Products ⇒ lineId |
| Orderline ⇒ ArticleNumber | Shipment ⇒ Products ⇒ SKU+ variant SKU + size SKU* |
| Orderline ⇒ NumberOfItems | Shipment ⇒ Products ⇒ qty |
| Orderline ⇒ CustomerLinePrice | Shipment ⇒ Products ⇒ price |
| Orderline ⇒ CurrencyCode | Shipment ⇒ 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 shipments matching the following filter in Centra are synced to Ongoing WMS.
| Filter/Setting | Values | Default |
|---|---|---|
| When to capture shipments (Capturing means that Ongoing WMS will send a request to Centra to charge the customer.) | Never/On Import/On Complete | Never |
| Aditional filters | It is possible to add customized filters to only import some shipments, e.g. after successfull capture | No 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
| Ongoing WMS field name | Centra field name |
|---|---|
| InOrderInfo ⇒ GoodsOwnerReference | PurchaseOrder ⇒ deliveryId |
| InOrderInfo ⇒ GoodsOwnerOrderNumber | PurchaseOrder ⇒ id |
| InOrderInfo ⇒ ReferenceNumber | PurchaseOrder ⇒ orderId |
| InOrderInfo ⇒ InDate | PurchaseOrder ⇒ ETA |
| InOrderSupplier ⇒ SupplierName | PurchaseOrder ⇒ supplierName |
| InOrderLine ⇒ ArticleNumber | PurchaseOrder ⇒ products ⇒ SKU + variant SKU + size SKU |
| InOrderLine ⇒ NumberOfItems | PurchaseOrder ⇒ products ⇒ quantity |
| InOrderLine ⇒ NumberOfItems | PurchaseOrder ⇒ products ⇒ quantity*cost |
| InOrderLine ⇒ CurrencyCode | PurchaseOrder ⇒ products ⇒ costCurrency |
Filters and Settings
| Filter/Setting | Values | Default |
|---|---|---|
| Aditional filters | It is possible to add customized filters for purchase orders | No 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
| Ongoing WMS field name | Centra field name |
|---|---|
| Order ⇒ PickedOrderLines ⇒ ExternalOrderLineCode | product |
| Order ⇒ PickedOrderLines ⇒ ReturnedNumberOfItems - ReportedReturnedNumberOfItems | quantity |
| 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
| Filter/Setting | Values | Default |
|---|---|---|
| Return stock (makes the returned item go back in stock in Centra) | Yes/No | No |
| Include return comment to return casue | Yes/No | No |
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 shipments to Centra, therefore it's not recommended to synchronizes the stock values more often than once a day.
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
| Filter/Setting | Values | Default |
|---|---|---|
| Synchronize stock to Centra | Yes/No | No |
| Import Centras' "available stock" to "external number of items" in Ongoing WMS | Yes/No | No |
| Report picked, but not yet collected, items as in stock | Yes/No | No |
Default Set Up
The default synchronization interval is 15 minutes and contains synchronization of
- Article registry
- Shipments
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.