Linnworks Sage 200 Solution

This solution enables you sync products, orders and stock levels between Linnworks and Sage 200. The solution requires either Sage or Linnworks to be used as the primary source of stock information, with the other system being updated accordingly.

• Products
• Sales Orders
• Order Updates
• Inventory

Options

Option A: Sage Primary

Sage is the primary data source for stock. In this setup new products are created and stock levels are maintained in Sage and Zynk updates Linnworks to reflect this.

sequenceDiagram
    Sage ->> Zynk: Export Stock Records
    Zynk ->> Linnworks: Import Products

    Linnworks ->> Zynk: Export Open Orders
    Zynk ->> Sage: Import Sales Orders

    Sage ->> Zynk: Export Despatched Orders
    Zynk ->> Linnworks: Import Order Process Updates

    Sage ->> Zynk: Export Stock Inventory
    Zynk ->> Linnworks: Import Stock Level Updates

Option B: Linnworks Primary

Linnworks is the primary data source for stock. In this setup new products are created and stock levels are maintained in Linnworks and Zynk updates Sage to reflect this.

sequenceDiagram
    Linnworks ->> Zynk: Export Products
    Zynk ->> Sage: Import Stock Records

    Linnworks ->> Zynk: Export Open Orders
    Zynk ->> Sage: Import Sales Orders

    Sage ->> Zynk: Export Despatched Orders
    Zynk ->> Linnworks: Import Order Process Updates

    Linnworks ->> Zynk: Export Stock Levels
    Zynk ->> Sage: Import Stock Transactions

Settings

Setting	Default	Description
UpdatePrices	True	When set to True, prices in the primary system will be used to update the product prices in the other system
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
UseSourceAccount	False	When set to True the workflow will use the Linnworks source name as the Sage account reference
UseLinnworksOrderNumber	False	When set to True, the workflow will set the Sage Sales Order number to be the same as the Linnworks order number
CarriageSku	SHIPPING	The Sku to use for carriage lines on orders in Sage
OrderDefaultNominal		This setting can be used to set the nominal code on each sales order line in Sage
PaymentMethod		The payment method to be used in Sage. All payments will go through this method
WriteOffCategory		Only required when Linnworks is the primary data source - choose the 'Reason' for writeoffs in Sage when the stock level is reduced in Linnworks

Requirements and Assumptions

• Stock should be controlled from one system only - the workflow will use the values from the primary system to overwrite the values in the other system.
• A mapping between Linnworks tax rates and Sage tax codes must be created. Please refer to the Orders documentation for instructions on how to do this.

Connecting to Sage 200

To establish a connection with a Sage 200 Professional Company, Zynk must be installed on the same machine where a Sage 200 Client is available. Zynk logs in through the Windows user you set in the task scheduler. For more information, refer to our Sage 200 Connection Guide.