Pick Log

Pick Log provides a detailed view of every picking activity in your warehouse. See individual pick records with complete information including who picked each item, when it was picked, how long it took, and which bins were used. This detailed log helps you track picking performance, analyze productivity, and review complete picking history for any order.

Quick Access

Navigate to Picking from the warehouse menu and then Picking Log to view detailed picking activity records.

Why Use Pick Log?

Detailed Pick Records

See every individual pick activity with complete details including SKU, quantity, bin, location, user, and elapsed time.

Performance Tracking

Track picking times and user productivity. Identify which items take longer to pick and compare user performance.

Advanced Filtering

Filter by company, ship number, tray, pallet, box, order number, method, user, status, job, SKU, bin, location, or address.

Box Details

Click BoxID to view detailed box information including dimensions, weight, and pallet ID in a popup.

Export Data

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

Year Filtering

Filter by year or view last 3 months of activity. Access historical picking data easily.

Accessing Pick Log

1. Navigate to Picking Log

   Click Picking from the warehouse menu and then click on Picking log. The page loads showing all picking log records.

2. View Log Table

   Browse the table showing: Company, Ship#, Tray#, Pallet, BoxID, Order#, Method, User, Status, Job#, Sku, Units, Picked, Picked Status, Bin, Location, Elapsed time, and Address. Use Refresh to reload data.

3. Apply Filters

   Use column filters below each header to narrow down records. Filters apply automatically after 1 second delay.

4. View Box or Order Details

   Click BoxID to see box details in a popup. Click Ship# to open order details in a new tab.

Key Features

Log Table Columns

The Pick Log table displays comprehensive picking information:

Order Information:

• Company - Account/company name (Company_name)
• Ship# - Internal system order ID (Shipping_number), clickable link to view order details
• Tray# - Tray number identifier (traynum)
• Pallet - Pallet identifier (CartonId)
• BoxID - Box identifier (multibox_id), clickable link to view multibox details
• Order# - Customer order number (orderNum)

Picking Details:

• Method - Picking method and source (e.g., full_fill with Source: P&P, QC, etc.)
• User - Username of person who performed the pick (Username)
• Status - Current picking status:
  • done - Pick completed
  • loaded - Order loaded for picking
  • picked - Item picked
  • WaitingQC - Waiting for Quality Control
  • finishedQC - Quality Control finished
• Job# - Job identifier (job_id) if order is part of a picking job

Item Details:

• Sku - Product SKU that was picked
  • For full_fill method, shows badge with total item count instead of individual SKU
• Units - Total units in the order (qty)
• Picked - Quantity picked (picked)
  • For full_fill method, shows total units instead of picked quantity
• Picked Status - Picking completion status:
  • incomplete - Not all items picked (shown as warning badge)
  • Empty if complete

Location Information:

• Bin - Bin location where item was picked from (includes bin tag if available)
• Location - Warehouse location identifier
• Elapsed time - Time taken to pick this item (hours:minutes:seconds format)
  • Calculated from Start_time to End_time
  • Shows as tooltip with full time range
• Address - Customer shipping address (Address1 and Address2)

Table Toolbar

Use the buttons next to the table length selector:

• Refresh - Reloads the table data from the server
• Reset Filters - Clears all column filters at once

Column Filtering

Using Column Filters:

1. Locate Filter Box

   Find the filter input box below each column header.

2. Enter Filter Value

   Type your search value in the filter box. Filters apply automatically after 1 second delay.

3. Use Range Filter

   For Elapsed time, enter minimum and maximum values in the range filter boxes.

4. Clear Filter

   Clear the filter input to remove that column’s filter.

5. Reset All Filters

   Click Reset Filters button to clear all column filters at once.

Year Filtering

Filter log records by year or view recent activity:

Default View:

• Shows Last 3 months of picking activity by default

Year Selection:

1. Open Year Dropdown

   Click the year filter dropdown button (shows “Last 3 months” or “Logs [YEAR]”).

2. Select Time Period

   Choose from:

   • Last 3 months - Recent activity (default)
   • Logs [YEAR] - Specific year (e.g., “Logs 2024”)

