Installation and Setup of Woosage for Sage Accounting

Installation and Setup of Woosage for Sage Accounting

Woosage for Sage Accounting is intended to be a self-install application and everything you need to do this is contained is right here in just 4 easy steps.
  1. Install the Woosage plugin
  2. Add your subscription Identifier
  3. Authorise Woosage to access your Sage Accounting account
  4. Configure the plugin 
Less than 30 minutes and you are ready to go!

Each of the above steps is detailed in the following sections, but if you have any problems contact Woosage Support. with some information about the problem you are having.

Install the Woosage Plugin

To install the Woosage plugin carry out the following steps:
  1. Download the plugin ZIP file from here.
  2. On your website go to Plugins>Add Plugin.
  3. Click the Upload Plugin button at the top of the plugins page.
  4. Click Choose file and locate the downloaded plugin ZIP file, then click the Install now button.
  5. Click Activate.

Add your Subscription Identifier

When you sign-up for a subscription you will receive an email containing your subscription ID, which is an 18 character numeric code. This determines the edition and level of your subscription and must be entered in the plugin settings as follows:
  1. On your website go to WooCommerce>Woosage>Settings>Sage.
  2. Enter your subscription ID in the field provided.
  3. Click Save Settings button at the bottom of the page.
The subscription details will be returned and will be shown below the Subscription ID field, as shown below.


Authorise Woosage to access your Sage Accounting account

The same website page (WooCommerce>Woosage>Settings>Sage) is used to connect to Sage to authorise Woosage to access you Sage account, as follows:
  1. Click the Authorise Sage API access.
  2. you will be directed to your Sage account to authorise Woosage to access your Sage data.

Configure the plugin

Now you need to configure the settings to match your way of working with Sage Accounting and this is covered in the following sections.

Processing

This is accessed at WooCommerce>Woosage>Processing and is comprised of three independent process denoted by the following tabs:
  1. Stock - enables or disables stock processing, which is keeping WooCommerce and Sage synchronised and it shows the status of stock processing activity
  2. Products - enables or disables product processing, which is updating Sage product data (e.g. prices) on the website and controlling the creation and removal of products from the website. It also shows the status of product processing activity.
  3. Orders enables or disables order processing, which is importing order to Sage as sales invoices and it shows the status or order processing activity.

Orders Settings

The orders settings are accessed at WooCommerce>Woosage>Settings>Orders, and they determine how orders are validated by Woosage using a checkbox to enable each of the following settings.
  1. Allow missing SKU in line items - enabling this will mean Woosage will allow order line items where the SKU is missing, which is useful is you have item on the website that are not in Sage, such as drop-shipped items.
  2. Allow SKUs not in Sage - enabling this will mean Woosage will not throw an error is a SKU is not found in Sage, but will import the order as a sales invoice. Again, this may be useful for drop-shipped, non-stock or service items.
  3. Allow reposting to Sage - enabling this will mean Woosage will reprocess the same order more than once. This is useful is you amend website order and wish to reimport them (you must first mark them as pending again in the WooCommerce Orders page, so that Woosage will pick them up again).
  4. Allow order with zero total - enabling this will mean Woosage will process order that have a zero order total value. This is useful if you want Sage to record invoice for things like free samples.

Products Settings

The product settings are accessed at WooCommerce>Woosage>Settings>Products, and they control how products are updated, created or removed on the website, as follows:
  1. Enable Price updates from Sage - if enabled, Woosage will update the Regular website prices form Sage.
  2. Price lists to update from Sage - tick the checkboxes to enable each price list, which will then be assigned to a user role of the same name by Woosage. The roles can then be added to user accounts to assign the price list.
    1. Note 1: the price list will only appear if connected to Sage.
    2. Note 2: the website regular prices are set from the Sales Price in Sage, which is a price list that will appear in the list of price lists
    3. Note 3: the Sales Price list may have a different name, but it is the first one in the list of price names, which can be found at Sage>Settings>Business Settings>Record and Transaction Settings>Products & Services>Product Prices, where it can also be amended.
  3. Force disallow backorders - enabling this will override the WooCommerce Allow Backorder setting to prevent stock going negative, which is not permitted in Sage.
  4. Update duplicate SKUs - by default, Woosage does not update duplicate SKUs, so enabling this setting will mean Woosage will update any duplicates, subject to the product status below.
  5. Which product statuses to ignore - tick the checkboxes to instruct Woosage to ignore each status type when updating products (e.g. if a product is draft and ignore drafts is check then it will not be updated).
  6. Which product data to update - tick the data items to enable Woosage to update them in the website from Sage. Other product meta is all other data in the Sage product.
  7. Which product type to process - tick the product types to update (e.g. ticking Non-stock products will instruct Woosage to update).
  8. Enable website product creation from Sage - if enabled, Woosage will create a draft product using the Sage data (labelled "Sage draft" ). Note: when creating a product all Sage data will be mapped to in the created product, not just the ones selected above.
  9. Enable website product removal from Sage - if enabled, Woosage will remove products from the website by changing it to a draft product if it marked as inactive or deleted in Sage. If it is subsequently marked as active in Sage, Woosage will publish the product. When a "Sage draft" product is deleted in Sage, having never been published in WooCommerce, it will be permanently deleted.

