To display all bin locations and the products assigned to each of a warehouse, click on the desired warehouse under Lagerhaltung (Inventory Management) → Lager und Lagerplätze (Warehouses and Bin Locations). New bin locations can be created manually or via CSV import.
Helpful tips on organizing your warehouse and labeling your bin locations can be found, for example, here on our blog.
Define the sorting of bin locations
Usually, bin locations are displayed in alphanumeric order during picking with the WMS App. Using the Position field, you have the option to influence this order in order to adapt the sorting to the specific conditions of your warehouse. Bin locations with a defined position are displayed first accordingly, followed by all bin locations without a position in alphanumeric order.
Within the bin locations with a defined position, these are sorted in ascending order by their numeric value – so position 1 is reached before position 10. Multiple bin locations may be given 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 on Manuell hinzufügen (Add manually), enter the desired code, and then click on Bestätigen (Confirm).
Create a bin location via CSV import
If, for example, you want to create many bin locations at once, the CSV import is recommended. For this, you need a CSV file with the column Name, in which the bin location identifier is entered, and optionally the column Position, if you also want to assign a specific sorting to the bin locations.
Please make sure to also review our tips on handling CSV files in Shopware.
Export 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:
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 levels per bin location
When you click on one of the bin locations, you are taken to the stock overview, with the corresponding filters already set, so you can immediately see which products are available in which quantities at the bin location.
Rename bin locations
You can also rename existing bin locations afterwards in the administration.
This is particularly helpful if you have already booked stock to a bin location that is to be renamed in the future – for example, because you use the same storage location for POS and shipping stock. The advantage here: your stock history remains completely intact when renaming. Manual restocking is not required.
Here's how to proceed:
Open the Lagerhaltung -> Lager und Lagerplätze (Inventory Management -> Warehouses and Bin Locations) area in the Shopware Administration.
Select the desired warehouse and open the Lagerplätze (Bin Locations) tab.
Double-click on the name of the affected bin location, or click on the three dots at the end of the row and select Bearbeiten (Edit).
Adjust the name of the bin location.
Confirm with the blue checkmark or cancel the process with the cross at the end of the row.
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."