Stock Levels

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

Requirements & Assumptions/Assertions

• It is assumed that warehouse names in Sage match location names in Linnworks exactly. The solution will match Linnworks locations to Sage warehouses and update the values of products in each location/warehouse accordingly
• The WriteOffCategory must be set in the Linnworks primary setup to allow stock levels to be decreased in Sage
• 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.

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 'Write Off' stock transactions to decrease Sage stock levels
• Import the stock transactions into Sage

Field Mappings

Sage Primary Mappings

Sage Field	Linnworks Field	Notes
Stock Code	SKU
Qty in stock	Stock Level
Warehouse	Location

Linnworks Primary Mappings

Linnworks Field	Sage Field	Notes
SKU	Stock Code
Location	Warehouse
Stock Level	Qty in stock
-	Reason	Required for Write Off stock transactions, set using WriteOffCategory