Why is it needed?


If you change a setting in a channel integration config (for example apply a Max listed quantity, or End when quantity), the new values will be taken into account with the next inventory level trigger, for example when the stock level will be changed for the SKU (order downloaded, stock added or deducted etc). If you wish to apply the new settings for all SKUs at the same time, a stock trigger can be applied for the inventory, so that affected items will resubmit their stock levels to the channel, and those that already fall under the criteria will just remain as they are until their level actually does change.



IMPORTANT!

Stock Adjust is a process of changing stock levels, in order to avoid further discrepancies with the stock levels there are few things to remember before doing it:


1. Make sure that during triggering stock levels your orders are not processed. Stock Level Adjust and Order Processing, both procedures influence the stock levels of items in the system. Doing both of them at the same time can cause errors.

2. If you have just 1 item left and you adjust stock levels to -1 which will import 0 for the item, this can lead to the closure of listing. Same is for the opposite process if you have 0 stock and you adjust your stock levels to +1 this may lead to listing creation.

3. If you are not completely sure that you require stock level adjust, please check first with the support team.



How to perform a Stock Level Adjust?


To perform Stock Level Adjust an Inventory Import should be used. There is no need to know the current stock level of the SKU as 'Stock level adjust' column will be used. Please note that column 'Stock level' in the import will overwrite the stock level itself, whereas 'Stock level adjust' will simply add or deduct the quantity you specify during import.

If the 'Stock level adjust' column will have the value set as 1, then 1 will be added to all the levels from the file and if the column will be set to -1, then 1 will be deducted from the current level.

You will need a .csv file with the SKUs and other values can be set as a default value for the whole file (for example, +Default Value > select 'Location' from the drop-down box > add the name of the location):


Import this file through Linnworks.net > Settings > Import Data > Inventory Import, where 'SKU' column can be mapped to a relevant column in Linnworks.


The file will need to be imported twice: once with +1 (trigger the level up) and once with -1 value (restore the previous level).


If the update is required for the whole inventory, the list of SKUs can be retrieved from one of the reports in Dashboards - Query Data. For example, 'Stock Items (with levels)' will have a list of inventory items and some additional information. You may either delete the columns that are not required for this import, or you may leave them unmapped in the import.


Exception for Max Listed quantity set for channels


Please note that if there is a Max listed level applied to the SKUs, the process will slightly differ. In order to trigger a stock level submission to the channel where Max listed is applied, the actual stock level would need to be set as a value below Max listed first, and then back to the correct value. For this you will need to use the same inventory import, however, you will need to import the 'Stock level' column, instead of 'Stock level adjust', so essentially overwriting the stock level value for a brief time, before you will return it back.


Example:


Amazon channel, where max listed was applied as 30.

SKU ABC123 currently has 35 in stock. In order to trigger this stock level to be sent as 30, you will need to set it to any value below 30, for example, 29, and then back as 35.

The .csv file will look like this:


1st import:

SKU | Stock level | Location

ABC123 | 29 | Default


2nd import:

SKU | Stock level | Location

ABC123 | 35 | Default


Articles that might be useful:


Data Import - import types

CSV files. Hints & Tips