Skip to main content

How do I create bin locations?

To see all bin locations and their assigned products for a warehouse, click on the desired warehouse under Inventory Management → Warehouses and Bin Locations. New bin locations can be created manually or via CSV import.

You can find helpful tips on designing your warehouse and labeling your bin locations, for example, here on our blog.

Set the sorting order of bin locations

Bin locations are typically displayed in alphanumeric order during picking with the WMS App. Using the Position field, you can influence this order to adapt the sorting to specific circumstances in your warehouse. Bin locations with a defined position will be displayed first accordingly, followed by all bin locations without a position in alphanumeric order.

Within the bin locations that have a defined position, they are sorted in ascending order by their numerical value – so position 1 comes before position 10. Multiple bin locations can be assigned the same position; among themselves, they are then displayed again in alphanumeric order.

Create a bin location manually

To create a bin location manually, click Add manually, enter the desired code, and then click Confirm.

Lagerplätze_manuell.png

Create bin locations via CSV import

If you want to create several bin locations at once, for example, the CSV import is recommended. For this, you need a CSV file with the column Name, in which the bin location code is entered, and optionally the column Position, if you also want to assign a specific sorting order to the bin locations.

CSV_Lagerplätze anlegen.png

Please be sure to read our tips on working with CSV files.

Migrate bin locations from Shopware 5

If you want to export all bin locations from Shopware 5 as part of your migration, you can use the following SQL query. The warehouse code of the warehouse to be exported must be adjusted accordingly here:

SELECT bl.codeFROM pickware_erp_bin_locations bl     LEFT JOIN pickware_erp_warehouses wh ON wh.id = bl.warehouseid     WHERE bl.code != 'pickware_null_bin_location'     AND wh.code = 'Lagerkürzel' -- Hier das Lagerkürzel eintragen

View stock per bin location

If you click on one of the bin locations, you will be taken to the stock overview, where the corresponding filters are already set so you can directly see which products are present in which quantities at the bin location.

Rename bin locations

You can also rename bin locations that have already been created afterward in the administration.
This is especially helpful if you have already booked stock to a bin location that should be named differently in the future – for example, because you use the same storage location for POS and shipping stock. The advantage here: your stock history remains fully intact when renaming. Manual relocation is not necessary.

Here's how to proceed:

  1. Open the Inventory Management → Warehouses and Bin Locations section in the Pickware Administration.

    Lagerplatz 1.png

  2. Select the desired warehouse and open the Bin Locations tab.

  3. Double-click on the name of the affected bin location, or click the three dots at the end of the row and select Edit.

  4. Adjust the name of the bin location.

  5. Confirm with the blue checkmark or cancel the process with the cross at the end of the row.

    Lagerplatz 2.png

The following applies when renaming bin locations:

  • The name of a bin location must not be empty.

  • If another bin location already has the same name, the following error message appears:
    The bin location could not be saved. There is already another bin location with this name. Please use a different name.

Did this answer your question?