Invoices Settings

The invoice settings are accessed at WooCommerce>Woosage>Settings>Invoices, and they control how invoices are imported to Sage, as follows:
  1. Sales ledger account - Select how Woosage will set the invoice sales ledger: either use Sage settings or specify a ledger account (adds the following setting).
    1. Sales ledger account override - specify the sales ledger account for invoices.
  2. Invoice number prefix - Specify the prefix to use for sales invoices (the default is "SI-").
  3. Use Sage billing address - if enabled, Woosage will use the billing address from the Sage customer account, rather than the billing address in the website order.
    1. Note: if using a default customer account Woosage will always use the billing address from the website order.
  4. Use Sage delivery address - if enabled, Woosage will use the delivery address from the Sage customer account, rather than the delivery address in the website order. 
    1. Note: if using a default customer account Woosage will always use the delivery address from the website order.
  5. Billing contact name format - select the format of the billing contact name for invoices. This format is also used when creating new customer accounts.
  6. Delivery contact name format - select the format of the delivery contact name for invoices.
  7. Disable invoice email - by default, Woosage will email invoices to  customer contacts Selecting YES will disable this feature and hide the following setting.
    1. Disable marking invoices as sent in Sage - by default, Woosage will mark invoices as sent in Sage. Selecting YES will disable this feature.
  8. Disable invoice payment button - selecting YES will cause Woosage will remove the payment button from invoices that have been fully paid. Selecting NO will include the payment button, even if the invoice has been paid.
  9. Add invoice link to My Account - selecting YES will cause Woosage will add a link to the invoice to "My Account" for customers that are logged in when orders are placed (not relevant to guest orders).

Customers Settings

The customer settings are accessed at WooCommerce>Woosage>Settings>Customers, and they control how Woosage deals with customer accounts in Sage. If present, Woosage will use the customer account set in the website user profile, if the order was placed while the customer was logged in. Alternatively, Woosage can use a default account or search for customers in Sage using the billing email address. If the account is not found Woosage will create new account with the following options.
  1. Search Sage for customer contacts? - select how Woosage will determine which customer contact to use for sales invoices: search on billing email address or use a default customer account (similar to a cash account that will be used for all orders, which must have a contact reference).
    1. Action if contact not found - if the search option was selected, then select the action to be taken if the customer contact is not found: create new contact or use a default customer account (with the reference specified in the following setting).
      1. Note: Woosage will always create a new contact is no company name is present in the website order.
    2. Default contact reference - if the default account was selected, then specify the reference of the Sage customer contact to be used as the default customer account for invoices.
  2. Force customer name to uppercase - if enabled, Woosage will force customer names to upper case.
  3. Force customer address to uppercase - if enabled, Woosage will force customer addresses to upper case.

Payments Settings

The payment settings are accessed at WooCommerce>Woosage>Settings>Payments, and they control how payments are imported to Sage for each payment method (gateway) on your WooCommerce system. Note: if you are using payment gateways that do not take an actual payment (e.g. bank transfer) then they should not be included. 

