Centra logo

Integration between Ongoing Warehouse and Centra

Table of contents

Introduction

Centra is a web based web shop platform from Young & Skilled. With an integration to Centra, orders and articles will be fetched automatically from the web shop to Ongoing. 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.

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

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. 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, they will be reported back to Centra.

Field mapping

Show field mapping

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

Show filters and settings

Filter/Setting Values Default
Create orders in Ongoing 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 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. When the inorder has been received in Ongoing, the number of received items will be reported back to Centra.

Field mapping

Show field mapping

Ongoing Warehouse 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 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, 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 Warehouse 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 to Centra and the available number of items in Centra can be imported to Ongoing (this will not change the stock value in Ongoing). Ongoing 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.

The stock levels in Centra are also changed when Ongoing 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 Warehouse field name Centra field name
NumberOfItems - NumberOfLockedItems + il.AllocatedNumberOfItems*physicalStock (this value is written to Centra)
Article ⇒ ExternalNumberOfItems availableStock (this value is red 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 OngoingYes/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 orders are reported back to Centra shipments as the tracking link is received from the TA-system. 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 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!