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
StockLocationis set not set, the workflow will update the 'default' location in Linnworks
- If
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 |