Stock Levels

The solution will export stock levels from the primary source and use them to update the other system

Requirements & Assumptions/Assertions

• The solution only updates the base stock levels, it doesn't update the allocated values in either system

• Composite Items: It is assumed that the stock levels of composite items in Linnworks is derived from the max available build from its component parts. The solution will not update the stock levels of composite/BOM items in either system, but will update the stock levels of the composite items, leaving Linnworks/Sage to calculate the available stock levels.

• If StockLocation is set not set, the workflow will update the 'default' location in Linnworks

Zynk Process

Sage Primary

• Export stock levels from Sage
• Transform into the Linnworks data fomrat
• Import the stock levels into Linnworks

Linnworks Primary

• Export stock levels from Linnworks
• Compare the stock level values between Linnworks and Sage:
• Create a 'Movement In' stock transaction to increase Sage stock levels
• Create 'Movement Out' stock transactions to decrease Sage stock levels
• Import the stock transactions into Sage

Note

Linnworks can handle negative stock quantities, so you will need to enable this in Sage as well

Field Mappings

Sage Primary Mappings

Sage Field	Linnworks Field	Notes
Stock Code	SKU
Qty in stock	Stock Level
N/A	Location	Uses the Setting StockLocation otherwise the location will be set to the 'default' location in Linnworks

Linnworks Primary Mappings

Linnworks Field	Sage Field	Notes
SKU	Stock Code
Last Update Date	Stock Transaction Date
Stock Level	Qty in stock