MyCashflow logo

Integration between Ongoing WMS and MyCashflow

Table of contents

Introduction

MyCashflow is an e-commerce platform. It has a REST-based API which covers most of the information available in the platform. Integrating your web shop with your third-party logistics provider via Ongoing WMS provides you with a seamless logistics experience and let you focus on marketing.

When an order is placed by your customer it is automatically transferred to the WMS for the warehouse workers to immediately start picking and packing it. When a shipment has been booked, the WMS performs quick process on the order and the tracking number is sent to the web shop and ready to be delivered to the customer.

Ongoing WMS continuously pulls information about the products from MyCashflow and the available stock in the warehouse is continuously pushed to MyCashflow. The integration between Ongoing WMS and MyCashflow eliminates the manual and repetitive task of keeping two registers in sync and automates the information change in the logistics process.

Scheduled functions

Some functions in the integration run on a schedule. Articles and orders are synced automatically from MyCashflow to Ongoing WMS. The stock can be synced from Ongoing to MyCashflow but is disabled as default.

Article registry

Ongoing WMS pulls article registry updates from MyCashflow to the WMS. MyCashflow contains the master data.

Field mapping

Show field mapping

Ongoing WMS field name MyCashflow field name
Article ⇒ Article numberVariation* ⇒ Product code
Article ⇒ BarcodeVariation* ⇒ Stock item ⇒ Barcode
Article ⇒ Customer priceVariation* ⇒ Price
Article ⇒ NameCombination of Product ⇒ Name and Variation ⇒ Name
([Product name] - [Variation name])
Article ⇒ Alternative namesVariation* ⇒ Translations
Article ⇒ PriceVariation* ⇒ Price
Article ⇒ Net weightProduct ⇒ weight
Article ⇒ Product codeCombination of Product ⇒ Id and variant ⇒ id
([Product id]-[Variation id])
Article ⇒ Purchase priceVariation* ⇒ purchase price
Article ⇒ Supplier article numberProduct ⇒ Supplier code
Article ⇒ Vat code ⇒ Vat percentProduct ⇒ Vat rate

* For products without variations the corresponding info from the main product is used.

Filters

By default, all articles that have been updated in MyCashflow will be synced to Ongoing WMS.

Orders

The WMS downloads new and updated orders which are not yet handled. If an order is updated, the change is transferred unless the warehouse workers have started working on it.

If an order is updated to status "Cancelled" in MyCashflow the corresponding order will be cancelled in Ongoing, if possible.

Field mapping

Show field mapping

Ongoing WMS field name MyCashflow field name
Order info ⇒ Customer priceOrder ⇒ Total
Order info ⇒ Customs currency codeOrder ⇒ TaxSummary ⇒ Tax rate
Order info ⇒ Order numberOrder ⇒ Id
Order info ⇒ Order remarkCombination of Order ⇒ Comments, where the visibility is "Public"
Order info ⇒ Goods owner order idOrder ⇒ Id
Order info ⇒ Way of deliveryOrder ⇒ Shipping method
Customer ⇒ AddressOrder ⇒ Shipping address ⇒ Street address
Customer ⇒ CityOrder ⇒ Shipping address ⇒ City
Customer ⇒ Country codeOrder ⇒ Shipping address ⇒ Country
Customer ⇒ EmailOrder ⇒ Shipping address ⇒ Email
Customer ⇒ Mobile phoneOrder ⇒ Shipping address ⇒ Phone
Customer ⇒ NameOrder ⇒ Shipping address ⇒ First name + LastName or
Order ⇒ Shipping address ⇒ Company
Customer ⇒ Post codeOrder ⇒ Shipping address ⇒ Postal code
Order line ⇒ External order line codeOrder line ⇒ Id
Order line ⇒ Line priceOrder line ⇒ Unit price x quantity
Order line ⇒ Number of itemsOrder line ⇒ Quantity
Order line ⇒ Product codeCombination of Order line ⇒ Product id and
Order line ⇒ Variation id
Order line ⇒ Total customs valueOrder line ⇒ Unit price x quantity

Filters

By default, any orders in status "Open" and "Cancelled" matching created or updated since last sync will be fetched. Note that if the order exists in Ongoing it will only be updated if the status of the order in Ongoing allows it to be updated!

Stock sync

Stock balance is sent from Ongoing WMS to MyCashflow by comparing the stock item quantity in MyCashflow with the quantity in Ongoing WMS.

Functions based on user actions

Outbound deliveries

When orders are fulfilled, the WMS performs quick processing of the order in MyCashflow. If the order has tracking information about that will be sent to MyCashflow.

Getting started

For Ongoing WMS to be able to activate the integration this information is needed from the customer:

  • Store name
  • Username and key for the API. The username will be an email address.

Please use the following documentation provided by MyCashflow to enable the API extension in the webshop and create API user.