Skip to content

Stock Levels

The solution will export stock levels from Sage and use them to update stock levels in Magento.

Requirements & Assumptions/Assertions

  • The solution will only update the stock levels of a single source
  • It is assumed that stock levels are managed in Sage - the solution will overwrite the values in Magento with those from Sage
  • Sage SKU codes can only use capital letters, but Magento SKUs can use both upper and lower case. The solution will match SKUs in uppercase
  • The solution will update the 'Quantity' in Magento with the 'In Stock' in Sage. These fields do not take into account allocated stock

Zynk Process

  • Export modified products in from Sage
  • Convert the data into the Magento source item format
  • Upload the updates into Magento

Field Mappings

Magento Field Sage Field Notes
SKU Product Code
Quantity In Stock
Source code N/A Set using the SourceCode setting