3. View Filtered Data

   Table refreshes automatically showing only records from selected time period.

Export Options

Export Pick Log data for reporting or analysis:

CSV Export:

1. Apply Filters (Optional)

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

2. Click CSV Button

   Click the CSV button in the table toolbar.

3. Confirm Export

   If your query has more than 1,000 records, you’ll see a warning. Reduce filters if needed.

4. Download File

   CSV file downloads automatically with filename: picking_log_YYYY_MM_DD_HH_mm_ss.csv

Export Limits

Maximum export limit is 1,000 records. If your filtered query exceeds this limit, reduce filters or export in smaller batches.

Viewing Order Details

Click the Ship# link in any row to open the order in a new tab. The destination depends on the order status (Pending, Processing, Shipped, or All Orders). Each view shows full order details including items, shipping info, and status.

Understanding Status Values

Pick Status Types

done:

• Pick completed successfully
• Item fully picked and processed
• Ready for next step in fulfillment

loaded:

• Order loaded for picking
• Pick process started
• Items being collected

picked:

• Item picked from bin
• Pick in progress
• Not yet completed

WaitingQC:

• Pick completed, waiting for Quality Control
• Order ready for QC verification
• QC process not yet started

finishedQC:

• Quality Control completed
• Order verified and approved
• Ready for shipping

Picked Status

incomplete:

• Not all items in order have been picked
• Shown as warning badge
• Order needs more picking activity

Empty/Complete:

• All items picked
• No status badge shown
• Order picking complete

💡 Best Practices

Use Year Filter

Start with “Last 3 months” to focus on recent activity. Use year filters to access historical data when needed.

Filter by User

Filter by username to review individual picker performance. Compare picking times and identify training opportunities.

Check Elapsed Times

Review elapsed times to identify items that take longer to pick. This helps optimize bin locations and workflows.

Monitor Incomplete Picks

Filter by “Picked Status” to find incomplete picks that may need attention or follow-up.

Export Regularly

Export log data regularly for performance analysis. Track trends and identify bottlenecks over time.

Filter by Job

Filter by Job# to see all picks for a specific picking job.

Troubleshooting

Can’t Access Pick Log

Problem: Pick Log page doesn’t load or shows access denied.

Solutions:

1. Check that Distribution Jobs is enabled in system settings
2. Ensure you’re logged in with appropriate user level
3. Contact administrator if feature is not enabled
4. Try refreshing the page

No Data in Log

Problem: Pick Log table is empty or shows no records.

Solutions:

1. Check if any picking activities have occurred - log only shows completed picks
2. Clear all filters - you may have filters excluding all records
3. Check year filter - default shows “Last 3 months”, try selecting a different year
4. Verify orders have been picked using mobile app or picking system
5. Check if log data exists in database (contact administrator)

Filters Not Working

Problem: Column filters don’t show expected results.

Solutions:

1. Wait for filter delay (1 second) - filters apply automatically after typing stops
2. Verify filter values are correct (check spelling, format)
3. Clear all filters and reapply one at a time to identify the issue
4. Check if multiple filters are conflicting
5. Click Reset Filters button to clear all filters
6. Refresh the page and reapply filters

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. Reduce filters if query exceeds 1,000 record limit
5. Check browser popup blockers
6. Try exporting a smaller date range
7. Contact administrator if export feature is not available

Status Shows Incorrectly

Problem: Order status doesn’t match actual picking state.

Solutions:

1. Refresh the page - status updates may not be reflected yet
2. Check if order is currently being processed - status may be updating
3. Verify order has completed picking process
4. Review Processing_time field for actual status
5. Contact administrator if status consistently incorrect

Related Documentation

Next Steps:

• Picking Log - View consolidated picking log grouped by order
• Picking - Manage picking jobs and assignments
• Processing Orders - View orders being fulfilled

Related Features:

• Warehouse Bins - Manage bin locations
• Inventory Management - Warehouse inventory overview
• Reports - Warehouse reports and analytics