Warehouse Overview

Warehouse Overview provides a complete view of all inventory in your warehouse. See every bin with detailed information including SKU, quantity, location, bin category, and more. Filter by account or location, customize visible columns, and perform bulk actions on multiple bins at once.

Quick Access

Navigate to Warehouse from the Inventory menu (accessible via /warehouse.php) to view all warehouse inventory. Requires Order_List_Processing_A permissions.

Why Use Warehouse Overview?

Complete Inventory View

See all bins in your warehouse with complete details including SKU, quantity, location, bin category, and product information.

Powerful Filtering

Filter inventory by account, location, or use advanced column filters to find specific bins quickly.

Customizable Columns

Show or hide columns based on your needs. Customize the view to focus on the information that matters most.

Bulk Actions

Select multiple bins and perform actions like blocking, relocating, editing volume, or printing labels all at once.

Export Data

Export inventory data to CSV or Excel format for reporting and analysis.

Quick Links

Access related features like Procedures, Locations, Serials, Bin Management, and Metadata directly from the page.

Accessing Warehouse Overview

1. Navigate to Warehouse

   Click Inventory from the warehouse menu, then select Warehouse (or navigate to /warehouse.php). The page loads showing all warehouse inventory.

2. View Inventory Table

   Browse the table showing detailed bin information: Location, LPN, Bin, Bin Category, Account, SKU, UPC, Description, Quantities, UOM, and more.

3. Apply Filters

   Use the filter dropdowns to filter by Account or Location, then click Apply filter.

4. Customize View

   Use the column selector to show or hide columns based on your needs.

Key Features

Inventory Table Columns

The Warehouse Overview table displays comprehensive bin information:

Location Information:

• Location - Warehouse location identifier
• LPN - License Plate Number (LPN) identifier
• Bin - Bin identifier (BIN)
• Bin Category - Category classification of the bin
• Bin tag - Additional tag identifier for the bin

Account & Product Information:

• Account - Company/account name (CompanyName)
• Client Opt1 - Client option field 1
• Picture - Product thumbnail image (if available)
• SKU - Product SKU identifier
• UPC/Barcode - Product UPC or barcode
• Description - Product description

Quantity Information:

• Qty in BIN (units) - Current quantity in the bin (QtyProductID)
• Qty in processing (units) - Quantity currently being processed (QtyProcessing)
  • Shows quantity reserved for orders in processing status
  • Can be hidden to improve performance for high-volume warehouses
• Total Quantity (units) - Total quantity including processing (QtyTotal)
  • Calculated as Qty in BIN + Qty in processing
  • Can be hidden to improve performance for high-volume warehouses
• Counts - Count value (shown when UOM is not set)
• UOM - Unit of Measure name (if UOM feature is enabled)
• Qty (packs) - Quantity in packs/units based on UOM (how_many)

Additional Details:

• Bin Volume - Volume capacity of the bin (UnitVolumenPrice)
• Weight/Dim - Product weight and dimensions (Weight, Length, Width, Height)
• Lot# - Lot number identifier
• Expir - Expiration date
• BOE - Best Before End date
• Last Updated - Date and time of last update (updated_at)

Filtering Inventory

Filter warehouse inventory using basic filters or advanced column filters:

Basic Filters:

1. Select Account

   Choose an account from the Account dropdown to filter by specific company.

2. Select Location

   Choose a location from the Location dropdown to filter by warehouse location.

3. Apply Filters

   Click Apply filter button to apply your selections.

4. Reset Filters

   Click Reset filter button to clear all filters and show all inventory.

Advanced Column Filters:

Each column has its own filter box below the column header. Use these filters to:

• Text filters - Type to search for specific values (Location, LPN, Bin, SKU, UPC, Description, etc.)
• Range filters - Enter minimum and maximum values for quantity columns
• Select filters - Choose from dropdown options for Account, Bin Category, UOM

Filters work together - multiple filters narrow down results further.

Android Request:

Click Android Request button to generate a request for Android mobile app users. This creates a filtered view that can be accessed from mobile devices.

Customizing Column Visibility

Show or hide columns to customize your view:

1. Open Column Selector

   Click the Hide columns dropdown button (shows selected column count).

2. Toggle Columns

   Check or uncheck columns to show or hide them:

   • Location - Warehouse location
   • LPN - License Plate Number
   • Bin - Bin identifier
   • Bin Category - Category classification
   • Account - Company name
   • Client Opt1 - Client option field
   • Picture - Product images
   • SKU - Product SKU
   • UPC/Barcode - Product barcode
   • Description - Product description
   • Qty in BIN (units) - Current quantity
   • Qty in processing (units) - Processing quantity (performance note shown)
   • Total Quantity (units) - Total quantity (performance note shown)
   • Counts - Count value
   • UOM - Unit of Measure
   • Qty (packs) - Pack quantity
   • Bin tag - Bin tag identifier
   • Bin Volume - Volume capacity
   • Weight/Dim - Weight and dimensions
   • Lot# - Lot number
   • Expir - Expiration date
   • BOE - Best Before End
   • Last Updated - Update timestamp

