Skip to content

Sage 200

This integration allows you to connect your WooCommerce store with Sage 200, downloading customers, products, orders and refunds into Sage 200 and uploading stock levels and order updates Back into WooCommerce

List integration points:

sequenceDiagram    
    WooCommerce->>Zynk: Export Orders
    Zynk->>Sage: Import Customers
    Zynk->>Sage: Import Products
    Zynk->>Sage: Import Orders

    WooCommerce->>Zynk: Export Refunds
    Zynk->>Sage: Import Order Returns

    Sage->>Zynk: Export Despatched Orders
    Zynk->>WooCommerce: Import Order Updates

    Sage->>Zynk: Export Stock Levels
    Zynk->>WooCommerce: Import Stock Levels

Requirements and Assumptions

  • We do not recommend installing Zynk on a laptop due to the increased risk of the machine being turned off/closed or losing internet access.
  • The machine requires internet access.
  • The machine needs to be constantly on for Zynk to function correctly.
  • Zynk requires a Windows user to run on a schedule.
  • Zynk will log into Sage 200 using the Windows User.
  • Zynk must be installed on the same machine where a Sage 200 Client is available
  • You must have a Woo Commerce store that is v3.5 or higher.
  • A mapping between WooCommerce tax rates and Sage tax codes must be created. Please refer to the Sales Orders documentation for instructions on how to do this.
  • It is assumed that WooCommerce doesn't have the multiple stock locations

Settings

Setting Name Default Description
WebSalesAccount WEBGBP The default Sage account to use when importing orders
WebSalesAccountOnly False When set to True, the workflow will import all sales orders against the WebSalesAccount setting
OrderNominalCode Optional - if stated, all orders will use this nominal code
OrderUpdateStatus complete The status that the WoCommerce orders should be updated to once they have been despatched in Sage
CarriageSku SHIPPING The default SKU to use for shipping
PaymentMethod The Sage payment method to use
SumInventoryAcrossWarehouses False When set to True, the solution will sum the values of avaialble inventory for a product across all locations in Sage. If False it will only update WooCommerce with the values from the warehouse defined in PrimaryWarehouse
PrimaryWarehouse HOME When SumInventoryAcrossWarehouses is set to false, stock levels will be pulled from this warehouse only
UpdatePrices False When set to True, the workflow will update the WooCommerce product prices using the Sage product prices

Connecting to Sage 200

Please see our article for guidance on creating a Sage 200 connection.