Specter logo

Integration between Ongoing WMS and Specter

Specter is a Swedish ERP SaaS solution designed to support small and medium-sized retailers, brands and e-commerce businesses in improving and automating essential business processes across sales, purchasing, inventory, logistics and finance. Specter’s ERP and POS system seamlessly integrate digital and physical sales channels, providing intelligent features and integrations with leading e-commerce platforms, payment gateways, shipping services and 3PL solutions.

In this integration Specter contains the master information for articles, purchase orders and sales orders. Ongoing owns the information about the stock, which is synced back to Specter at regular intervals. By passing information electronically between Specter and Ongoing WMS, many manual tasks concerning articles and orders are eliminated or reduced. As a complement to the integration, users of Specter can also be given direct access to the WMS. For more information about Specter please see their website.

By using Ongoing WMS together with Specter you will be able to utilize functions such as scanning, batch-picking, warehouse maps and much more. Moreover, if you use Specter as your ERP you can easily be onboarded to a logistics provider (3PL) that uses Ongoing WMS.

Get started with Ongoing WMS and Specter today!

Table of contents

Scheduled functions

Some functions in the integration run on a schedule. Articles, purchase orders and sales orders are synced automatically from Specter to Ongoing WMS. The stock can be synced from WMS to Specter.

Article registry

Articles are read automatically from Specter to Ongoing WMS. If a change is made in Specter, it will be reflected automatically in Ongoing WMS.

Field mapping

Show field mapping

Ongoing WMS field name Specter field name
Article ⇒ NameArticle ⇒ Name
Article ⇒ Article descriptionArticle ⇒ Article comment
Article ⇒ Article numberArticle ⇒ Article no.
Article ⇒ Product codeArticle ⇒ Article id
Article ⇒ Article groupArticle ⇒ Article group
Article ⇒ BarcodeArticle ⇒ Barcode
Article ⇒ Main supplierArticle ⇒ Suppliers ⇒ Supplier name
Article ⇒ Country of origin codeArticle ⇒ Manufacturing country code
Article ⇒ Statistics numberArticle ⇒ Commodity code
Article ⇒ Purchase priceArticle ⇒ Buy price
Article ⇒ Customer priceArticle ⇒ Price excluding VAT
Article ⇒ PriceArticle ⇒ Stock price
Article ⇒ VAT codeArticle ⇒ VAT parcent
Article ⇒ VolumeArticle ⇒ Article volume
Article ⇒ WeightArticle ⇒ Article weight

Filters

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

Orders

Orders are read automatically from Specter to Ongoing WMS.

Field mapping

Show field mapping

Ongoing WMS field name Specter field name
Order info ⇒ Consignee order numberOrder ⇒ Customer reference
Order info ⇒ Delivery dateOrder ⇒ Delivery date
Order info ⇒ Free text 1Order ⇒ Internal comment
Order info ⇒ Goods owner order numberOrder ⇒ Order number
Order info ⇒ MarketplaceOrder ⇒ External webshop no.
Order info ⇒ Order notification ⇒ Mobile phoneOrder ⇒ Delivery address ⇒ Notify delivery mobile no
Order info ⇒ Order notification ⇒ Notify by smsOrder ⇒ Delivery address ⇒ Notify delivery by mobile
Order info ⇒ Order remarkOrder ⇒ Public comment
Order info ⇒ Prepared transport document IDOrder ⇒ Prepared shipment ID
Order info ⇒ Reference numberOrder ⇒ Reference
Order info ⇒ Sales codeOrder ⇒ Invoice address attention
OR
Order ⇒ Delivery address attention
Order info ⇒ Service point codeOrder ⇒ Agent no.
Order info ⇒ Transporter bulk IDOrder ⇒ Bulk ID
Customer ⇒ AddressCustomer ⇒ Delivery Address ⇒ Address
Customer ⇒ Address2Customer ⇒ Delivery address ⇒ Address2
Customer ⇒ Address3Customer ⇒ Delivery address ⇒ Address3
Customer ⇒ CityCustomer ⇒ Delivery address ⇒ City
Customer ⇒ Country codeCustomer ⇒ Delivery address ⇒ Country code
Customer ⇒ Customer numberCustomer ⇒ Customer id
Customer ⇒ External customer codeCustomer ⇒ Customer id
Customer ⇒ Invoice address ⇒ AddressCustomer ⇒ Invoice address ⇒ Address
Customer ⇒ Invoice address ⇒ Address2Customer ⇒ Invoice address ⇒ Address
Customer ⇒ Invoice address ⇒ Address3Customer ⇒ Invoice address ⇒ Address3
Customer ⇒ Invoice address ⇒ Post codeCustomer ⇒ Invoice address ⇒ Zip code
Customer ⇒ Invoice address ⇒ CityCustomer ⇒ Invoice address ⇒ City
Customer ⇒ Invoice address ⇒ Country codeCustomer ⇒ Invoice address ⇒ Country code
Customer ⇒ Mobile phoneCustomer ⇒ Mobile phone
Customer ⇒ NameCustomer ⇒ Firstname + Surname
OR
Customer ⇒ Company name
Customer ⇒ Organisation numberCustomer ⇒ Org number
Customer ⇒ Post codeCustomer ⇒ Delivery address ⇒ Zip code
Customer ⇒ TelephoneCustomer ⇒ Phone
Customer ⇒ VATNumberCustomer ⇒ Vat number
Order line ⇒ Article numberRow ⇒ Order line ⇒ Article no.
Order line ⇒ Currency codeOrder ⇒ Currency code
Order line ⇒ External order line codeRow ⇒ Row no
Order line ⇒ External order line idRow ⇒ Row id
Order line ⇒ Line priceRow ⇒ Row sum VAT + row sum price excl VAT
Order line ⇒ Number of itemsRow ⇒ No items * no items2
Order line ⇒ Order line commentRow ⇒ Description

