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.