Stock per location import

You can perform multiple stock changes in Picqer at once with the Excel stock import function.

Importing stock

It is possible to import stock through the Products page via Import/Export.

For this you need a correctly formatted Excel file, check this support article to read how to prepare an Excel file for import.

Settings for importing stock

When importing stock into Picqer there are a number of settings you can choose from. Here we will explain these settings.

Methods

The method indicates how the stock change is carried out. Here are the choices to override or increase or decrease the stock.

If you choose to reduce the stock, you don't have to enter negative values in the Excel import. For example, if you want to lower the stock with 5 just enter "5".

Strategy

The strategy indicates at which stock location the stock change should be executed. Here you have the choice to use the stock location from the Excel file, to let Picqer choose a location or to only apply the changes to "No specific location".

• Stock location from the Excel file

  It is possible to specify a stock location in the Excel file. For this you specify per row what the stock location is based on the location name. Only 1 stock location can be given per row. If you want to change the stock for multiple locations you will need to add multiple rows.

  It is also possible to specify locations that are not yet linked to the product, we will then automatically link this location during the import.

• Let Picqer choose a location

  It is also possible to let Picqer choose a location on which the stock change should be executed. This is determined based on the following steps:

  1. If there is stock on "No specific location", we'll preform the stock change on "No specific location".
  2. If there is only 1 stock location linked to the product, we'll use this stock location.
  3. If multiple stock locations are linked, we will sort them based on most stock and/or if the location is not a bulk location. Then we will use the first location.

  When previewing the import, we will show at which stock location we will make the change.

• Changes to "No specific location"

  It is also possible to have all stock changes carried out on "No specific location". You can then easily move the stock in Picqer via the overview "Stock without location".