How Woosage50 Works

How Woosage50 Works

Woosage50 integrates the order processing and product management functions of WooCommerce and Sage 50 Accounts. It has two components.

Woosage50 Plugin - this is a plugin that is installed on your WooCommerce website. It is the Woosage50 control centre, providing the settings and schedules for processing orders and updating website product data from Sage. It also provides an API that allows secure interaction with the plugin by the Woosage50 Service.

Woosage50 Service - this is a Windows services that runs on PC or server on your local network* and it acts as a bridge between the Woosage50 plugin and Sage. It utilises the Woosage API to interact with the Woosage50 plugin and accesses the Sage data via the Sage interface (SDO & ODBC), 

* The Woosage50 Service can also run on a Windows Remote Desktop Server provided that it has access permissions to read and write to the Sage data

The relationship between the service and plugin is illustrated in the diagram below.



The Woosage50 Service runs two concurrent processes:

Orders - importing website orders to Sage and updating website stock quantities from Sage.
Products - updating website product and price data from Sage.

The service runs continuously, taking its processing instructions from the Woosage50 Plugin, which has user-defined schedules to determine when the orders and products cycles are to be run. It uses the Woosage API to contact the plugin to enquire if there are any processing activates to be carried out or if any settings have changed.  It then either carries out those instructions as follows, or sleeps for 60 seconds before repeating.

The orders cycle starts by requesting the plugin to deliver any unprocessed orders, and the settings, if changed. It then imports the orders to Sage according to the settings. Once the orders have been processed, the service gets the free stock from Sage for all web products, checks for any changes and sends them to the plugin to update the website stock quantities.

The products cycle gets the product & price data from Sage for all web products and sends this to the plugin in batches, pausing between each to allow for processing of the data.

The Woosage50 Plugin monitors the processing activity of the Woosage50 Service and displays the status Woosage50 website page.

This article is intended to give an overview of how Woosage50 works in simple terms and is not a detailed description of all operations.

    • Related Articles

    • How Woosage Works

      All of the processing is done by the Woosage Service, which runs in the background on a windows PC on the same local network as Sage. The Woosage Service handles all communications with Sage and the website. The system is depicted in the following ...
    • Moving Woosage

      Sometimes it is necessary to move Woosage to another PC or server and this is a fairly straight forward process. Download the latest version of the installer from here  Copy the database (woosage.db) from the existing server ...
    • Activating your Woosage Subscription

      Activating your Woosage Subscription To activate your subscription you will need your Subscription ID. This is an 18 digit code that you will have received in an email when you subscribed. If you can't locate you subscription ID, email ...
    • New Releases of Woosage

      From time to time we release new versions of the Woosage application to add new features and to ensure compatibility with the applications it interacts with (mainly Sage and WooCommerce). Installing a New Version Installing a new version is simply a ...
    • Woosage Windows Service Setup

      General Settings These settings are setup automatically when Woosage is installed.  The main setting is the Startup type, which is set to Automatic so that Woosage will automatically restart when the computer is restarted. Log On Settings By default ...