Product Codes (AKA SKU or Stock Codes)

Product Codes (AKA SKU or Stock Codes)

Sage Code Restrictions.


A requirement of Woosage is that the SKU codes in WooCommerce must match the Product (Stock) codes on Sage in order to process orders and update website products.

While WooCommerce can have SKU codes up to 255 characters in length, Sage codes can be a maximum of 30 characters in length. By default, WooCommerce does not allow duplicate SKU codes (see below).

WooCommerce allows most visible characters (i.e. not tabs, line breaks etc), but will allow spaces (multiple continuous spaces are removed).

Sage codes can only use A-Z (uppercase only), 0-9 and the characters / . - # ! " $ % ( ) _ % but cannot include spaces or comma’s.  The the codes must be unique in Sage.

If you have items on the website that you do not update from Sage, but could be present in orders (e.g. non-stock or drop-shipped items) you can use the following features in Advanced Settings to ensure that the orders are processed in Sage, without having to add the items to Sage.
  1. Omit the SKU from the website and use a Default SKU in the Woosage Advanced Settings (Use Default if SKU missing)
  2. Allow Woosage to substitute a Default SKU if the SKU is not found in Sage (Woosage Advance Settings, Use Default if SKU not found)
  3. Create a "dummy" SKU on Sage and use the same SKU for all these items (this requires you to allow duplicate SKU in WooCommerce - see Enable Duplicate SKUs in WooCommerce
If you are forced to have SKU codes in WooCommerce that include spaces, which are not compatible with Sage (e.g. your SKUs are imported from a product feed) the you can use the replacement character substitution in the Advanced settings.  Woosage will then replace the spaces with your chosen character (e.g. "-") so that they can be matched in Sage. The space character can be replaced by any character allowable in Sage.
    • Related Articles

    • Stock Updates

      The Pro version of Woosage uses Sage as a stock master and will update WooCommerce with any updated stock quantities for products on the website. The Sage products that will have their stock level pushed to the website are marked with a Publish to ...
    • Woosage50 Professional - Stock Updates

      The Professional version of Woosage50 has the option to update website stock quantities using Sage as a stock master by enabling stock updates in the product settings. Stock Update Process Sage products that are to be updated on the website are ...
    • Variable Product Stock and Price Update Considerations

      Variable products can be seen as a hierarchy, with the Variable Product as the parent and the Product Variations as the children.  Within WooCommerce each element (i.e. the parent variable product and each child variation) has a SKU and a number of ...
    • Woosage50 Product Settings

      The following provides additional information regarding some of Product settings to supplement the tooltips. Stock Updates If set to YES, Woosage50 will update website product stock for all active Sage products that have Publish To Web (PTW) ticked ...
    • Negative Stock & Backorders

      In order to allow backorders on the website and to keep the stock synchronised you must allow Sage to have negative stock amounts and set each product on the website to allow backorders. If both are enabled then the website will reduce stock beyond ...