Linnworks Desktop Documentation

Stock Level by Supplier Code Import

Overview
Linnworks recognises that not all sellers will use the same SKU as their suppliers. As such, when using the Linnworks Purchase Order functionality and importing information on stock levels from their suppliers, a useful option is for the ability to use the Supplier Stock Code instead of the SKU. The Supplier Code can be imported as part of the Inventory import.
Remember that, because this is a stock level import to reflect stock held by your supplier, the import should specify the correct location so as not to overwrite the local/default stock for the seller.
Data Import - Stock Level By Supplier Code

Table of Contents

NB! Imports of the same type will not launch simultaneously even if they are scheduled to start at the same time. Instead, such imports will be launched one by one consecutively to improve the performance of the import process.

  Options

This import has an additional option that is selected after column mapping is completed.

  • Zero Stock Levels When Item Not Provided: Using this option will zero the stock level in Linnworks for all stock items that are associated with this Supplier and Location that are not given as an entry in the data import file

This option has been designed to be used when you advertise stock based on your suppliers stock level. It is common that if an item is out of stock with a supplier, it is not included in their stock feed and so your stock level in Linnworks should be set to zero to reflect this. Please check with your supplier what their policy for out of stock SKUs in their stock feed before using this option.

NB! This import does not support batched items. Please use the Stock Level - Batch import instead.

Available Columns

Legend

Key Description
Compulsory This field is a compulsory requirement for the import. The data must exist as a column in the CSV and be mapped to the named field.
Additional This field relies on dependent data that is a compulsory requirement for the import. If this field is included in the import then the dependent fields must also be mapped.
Forbidden When the field is included in the import, the additional named field(s) are not permitted to be mapped and included in the import. Inclusion of both fields in the same import will prevent the import from executing.

Columns

Key Column Description Dependent fields
Compulsory Supplier Code The SKU / Item number code used by the supplier and assigned to the Supplier properties for a Linnworks inventory item  
Compulsory Supplier Name The name of the Supplier as defined in the Supplier properties of the Linnworks inventory item  
Compulsory Stock Level The quantity that the supplier has available in stock for you to advertise. If a Negative number is supplied in the import file the actual level in Linnworks will be set to zero  
Compulsory Location The name of the Linnworks location that is to be used record the stock level  

Example Files