3. Save Preferences

   Column visibility preferences are saved automatically for your user account.

Performance Tip

For warehouses with high volumes of data, consider hiding “Qty in processing (units)” and “Total Quantity (units)” columns to improve page load times. These columns require additional calculations.

Bulk Actions on Bins

Select multiple bins and perform actions on them:

Selecting Bins:

1. Select Individual Bins

   Check the checkbox next to each bin row to select it.

2. Select All Bins

   Check the Select All checkbox in the table header to select all visible bins.

3. View Selection

   Selected bins are highlighted. The selection persists as you navigate pages.

Available Bulk Actions:

Click the Actions dropdown button to access bulk actions:

Bin Actions:

• Kill Bin - Delete selected bins (permanent removal)
• Edit Volume - Change bin volume for selected bins
• Relocate Bin - Move selected bins to a different location
• Block Bin - Block selected bins (prevents picking)
• Unblock Bin - Unblock selected bins (restore to available)

Print Labels:

• Print 5 Bins in each 4x6 label - Print bin labels (5 bins per 4x6 label)
• Print warehouse Labels - Print warehouse location labels
• Print products description Labels - Print product description labels

Performing Bulk Actions:

1. Select Bins

   Check the boxes next to bins you want to act on.

2. Choose Action

   Click Actions dropdown and select the desired action.

3. Confirm Action

   Follow prompts to confirm the action (some actions require additional information).

4. Review Results

   System shows success message or any errors encountered.

Editing Bin Volume

Change the volume capacity of one or more bins:

1. Select Bins

   Check the boxes next to bins you want to edit.

2. Open Edit Volume

   Click Actions → Edit Volume.

3. Enter Volume

   In the modal, enter the new volume value (required field).

4. Save Changes

   Click Save to update volume for all selected bins.

Relocating Bins

Move bins to a different warehouse location:

1. Select Bins

   Check the boxes next to bins you want to relocate.

2. Open Relocate

   Click Actions → Relocate Bin.

3. Choose Destination

   In the modal, select the destination location from the dropdown.

4. Confirm Relocation

   Click Relocate to move bins.

Relocation Notes

• Any LPN data will be removed from the bin during relocation
• Only bins with Qty > 0 can be relocated
• Relocation updates bin history for tracking

Blocking and Unblocking Bins

Blocking Bins:

Block bins to prevent them from being picked:

1. Select Bins

   Check the boxes next to bins you want to block.

2. Block Action

   Click Actions → Block Bin.

3. Confirm Block

   System blocks selected bins and updates bin category to “Blocked”.

Unblocking Bins:

Restore blocked bins to available status:

1. Select Blocked Bins

   Check the boxes next to blocked bins you want to unblock.

2. Unblock Action

   Click Actions → Unblock Bin.

3. Choose Method

   Select unblock method:

   • Old - Restore to previous category (from history)
   • New - Set to specific category

4. Select Category (if using “New” method)

   Choose the bin category to restore bins to.

5. Confirm Unblock

   System unblocks bins and restores them to selected category.

Blocking Rules

• Bins with category “Hurt” cannot be blocked
• Blocking changes bin category to “Blocked” (category ID 6)
• Unblocking restores bins to previous or selected category
• All blocking/unblocking actions are logged in bin history

Printing Labels

Print various types of labels for selected bins:

Print Bin Labels:

1. Select Bins

   Check the boxes next to bins you want to print labels for.

2. Choose Label Type

   Click Actions → Select label type:

   • Print 5 Bins in each 4x6 label - Standard bin labels
   • Print warehouse Labels - Warehouse location labels
   • Print products description Labels - Product description labels

3. Generate Labels

   System generates labels and opens print preview.

4. Print

   Use browser print function to print labels.

Exporting Inventory Data

Export inventory data for reporting or analysis:

CSV Export:

1. Apply Filters (Optional)

   Set up any filters you want to include in the export.

2. Export CSV

   Use the export button (if available) or browser export function to download CSV file.

3. Open File

   Open the CSV file in Excel or other spreadsheet application.

Excel Export:

1. Apply Filters (Optional)

   Set up any filters you want to include in the export.

2. Export Excel

   Use the export button (if available) to download Excel file.

3. Open File

   Open the Excel file with all formatted data.

Quick Links

Access related warehouse features directly from Warehouse Overview:

