Warehouse and Stock Location Map
Organize locations and pick lists.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Create a workbook that organizes stock locations and pick lists. Warehouse layout (aisles, racks, shelves, bins): [LAYOUT]. Products and typical order patterns: [PRODUCTS_AND_ORDERS]. Staff and picking method: [STAFF_AND_METHOD]. Spreadsheet app: [SPREADSHEET_APP]. Return: 1. Location code scheme: format such as aisle-bay-level-bin (for example A-03-2-B), rules for numbering, and a table of the zones with their purposes. 2. Location master: Code | Zone | Capacity | Allowed product types | Status (empty, occupied, blocked) | Notes. 3. Stock by location: SKU | Description | Location | Quantity | Last counted | Lot or batch. 4. Slotting guidance: put fast movers close to packing and between waist and shoulder height; heavy items low; related items nearby; separate items easily confused. A formula-based score for placing items by pick frequency. 5. Pick list generator: from an order table, a formula or filter that lists the SKUs, quantities, and locations sorted in walking order (by aisle and bay). 6. Cycle counting: schedule by class (frequent for fast movers), a count sheet, and a variance report with an acceptance threshold. 7. Checks: SKUs with no location, locations over capacity, and duplicates. Provide formulas for my app, a sample of 20 locations with expected output, and a label printing guide.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.