Filters

By default, any orders matching the following filter in Specter is synced to Ongoing WMS. Note that if the order exists in Ongoing WMS, it will only be updated if the status of the order in Ongoing WMS allows it to be updated!

Show filters

Specter field name Default filter
Order ⇒ Order status ⇒ Delivery statusN
Order ⇒ Last change timeLater than the last time the integration synced

Purchase orders

Purchase orders are read automatically from Specter to Ongoing WMS.

Field mapping

Show field mapping

Ongoing WMS field name Specter field name
In order info ⇒ Goods owner order numberPurchase ⇒ Purchase no
In order info ⇒ In datePurchase ⇒ Delivery out date
In order info ⇒ Order datePurchase ⇒ Order date
Supplier ⇒ AddressPurchase ⇒ Supplier ⇒ Address
Supplier ⇒ Address2Purchase ⇒ Supplier ⇒ Address2
Supplier ⇒ Address3Purchase ⇒ Supplier ⇒ Address3
Supplier ⇒ CityPurchase ⇒ Supplier ⇒ City
Supplier ⇒ Country codePurchase ⇒ Supplier ⇒ Country code
Supplier ⇒ Post codePurchase ⇒ Supplier ⇒ Postal code
Supplier ⇒ Supplier NamePurchase ⇒ Supplier ⇒ Name
In order line ⇒ Article numberRow ⇒ Article no.
In order line ⇒ External order line idRow ⇒ Id
In order line ⇒ External order line codeRow ⇒ Number
In order line ⇒ Number of itemsRow ⇒ Quantity
In order line ⇒ Row priceRow ⇒ Row sum VAT + row sum excl VAT

Filters

By default, all orders that have been updated in the last 15 minutes in Specter is synced to Ongoing WMS. 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

By activating the stock synchronization the stock from Ongoing will be used to update the stock in Specter. The stock that will be updated in Specter is the physical stock.

Functions based on user actions

Outbound deliveries

When an order has been set to status Sent or Collected in Ongoing WMS a call is sent to the Specter API to create a delivery submit. In the delivery submit the number of items picked on each order row is reported to Specter. If tracking information is available it will be provided. It is possible in this step to create an invoice of the order in Specter, and also to trigger a delivery email to the customer from Specter. If an invoice is created, it will contain the number of items that is delivered.

Field mapping

Show field mapping

Ongoing WMS field name Specter field name
Order info ⇒ Goods owner order numberOrder id
Order info ⇒ Delivery dateDelivery date
Order line ⇒ Picked number of itemsNo of items
Order line ⇒ External order line codeRow no
Order line ⇒ WaybillPacket no
Options ⇒ Send delivery emailSend delivery email

Inbound deliveries

When a purchase order has been received by the warehouse a call should be sent to the Specter API to create a purchase delivery submit. In the purchase delivery submit the number of items received for each order row is reported to Specter. It is possible in this step to trigger a delivery email to the customer from Specter.

Field mapping

Show field mapping

Ongoing WMS field name Specter field name
In order info ⇒ Goods owner order numberOrder id
In order info ⇒ Delivery dateDelivery date
Order line ⇒ Received number of itemsNo of items
Order line ⇒ External order line idRow id
Options ⇒ Send purchase delivery emailSend delivery email

Get Started

To configure this integration Ongoing WMS will need the following:

Please contact Specter for retrieving this information.

Please see this guide on how to set up an integration between Specter and your Ongoing WMS.