Integration between Ongoing Warehouse and PowerOffice Go
Table of contents
Introduction
Ongoing Warehouse has developed an integration with the ERP system PowerOffice Go. This integration makes it possible for businesses which use PowerOffice Go to easily outsource their warehouse needs to a 3PL company which uses the Ongoing Warehouse WMS. The integration can also be used by businesses who run PowerOffice Go and who want to run their own warehouse using the Ongoing Warehouse WMS. By passing information electronically between PowerOffice Go and Ongoing Warehouse, many manual tasks concerning products and invoices are eliminated or reduced. As a complement to the integration, users of PowerOffice Go can also be given direct access to the WMS.
The integration works well together with the Ongoing workflow. It uses the PowerOffice Go API.
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
Products and invoices are synced automatically from PowerOffice Go to Ongoing Warehouse, every 15 minutes.Article registry
Products are read automatically from PowerOffice Go to Ongoing Warehouse. If a change is made in PowerOffice Go, it will be reflected automatically in Ongoing Warehouse.
Filters
By default, all products that have been updated in PowerOffice Go will be synced to Ongoing.
Field mapping
| Ongoing Warehouse field name | Power Office Go field name |
|---|---|
| ArticleDefinition ⇒ ArticleNumber | Product ⇒ Code |
| ArticleDefinition ⇒ ArticleName | Product ⇒ Name |
| ArticleDefinition ⇒ CustomerPrice | Product ⇒ SalesPrice |
| ArticleDefinition ⇒ PurchasePrice | Product ⇒ CostPrice |
| ArticleDefinition ⇒ BarCode | Product ⇒ Gtin |
| ArticleDefinition ⇒ ArticleDescription | Product ⇒ Description |
| ArticleDefinition ⇒ ArticleUnitCode | Product ⇒ Unit |
| ArticleGroup | Set to the first product group on the product |
Invoices
Invoices are read automatically from PowerOffice Go to Ongoing Warehouse.
Filters
By default, all invoices which are paid will be synced to Ongoing.
Field mapping
| Ongoing Warehouse field name | Magento field name |
|---|---|
| OrderInfo ⇒ GoodsOwnerOrderId | Invoice ⇒ Invoice id |
| OrderInfo ⇒ GoodsOwnerOrderNumber | Invoice ⇒ Order no |
| OrderInfo ⇒ DeliveryDate | Invoice ⇒ DeliveryDate (if set, else current date) |
| OrderInfo ⇒ TermsOfDeliveryType | Invoice ⇒ DeliveryTerm |
| OrderInfo ⇒ ProductionCode | Invoice ⇒ DocumentNo |
| OrderInfo ⇒ ReferenceNumber | Invoice ⇒ CustomerReference |
| OrderInfo ⇒ OrderNotification ⇒ Email | Invoice ⇒CustomerEmail |
| OrderInfo ⇒ OrderNotification ⇒ NotifyByEmail | Set to true if CustomerEmail is set |
| OrderInfo ⇒ OrderNotification ⇒ MobilePhone | Invoice ⇒Customer ⇒ PhoneNumber |
| OrderInfo ⇒ OrderNotification ⇒ NotifyBySms | set to true if PhoneNumber is set |
| Customer ⇒ Number | Customer ⇒ MailAddress/StreetAddress** ⇒ CustomerCode |
| Customer ⇒ Name | customer ⇒ MailAddress/StreetAddress** ⇒ Leagal Name + Name + LastName |
| Customer ⇒ Address | customer ⇒ MailAddress/StreetAddress** ⇒ Address1 |
| Customer ⇒ Address2 | customer ⇒ MailAddress/StreetAddress** ⇒Address2 |
| Customer ⇒ PostCode | customer ⇒ MailAddress/StreetAddress** ⇒ZipCode |
| Customer ⇒ City | customer ⇒ MailAddress/StreetAddress** ⇒ City |
| Customer ⇒ CountryCode | customer ⇒ mailAddress/StreetAddress** ⇒ CountryCode |
| Orderline ⇒ ExternalOrderLineCode | Invoice ⇒ Invoice Line ⇒ Id |
| Orderline ⇒ ArticleNumber | Invoice ⇒ Invoice Line ⇒ ProductCode |
| Orderline ⇒ NumberOfItems | Invoice ⇒ Invoice Line ⇒ Qty |
| Orderline ⇒ LinePrice | Invoice ⇒ Invoice Line ⇒ Qty * UnitPrice |
| Orderline ⇒ CurrencyCode | Invoice ⇒ CurrencyCode |
| Orderline ⇒ Discount | Invoice → Invoice Line ⇒ DiscountPercent |
| Orderline ⇒ CustomerLinePrice | Invoice → Invoice Line ⇒ NetAmount |
| Orderline ⇒ LinePrice | Invoice → Invoice Line ⇒ Qty * UnitPrice |
| Orderline ⇒ OrderLineComment | Invoice → Invoice Line ⇒ Description |
| OrderTextLine ⇒ ExternalOrderLineCode | Invoice ⇒ Invoice Line ⇒ Id |
| OrderTextLine ⇒ NumberOfItems | 1 |
| OrderTextLine ⇒ OrderLineComment | Invoice ⇒ Invoice Line ⇒ Description |
Invoice lines of type text is saved as order text lines in Ongoing WMS, and lines of other types are stored as order lines.
* = effected by filters or settings. The set value might vary, or it might not be used by default.
** = the delivery address is taken from customer ⇒ mailAddress if it is set, else from customer ⇒ streetAddress
Stock balance
Stock balance is sent from Ongoing Warehouse to the web shop.
Preparations
In order to configure this integration Onogoing Warehouse will need an Application Key and a Client Key to the PowerOffice Go API. Please ask PowerOffice to generate these.