Sage Code Restrictions.
A requirement of Woosage50 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.
- Create a default SKU on Sage as a non-stock item
- Omit the SKU from the website product and Woosage50 can substitute the Default SKU, which must be added in the Woosage50>Settings>Advanced (Use Default if SKU missing)
- You can also allow Woosage50 to substitute a Default SKU if the SKU is not found in Sage (Woosage50>Settings>Advanced, Use Default if SKU not found)
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.