InventoryPlanner logo

Integration between Ongoing WMS and Inventory Planner

Are you working with a sales forecasting system and consider adopting a Warehouse Management System (WMS) alongside it? Or working with a WMS and looking to add a sales forecasting system to the mix? Either way, Ongoing WMS with the Inventory Planner integration could be the choice for you! You’ll be powered by features from the WMS such as batch-picking, getting efficient picking routes, device-agnostic scanning to minimize errors, automatic label printing, bulk product editing, and many more. And with Inventory Planner functionality at your fingertips, you’ll be able to accurately forecast demand and optimize your purchases accordingly. The integration will deliver purchase orders from Inventory Planner directly to Ongoing WMS, based on real sales and article data.

Moreover, if your logistics is outsourced to a 3PL, or if you are 3PL looking for a reliable WMS, know that adding the Inventory Planner functionality to Ongoing WMS is super easy through this integration. Onboarding new customers to your warehouse is in general a breeze when working with Ongoing WMS due to our extensive integration library with 150+ integrations.

Get started with your FREE trial of Ongoing WMS and Inventory Planner today!

Table of contents

Get Started

To activate and use the integration to Inventory Planner the following setup and information is necessary.

  • To start generating inventory predictions Inventory Planner will need information about your sales and articles. This information can currently be provided either through an integration to one of the web shops mutually supported by Inventory Planner and Ongoing WMS or by CSV/Excel file exports and imports.
  • API key and Account Id of your Inventory Planner system. This information can be found in your Inventory Planner account, at Account ⇒ Settings ⇒ API. For further information see the Inventory Planner help pages or contact Inventory Planner.

When you have this information go to Administration->Integrations and emails, choose Inventory Planner in the list and fill in the necessary information.

Scheduled functions

The integration consists of the following functions which run on a scheduled basis. The scheduled processes can be independently switched on or off to match the expected functionality.

Sync purchase orders

Purchase orders are read automatically from Inventory Planner to Ongoing WMS after creation in Inventory Planner. Ongoing WMS will try to match the Vendor field of an Inventory Planner purchase order with an already existing supplier. If no such match can be found a new supplier will be created and linked to the purchase order.

Field mapping

Show field mapping

Ongoing WMS field name Inventory Planner field name
Purchase order info ⇒ Goods owner order numberPurchase order ⇒ ID
Purchase order info ⇒ Reference numberPurchase order ⇒ Reference
Purchase order info ⇒ In datePurchase order ⇒ Expected date
Purchase order info ⇒ Order datePurchase order ⇒ Created date
Purchase order info ⇒ SupplierPurchase order ⇒ Vendor
Purchase order line ⇒ Article numberline ⇒ Sku
Purchase order line ⇒ External order line IDline ⇒ ID
Purchase order line ⇒ Article nameline ⇒ Title
Purchase order line ⇒ Number of itemsline ⇒ Replenishment

Filters

By default, all orders that have been created in the last 15 minutes in Inventory Planner are synced to Ongoing WMS. Note that only orders with status Open will be synced to Ongoing WMS.

Report purchase orders

Purchase orders are automatically updated from Ongoing WMS to Inventory Planner when they have been received and processed.

Field mapping

Show field mapping

Ongoing WMS field name Inventory Planner field name
Received purchase order line ⇒ External order line idItem ⇒ ID
Received purchase order line ⇒ Received number of itemsItem ⇒ Received

Filters

By default, all orders that have been updated in the last 15 minutes in Ongoing WMS is synced to Inventory Planner. Note that only orders that have been processed in Ongoing WMS and are in status Received (or Deflection) will be reported back by default.