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
| Ongoing WMS field name | MyCashflow field name |
|---|---|
| Article ⇒ Article number | Variation* ⇒ Product code |
| Article ⇒ Barcode | Variation* ⇒ Stock item ⇒ Barcode |
| Article ⇒ Customer price | Variation* ⇒ Price |
| Article ⇒ Name | Combination of Product ⇒ Name and Variation ⇒ Name ([Product name] - [Variation name]) |
| Article ⇒ Alternative names | Variation* ⇒ Translations |
| Article ⇒ Price | Variation* ⇒ Price |
| Article ⇒ Net weight | Product ⇒ weight |
| Article ⇒ Product code | Combination of Product ⇒ Id and variant ⇒ id ([Product id]-[Variation id]) |
| Article ⇒ Purchase price | Variation* ⇒ purchase price |
| Article ⇒ Supplier article number | Product ⇒ Supplier code |
| Article ⇒ Vat code ⇒ Vat percent | Product ⇒ 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
| Ongoing WMS field name | MyCashflow field name |
|---|---|
| Order info ⇒ Customer price | Order ⇒ Total |
| Order info ⇒ Customs currency code | Order ⇒ TaxSummary ⇒ Tax rate |
| Order info ⇒ Order number | Order ⇒ Id |
| Order info ⇒ Order remark | Combination of Order ⇒ Comments, where the visibility is "Public" |
| Order info ⇒ Goods owner order id | Order ⇒ Id |
| Order info ⇒ Way of delivery | Order ⇒ Shipping method |
| Customer ⇒ Address | Order ⇒ Shipping address ⇒ Street address |
| Customer ⇒ City | Order ⇒ Shipping address ⇒ City |
| Customer ⇒ Country code | Order ⇒ Shipping address ⇒ Country |
| Customer ⇒ Email | Order ⇒ Shipping address ⇒ Email |
| Customer ⇒ Mobile phone | Order ⇒ Shipping address ⇒ Phone |
| Customer ⇒ Name | Order ⇒ Shipping address ⇒ First name + LastName or Order ⇒ Shipping address ⇒ Company |
| Customer ⇒ Post code | Order ⇒ Shipping address ⇒ Postal code |
| Order line ⇒ External order line code | Order line ⇒ Id |
| Order line ⇒ Line price | Order line ⇒ Unit price x quantity |
| Order line ⇒ Number of items | Order line ⇒ Quantity |
| Order line ⇒ Product code | Combination of Order line ⇒ Product id and Order line ⇒ Variation id |
| Order line ⇒ Total customs value | Order 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.
Preparations
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.