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

    • 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 ...
    • Updating the Woosage Service Log On Passwords

      If you Sage data resides on a server it may be require a dedicated account with specific permissions, rather than using the local system account, and this is usually setup when Woosage is installed (see this article) However, if your IT policy forces ...
    • Running Woosage without Sage 50 Accounts installed

      Woosage is usually installed on a PC that has Sage installed, but it can be installed without Sage, provided Sage Data Objects (SDO) is installed. SDO is the means by which third-party applications, such as Woosage, can access Sage data and carry out ...
    • Woosage 50 Processing Schedules

      Orders Processing Cycle The orders processing cycle deals with time-critical data, orders and stock updates, and is run normally according to a schedule. When running it will do the following. Get any unprocessed orders from the website and import ...
    • Sage Connection Issues

      Woosage connects (logs on) to Sage using the Username and Password from Settings>Sage at the start of each operation within the processing cycle and disconnects (logs off) when that operation is complete.  The Woosage login credentials from the ...