Linnworks Sage 50 Solution

This solution enables you sync products, orders and stock levels between Linnworks and Sage 50. 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 Name	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
OrderDefaultNominal		This setting can be used to set the nominal code on each sales order line in Sage
LinnworksLocation	Default	This setting can be used to set Location to update the Stock Records

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 stsyem.

• 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.

Connection to Sage 50

To connect to Sage 50, Zynk will require a Company DataPath along with a username and password for logging into Sage 50.

Please refer to our Sage 50 article for more information on creating a Sage 50 Connection.