Integration between Ongoing WMS and Abicart / Textalk
If you find yourself outgrowing Abicart's inventory functionality, encountering issues with picking and packing errors, or are simply seeking improved cost control over your warehouse operations, Ongoing WMS might be the warehouse management system for you. It offers a range of features, including batch-picking, efficient picking route suggestions, scanning compatibility with any device, automatic label printing, support for creating purchase orders, warehouse mapping, multi-warehouse support, and many other functionalities. Adopt Ongoing WMS to enhance warehouse efficiency and realize significant time and cost savings.
Furthermore, if you're contemplating outsourcing logistics to a 3PL, selecting one that utilizes Ongoing WMS will make life easy for you. As a completely web-based platform, you can get access to a customer portal where you’ll find relevant statistics as well as trusting that the integration process will be seamless, due to the readymade integration Ongoing has made.
About Abicart: Abicart is the largest provider of e-commerce solutions in Sweden, used by over 3900 shops. In some markets it is also known as Textalk. Their goal is to provide access to e-Commerce tools that make it easier for your customers to shop online. They also want to simplify the everyday life of shopkeepers by providing tools that facilitates ongoing administration. For more information about Abicart, see their website or Webshop API.
Table of contents
Features
Article registry
Ongoing WMS pulls article registry updates from Abicart. Abicart contains the master data.
Field mapping
| Ongoing WMS field name | Abicart field name |
|---|---|
| ArticleDefinition ⇒ BarCode | (Variant ⇒ overrides ⇒ ean) or (BaseArticle ⇒ ean) * |
| ArticleDefinition ⇒ Weight | (Variant ⇒ overrides ⇒ weight)/1000 or (BaseArticle ⇒ weight)/1000 * |
| ArticleDefinition ⇒ ArticleNumber | (Variant ⇒ overrides ⇒ articleNumber) or (BaseArticle ⇒ articleNumber) * |
| ArticleDefinition ⇒ IsStockArticle | true if (BaseArticle ⇒ stock ⇒ useStock) is true, else false |
| ArticleDefinition ⇒ ProductCode | (Variant ⇒ uid) or (BaseArticle ⇒ uid) * |
| ArticleDefinition ⇒ ArticleName | (BaseArticle ⇒ name) or (BaseArticle ⇒ name + ", " + ArticleChoiceOption ⇒ name) ** |
| ArticleDefinition ⇒ ArticleUnitCode | (BaseArticle ⇒ overrides ⇒ unit) or (Article ⇒ unit) ** |
| ArticleDefinition ⇒ ArticleGroup ⇒ ArticleGroupCode | null or (Article ⇒ articlegroup ) *** |
| ArticleDefinition ⇒ ArticleGroup ⇒ ArticleGroupName | null or (Articlegroup ⇒ name ) *** |
* Depends on if the article has a variant.
** Depends on if the article has a variant and on language settings.
*** Depends on the abicart setting in Ongoing.
Orders
Ongoing WMS automatically reads orders from the web shop. When orders are fulfilled, the WMS creates a shipment in Abicart and marks it as shipped. Also any payments will be captured.
Field mapping
| Ongoing WMS field name | Abicart field name |
|---|---|
| OrderInfo ⇒ OrderRemark | Order ⇒ note |
| OrderInfo ⇒ SalesCode | if (Order ⇒ customer ⇒ info ⇒ type == "business"): (Order ⇒ customer ⇒ name), else: null |
| OrderInfo ⇒ WayOfDeliveryType ⇒ Code | deliveryMethod ⇒ Uid |
| OrderInfo ⇒ WayOfDeliveryType ⇒ name | deliveryMethod ⇒ name * |
| OrderInfo ⇒ ReferenceNumber | null |
| Customer ⇒ IsVisible | true |
| Customer ⇒ CustomerNumber | Order ⇒ customer ⇒ deliveryAddress ⇒ name |
| Customer ⇒ Email | Order ⇒ customer ⇒ info ⇒ email |
| Customer ⇒ MobilePhone | (Order ⇒ customer ⇒ deliveryAddress ⇒ phoneMobile) ** |
| Customer ⇒ TelePhone | (Order ⇒ customer ⇒ deliveryAddress ⇒ phoneDay) *** |
| Customer ⇒ NotifyBySMS | Order ⇒ if (OrderInfo ⇒ MobilePhone is not null or empty): true, else: false |
| Customer ⇒ Name | if (Order ⇒ customer ⇒ info ⇒ type == "business"): (Order ⇒ customer ⇒ address ⇒ company), else: (Order ⇒ customer ⇒ deliveryAddress ⇒ name) |
| Customer ⇒ Address | Order ⇒ customer ⇒ deliveryAddress ⇒ address |
| Customer ⇒ Address2 | Order ⇒ customer ⇒ deliveryAddress ⇒ address2 |
| Customer ⇒ PostCode | Order ⇒ customer ⇒ deliveryAddress ⇒ postCode |
| Customer ⇒ City | Order ⇒ customer ⇒ deliveryAddress ⇒ town |
| Customer ⇒ CountryStateCode | Order ⇒ customer ⇒ deliveryAddress ⇒ state |
| Customer ⇒ CountryCode | Order ⇒ customer ⇒ deliveryAddress ⇒ country |
| Customer ⇒ NotifyByEmail | if (OrderInfo ⇒ Customer ⇒ NotifyBySMS is false) and (OrderInfo ⇒ Customer ⇒ info ⇒ email is not null or empty): true |
| CustomerOrderLine ⇒ ArticleNumber | OrderItem ⇒ articleNumber |
| CustomerOrderLine ⇒ ProductCode | OrderItem ⇒ article |
| CustomerOrderLine ⇒ ExternalOrderLineCode | OrderItem ⇒ uid |
| CustomerOrderLine ⇒ NumberOfItems | OrderItem ⇒ choices["quantity"] |
| CustomerOrderLine ⇒ LinePrice | (OrderItem ⇒ costs ⇒ total ⇒ exVat) - (OrderItem ⇒ discountInfo ⇒ exVat) |
| CustomerOrderLine ⇒ CustomerLinePrice | (OrderItem ⇒ costs ⇒ total ⇒ incVat) - (OrderItem ⇒ discountInfo ⇒ incVat) |
| CustomerOrderLine ⇒ CurrencyCode | OrderItem ⇒ costs ⇒ total ⇒ currency |
| CustomerOrderLine ⇒ OrderLineArticleItemStatus | null |
| CustomerOrderLine ⇒ DoPick | if (OrderItem ⇒ choices contains "quantity"): true, else: false |
* Depends on language settings.
** First non null of (Order ⇒ customer ⇒ deliveryAddress ⇒ phoneMobile), (Order ⇒ customer ⇒ address ⇒ phoneMobile), (Order ⇒ customer ⇒ address ⇒ phoneDay) or (Order ⇒ customer ⇒ address ⇒ phoneNight). If all are null: empty string.
*** First non null of (Order ⇒ customer ⇒ deliveryAddress ⇒ phoneDay), (Order ⇒ customer ⇒ deliveryAddress ⇒ phoneNight), (Order ⇒ customer ⇒ address ⇒ phoneDay) or (Order ⇒ customer ⇒ address ⇒ phoneNight). If all are null: empty string.
Stock balance
Stock balance is sent from Ongoing WMS to the web shop.
Default settings and considerations
The integration provides default settings which are suitable in most cases. However, there are some possibilities for customization.
-
Synchronization interval.
Default: Every 15 minutes. It is usually a suitable balance between responsiveness and band-width usage. -
Do you have any variant of your articles without unique article numbers? For example, colors, sizes, packaging.
Default: No. -
When should an order in Abicart be transferred to Ongoing WMS?
Default: No filter. It is possible to filter on delivery status and/or payment status. -
Should orders be reported to Abicart as partly delivered when partly delivered in Ongoing WMS (only available in Abicart PLUS)?
Default: No.
Getting started
For us at Ongoing WMS to implement the Abicart integration we need the following operations to be performed by you.
Communication interface
This is already prepared in Abicart BAS and PLUS, but needs to be activated. To activate this, send an email to support@abicart.se, attach your shop ID and ask them to activate the function "Integration med eget system".
API information
When the interface for communication is activated you need to retrieve the information Ongoing WMS needs. The needed information is listed below:
- Shop ID
- API key
Please see this guide on how to set up an integration between Abicart and your Ongoing WMS.