# Warehouse Bin Location Master List Worksheet > Source: https://netray.co/tools/warehouse-bin-location-master-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable bin master with zone, aisle, bay, level, dimensions and computed volume. Exports to Excel for WMS or ERP location loading. ## Category supply-chain ## Industry Warehousing and Logistics ## Audience - Warehouse manager - Inventory control - WMS consultant ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Bin code **Key:** bin **Type:** text #### Zone **Key:** zone **Type:** select **Options:** - Receiving - Reserve - Forward pick - Bulk floor - Quarantine - Staging - Shipping #### Aisle **Key:** aisle **Type:** text #### Level **Key:** level **Type:** number #### Bin type **Key:** type **Type:** select **Options:** - Pallet rack - Shelf - Flow rack - Floor - Cantilever - Drawer #### Length (cm) **Key:** len **Type:** number #### Width (cm) **Key:** wid **Type:** number #### Usable height (cm) **Key:** hgt **Type:** number #### Volume (m3) **Key:** vol **Type:** number **Expr:** len * wid * hgt / 1000000 **Format:** decimal #### Max weight (kg) **Key:** maxwt **Type:** number #### Pick face **Key:** pickable **Type:** select **Options:** - Yes - No **Rows:** **Bin:** A-01-01 **Zone:** Forward pick **Aisle:** A **Level:** 1 **Type:** Shelf **Len:** 120 **Wid:** 60 **Hgt:** 45 **Maxwt:** 150 **Pickable:** Yes **Bin:** A-01-02 **Zone:** Forward pick **Aisle:** A **Level:** 2 **Type:** Shelf **Len:** 120 **Wid:** 60 **Hgt:** 45 **Maxwt:** 150 **Pickable:** Yes **Bin:** B-04-01 **Zone:** Reserve **Aisle:** B **Level:** 1 **Type:** Pallet rack **Len:** 120 **Wid:** 100 **Hgt:** 150 **Maxwt:** 1000 **Pickable:** No **Bin:** B-04-02 **Zone:** Reserve **Aisle:** B **Level:** 2 **Type:** Pallet rack **Len:** 120 **Wid:** 100 **Hgt:** 150 **Maxwt:** 1000 **Pickable:** No **Bin:** QA-01 **Zone:** Quarantine **Aisle:** Q **Level:** 0 **Type:** Floor **Len:** 240 **Wid:** 120 **Hgt:** 180 **Maxwt:** 1500 **Pickable:** No **Bin:** STG-03 **Zone:** Staging **Aisle:** S **Level:** 0 **Type:** Floor **Len:** 240 **Wid:** 120 **Hgt:** 200 **Maxwt:** 2000 **Pickable:** No **Totals:** #### Total storage volume (m3) **Key:** vol **Agg:** sum **Format:** decimal #### Total weight capacity (kg) **Key:** maxwt **Agg:** sum **Format:** number **Summary:** #### Average volume per bin (m3) **Key:** avg_vol **Expr:** sum_vol / count **Format:** decimal #### Number of bins **Key:** bin_count **Expr:** count **Format:** integer **Primary:** true **Notes:** Keep bin codes short, unique and consistent, for example aisle-bay-level. Check the field lengths and allowed characters of your WMS or ERP before loading. Usable height is the clear height inside the bin, not the beam-to-beam distance. ## Content **Intro:** Every WMS and most ERP warehouse modules start with a location master. Getting dimensions, types and zones right before go-live avoids a long tail of putaway errors. This worksheet gives you a structured list you can finish in Excel and load. **Sections:** #### How to use the worksheet **Body:** Add one row per bin or storage position. Choose a zone and bin type, enter the three internal dimensions and the maximum weight, and the volume is computed for you. Use the totals to check that overall capacity matches your layout drawing. Export to Excel, then map the columns to your system's location upload template. Review the list with the people who will actually pick and put away, since they know which racks are unreachable. #### Naming convention and structure **Body:** A good bin code is readable by a person and sortable by a system. Aisle, bay and level in a fixed pattern allow walking-order pick paths and make labels obvious. Avoid reusing codes after a layout change, because history in the ERP refers to the old position. Keep special zones such as quarantine, returns and staging clearly named so they are easy to exclude from available stock. **Bullets:** - Fixed-length codes sort correctly in lists - Separate pick faces from reserve locations - Flag quarantine and staging as non-available - Level zero for floor positions is a common convention #### Why dimensions and weight matter **Body:** Volume and weight limits feed putaway strategies, capacity checks and slotting analysis. If every bin is created with identical default dimensions, the system cannot tell a shelf from a pallet position, and putaway suggestions will be wrong. Even approximate dimensions are better than defaults. Weight limits also matter for safety, especially on upper rack levels. #### Common mistakes **Body:** Teams often create locations by copying a single sample, forget to mark non-pickable reserve, or include temporary floor spots as permanent bins. Another mistake is loading the whole list without a pilot of a few aisles. Load a small set, run receipts and moves, and fix the pattern before loading thousands of rows. **Cta:** If you are cleaning up location data across several warehouses or ERPs, we can help review it with a private model that runs on your own data. **Faq:** #### What is a bin location master? **Answer:** It is the list of all physical storage positions in the warehouse, each with a unique code and attributes such as zone, type, dimensions and capacity. WMS and ERP systems use it to direct putaway, picking and counting. #### How should I name warehouse bins? **Answer:** Use a short, fixed pattern such as aisle-bay-level, with consistent zero padding so lists sort correctly. Keep it readable on a label from a distance and avoid characters your barcode scanners or system do not support. #### Do I need dimensions for every bin? **Answer:** Ideally yes, at least by bin type. Dimensions enable capacity checks and putaway rules. If you start with typical values per type, refine them later where the actual size differs. #### Can I load this directly into SAP or Oracle? **Answer:** Not directly. Use it as a clean source list, then map the columns to the load template or API your system requires. Each platform has its own field names, length limits and mandatory attributes. ## Search terms warehouse bin location list excel, bin location master template, warehouse location naming convention, wms location master data template, bin location spreadsheet, warehouse rack location worksheet, location master data load, storage bin capacity list --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json