Use the Add Row + button to add a row for each payment method and configure as follows:
  1. Web payment method - select the payment method from the dropdown list of installed payment gateways.
  2. Payment reference - select the payment reference form the dropdown list. Selecting Custom payment reference will display the following mandatory setting.
    1. Custom payment reference - enter your custom reference which can include the following placeholders that can be combined (e.g. **BCO** **SIN**)
      1. **WON** - replaced with website order number.
      2. **BNM** -  replaced with billing contact name.
      3. **BCO** - replaced with billing company name.
      4. **SIN** - replaced with Sage invoice number.
  3. Fee nominal - specify the nominal code of the ledger account that Woosage will add the payment fee to (this will only display for payment methods where the fee is deducted from the customer payment before paying out, such as Stripe or PayPal. The Sage default is 7900 (Bank Charges and Interest).

Taxes Settings

The taxes settings are accessed at WooCommerce>Woosage>Settings>Taxes, and they website tax codes are mapped to Sage tax codes.

Use the Add Row + button to add a row for each website tax code and configure as follows:
  1. WC Tax Code - select the website tax code to map from the dropdown list, which is populated from all the tax rates setup in WooCommerce>Settings>Tax.
  2. Sage Tax Code - select the Sage tax rate from the dropdown list, which is populated form Sage, so will only show when connected to Sage.
  3. Make default - we recommend enabling this for one of the tax lines, which will ensure orders process if a website product tax class has not been specified for an order line item.

Notifications Settings

The notifications settings are used to specify who and what is notified of issues that may occur with processing.  We strongly recommend that notifications are enabled at WooCommerce>Woosage>Settings>Notifications and the settings can be configured as follows:
  1. Enable email notifications - if enabled Woosage will report error or warnings to the email addresses provided in the next setting, according to the error types selected.
    1. Notification email addresses - click the Add email + button to an email address in the box that is display and repeat for each email address.
    2. Notify error type - select the type of errors to notify from the dropdown list.
      1. Note: selecting Custom will display all the errors and warning codes under the heading Custom codes for notifications, where you can specify errors & warnings, so email recipients will only be notified of occurrences of the selected codes
Note: if notifications are not enabled for all errors and warnings, then the only way to identify issues is via the logs or when they are displayed within product and orders.

Advanced Settings

The advanced settings are mainly used for troubleshooting and can be accessed at WooCommerce>Woosage>Settings>Advanced, as follows:
  1. Retrieve order from (inclusive) - this is automatically set to todays date by Woosage when the plugin is activated, but it can be manually edited at any time.
  2. Override Woosage Admin API key - used by Woosage development and support for debug purposes.
  3. Delete all Woosage data on uninstall - if enabled all Woosage data including settings and logs will be deleted when the plugin is uninstalled.
  4. Clear deleted SKUs - clicking the Clear Now button will delete all Sage draft products, so they can be re-created on the website if still present in Sage.
  5. Reset schedule hooks - clicking Rest now will force all schedule events to fire now.
  6. Re-install database tables - this will delete all Woosage database tables and recreate them. Note: this action cannot be undone.
  7. Enable Debug mode - if enabled additional information will appear in the Woosage header and footer. This is information primarily used by Woosage support, so they may request it.

Save Settings

If any settings are updated, you must click the Save Settings button to save the changes.



    • Related Articles

    • Create an optional Sage Accounting user for Woosage

      While this step is optional, we we recommend that you add a Woosage user to allow us to access Sage Accounting on your behalf when installing WoosageBCA or providing ongoing support. If you do not add an additional user for Woosage, then we will not ...
    • What is Woosage for Sage Accounting?

      Woosage is a plugin for your website that will integrate your WooCommerce shop with Sage Accounting (also known as Sage Business Cloud Accounting - formerly Sage One). Woosage Essentials Edition is available and has the following features: Imports ...
    • Running Woosage50 without Sage 50 Accounts installed

      Woosage50 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 ...
    • Woosage50 compatibility with the 64-bit version of Sage 50 Accounts V30

      Versions of Sage 50 Accounts from V30 onwards will be available as a 64-bit version to improve the performance and compatibility with other 64-bit applications. Sage are continuing to provide a 32-bit version but new version will no longer have ...
    • Setting Sage Customer Account Codes in the Customers Website Profile

      The Woosage50 plugin adds a field to the website user account profile (shown below) to allow the Sage Customer Account Code to be added to orders generated by the user (when logged on), so that the order is imported to the relevant Sage account. Add ...