Specter logo

Integration between Ongoing Warehouse and Specter

Table of contents

Introduction

Specter is an e-commerce solution developed in Sweden. At the time of writing the platform is used by over 1500 companies. There are two integrations between Specter and Ongoing. This integration is fully built and supervised by Ongoing. The other integration is split into two parts, where Specter is responsible for one and Ongoing for the other part. 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 Warehouse, 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.

The integration works well together with the Ongoing workflow. It uses the Specter API. Most functions run every 15 minutes, but some functions are based on user actions.

Note that the information in this document might differ from your particular integration, if any special requests were made during the implementation of the integration.

Scheduled functions

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

Article registry

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

Field mapping

Show field mapping

Ongoing Warehouse field name Specter field name
Article ⇒ Article descriptionArticle ⇒ Article comment
Article ⇒ Article numberArticle ⇒ Article no.
Article ⇒ BarcodeArticle ⇒ Barcode
Article ⇒ Customer priceArticle ⇒ Buy price
Article ⇒ NameArticle ⇒ Name
Article ⇒ PriceArticle ⇒ Stock price
Article ⇒ Product codeArticle ⇒ Article id
Article ⇒ VolumeArticle ⇒ Article volume
Article ⇒ WeightArticle ⇒ Article weight

Filters

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

Orders

Orders are read automatically from Specter to Ongoing Warehouse.

Field mapping

Show field mapping

Ongoing Warehouse field name Specter field name
Order info ⇒ Delivery dateOrder ⇒ Delivery date
Order info ⇒ Goods owner order numberOrder ⇒ Order number
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
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. 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!

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

Field mapping

Show field mapping

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

Functions based on user actions

Outbound deliveries

When an order has been set to status Sent or Collected in Ongoing 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 mail 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 Warehouse 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 purhcase 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 mail to the customer from Specter.

Field mapping

Show field mapping

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

Preparations

In order to configure this integration Onogoing Warehouse will need the following:

Please contact Specter for retreiving this information.