Manually link products to warehouse locations using this app, then export assignments for stock tracking. 

This tool supports manual mapping between products and storage/picking locations. Users can import product and location lists, assign items one by one, and export the final allocation to CSV for stock system updates or visual inventory planning.

See also: "Generate Storage Location Barcodes"

Assign Products to Locations

This web application - made with the help of ChatGPT -  was designed to help warehouse operators and logistics coordinators organize and manage product placement inside storage facilities. With a simple interface and no installation required, it offers all the essential tools needed for manual product-location mapping.

Key Features

• CSV Import
  Import your list of warehouse locations and products using simple .CSV file.

• Location Type Detection
  The app automatically identifies storage and picking locations based on naming rules:

  • Locations ending in letters (e.g., L02A, L02B) are picking locations.

  • Locations without trailing letters (e.g., L02, L03) are storage locations.

• Product Dropdown with Name & Code
  Products are displayed in the format: Product_Code – Product_Name for easier selection.

• Manual Assignment
  Assign each product to a storage location and a picking location using dropdown menus.

• Temporary Storage in Browser
  All data is saved locally in your browser's memory (no login or cloud account needed).

• CSV file - Export
  Download your final assignment table as a CSV file ready to use in your warehouse operations.
  
  

File Types Supported

• Locations CSV (example):
  Location_Code
  L01
  L01A
  L02B
  
  

• Products CSV (example):
  Product_Code,Product_Name
  P001,Blue Box
  P002,Red Bucket

How to Use

1. Import your "locations.csv" and "products.csv" files.

2. Select a storage and picking location for each product.

3. Export the completed assignment list as a .CSV file.

We have prepared two small test files to verify the functionalities of the web application. You can download them by following the links below :

locations.csv

products.csv

Access the application by pressing the button "Product to Location" :