• Procedures - View and manage warehouse procedures
• MinMax bins - Manage minimum/maximum bin levels (if bin flow enabled)
• Bin Management - Advanced bin management tools
• Locations - Manage warehouse locations
• Serials - Serial number management (if enabled)
• Old Inventory Version - Access legacy inventory view (Bin_vlist.php)
• Metadata - Product metadata and attributes

Understanding Bin Categories

Bin categories classify bins by their status or purpose:

Common Categories:

• Available - Bins available for picking
• Blocked - Bins blocked from picking
• Hurt - Bins with damaged inventory
• Reserved - Bins reserved for specific purposes
• Other categories - As configured in your system

Bin category affects whether bins can be picked and what actions can be performed on them.

Understanding UOM (Unit of Measure)

If UOM feature is enabled, bins can track quantities in different units:

UOM Features:

• UOM Name - Unit of measure name (e.g., “Pack”, “Case”, “Pallet”)
• Unit Factor - Conversion factor between units and packs
• Qty (packs) - Quantity displayed in pack units
• Counts - Shown when UOM is not set

UOM Actions:

• Convert to Units - Convert packs to units (removes UOM)
• Convert Packs to Other UOM - Change UOM to different unit

UOM Availability

UOM feature must be enabled in system settings. Contact administrator if UOM columns are not visible.

💡 Best Practices

Use Filters Effectively

Start with Account or Location filters to narrow down large inventories. Then use column filters for specific searches.

Customize Your View

Hide columns you don’t need to focus on important information. Save your preferences for faster access.

Monitor Processing Quantities

Keep “Qty in processing” visible to track reserved inventory. Hide it only if performance is slow.

Use Bulk Actions

Select multiple bins for bulk operations like blocking, relocating, or printing labels to save time.

Export Regularly

Export inventory data regularly for backup and analysis. Use filters to export specific subsets.

Review Bin Categories

Monitor bin categories to ensure bins are properly classified. Block bins that need attention.

Troubleshooting

Can’t Access Warehouse Overview

Problem: Warehouse Overview page doesn’t load or shows access denied.

Solutions:

1. Verify you have Order_List_Processing_A user level permissions
2. Ensure you’re logged in with appropriate user level
3. Check if warehouse feature is enabled
4. Try refreshing the page
5. Contact administrator if access issues persist

No Data in Table

Problem: Warehouse Overview table is empty or shows no bins.

Solutions:

1. Clear all filters - you may have filters excluding all bins
2. Check if inventory exists in warehouse
3. Verify bins have been created and contain products
4. Try resetting filters using Reset filter button
5. Check if you’re filtering by wrong account or location

Filters Not Working

Problem: Applied filters don’t show expected results.

Solutions:

1. Click Apply filter button after selecting Account or Location
2. Verify filter values are correct (check spelling, format)
3. Clear filters and reapply one at a time to identify the issue
4. Check if multiple filters are conflicting
5. Refresh the page and reapply filters

Can’t Select Bins

Problem: Checkboxes don’t work or bins can’t be selected.

Solutions:

1. Wait for table to fully load - selection works after data loads
2. Check browser console for JavaScript errors
3. Try refreshing the page
4. Ensure you’re clicking the correct checkbox (not the row)
5. Try a different browser

Bulk Actions Not Working

Problem: Bulk actions don’t execute or show errors.

Solutions:

1. Verify bins are selected (checkboxes checked)
2. Ensure you have permissions for the action
3. Check if action is valid for selected bins (e.g., can’t relocate empty bins)
4. Review error messages for specific issues
5. Try selecting fewer bins at once
6. Refresh page and try again

Columns Not Saving

Problem: Column visibility preferences don’t persist.

Solutions:

1. Wait a moment after changing columns - preferences save automatically
2. Refresh page to see if preferences loaded
3. Check browser console for errors
4. Try logging out and back in
5. Clear browser cache and try again

Export Not Working

Problem: Export buttons don’t appear or don’t work.

Solutions:

1. Verify export feature is enabled in your system
2. Check if you have export permissions
3. Ensure filters are applied correctly before exporting
4. Check browser popup blockers
5. Try exporting a smaller subset of data
6. Contact administrator if export feature is not available

Performance Issues

Problem: Page loads slowly or times out.

Solutions:

1. Hide “Qty in processing” and “Total Quantity” columns
2. Apply filters to reduce data shown
3. Use Account or Location filters to narrow results
4. Reduce number of visible columns
5. Contact administrator if performance issues persist

Related Documentation

Next Steps:

• Bin Management - Advanced bin management and operations
• Locations - Manage warehouse locations
• Catalog Management - Product catalog overview
• Serials Management - Serial number tracking

Related Features:

• Picking Operations - Pick orders from warehouse
• Receiving - Receive inventory into warehouse
• Replenishments - Replenish inventory levels