All Orders

All Orders shows all orders in the system across all statuses (except cancelled, deleted, and transfer orders). View orders from Pending to Shipped, filter by multiple criteria, export order data, and track order activity. This page provides a comprehensive view of all order activity in your warehouse.

Quick Access

Navigate to All Orders from the warehouse menu (accessible via all_orders.php) to view all orders across all statuses.

Why Use All Orders?

Complete Order View

See all orders in one place regardless of status. View orders from Pending, Processing, Shipped, Backorder, Hold, and other statuses together.

Advanced Filtering

Filter orders by status, date range, account, order type, shipping method, carrier, channel, and more. Find specific orders quickly.

Export Order Data

Export orders to CSV or Excel for reporting and analysis. Export up to 5,000 records per export with all order details.

Track Order Activity

View order activity logs and track order changes. See order history and status changes in one place.

Accessing All Orders

1. Navigate to All Orders

   Click All Orders in the warehouse navigation menu. The page loads showing all orders in a table.

2. View Order Table

   Browse orders showing Items, Ship#, Company Name, Order#, Reference#, Order Type, Shipping Method, Status, Ship to, Tracking#, Order Date, Channel, Shipping Carrier, and Sub Status.

3. Filter Orders

   Use column filters or date range filters to find specific orders.

4. View Order Details

   Click on Ship# to view order details in a new window.

Key Features

Table Columns

The all orders table displays:

• Items - Number of items in the order (click to expand and view SKUs)
  • Actions menu (⋮) - Access order actions
  • View - Open order details
  • Activity log - View order activity history
• Ship# - Internal system order ID (clickable link to order view)
  • Copy button to copy Ship# to clipboard
  • Links to appropriate order view based on status (Pending, Processing, Shipped, or All Orders)
• Company Name - Customer/account name
• Order# - Customer-facing order number
• Reference# - Order reference number
• Order Type - Type of order (e.g., Standard, FBA, etc.)
• Shipping Method - Shipping method used or requested
• Status - Current order status with status badge:
  • Shows status name and link
  • For shipped orders (Status 9), shows sub-status badge:
    • Ready to Process (sky blue badge)
    • On Delivery (yellow badge)
    • Delivered (green badge)
    • Failed Delivery (red badge)
  • Shows “Multibox” button if order is divided
  • Shows release date for orders on hold with release date
• Ship to - Shipping address details:
  • Customer name
  • Address lines
  • City, State, ZIP, Country
  • Email (clickable mailto link)
  • Phone number
• Tracking# - Carrier tracking number (clickable link to carrier tracking page)
  • Copy button to copy tracking number to clipboard
  • Shows “Work Order” link for manufactured orders
• Order Date - Date and time when order was created
• Channel - Sales channel/enterprise name (with logo if available)
• Shipping Carrier - Shipping carrier name (with tooltip showing description)
• Sub Status - Delivery sub-status (hidden column, used for filtering)

Individual Order Actions

Click the actions menu (⋮) on any order row to access:

View:

• Open order details in a new window
• Shows complete order information
• Links to appropriate view based on order status

Activity log:

• View complete activity history for the order
• Shows all changes and actions performed on the order
• Useful for tracking order modifications

Display SKUs:

• Click the items count button (+) to expand and view all SKUs in the order
• Shows product details, quantities, prices, and stock status
• Collapsible row expansion

Filtering Options

Column Filters: Use filters below column headers:

• Items - Range filter (min-max items)
• Ship# - Text filter (comma-separated: ship#,ship#,ship#,…)
• Company Name - Multi-select filter by account
• Order# - Text filter (comma-separated: ord#,ord#,ord#,…)
• Reference# - Text filter (search)
• Order Type - Multi-select filter by order type
• Shipping Method - Multi-select filter by shipping method
• Status - Multi-select filter by order status
• Ship to - Text filter (searches customer name, address, email, etc.)
• Tracking# - Text filter (search)
• Order Date - Date range filter
• Channel - Multi-select filter by sales channel
• Shipping Carrier - Multi-select filter by carrier

Date Range Filters:

• Last 2 months (default) - Shows orders from last 2 months
• Last month - Shows orders from last month
• Last 10 days - Shows orders from last 10 days
• Specific Year - Filter by specific year (e.g., 2023, 2024)
• Today - Quick filter button to show orders created today

Global Search:

• Use the search box above the table to search across multiple columns
• Searches Ship#, Order#, Reference#, Tracking#, and customer information
• 2-second delay before searching (debounced)

Reset Filters:

• Click Reset Filters button to clear all filters
• Resets table to default view (Last 2 months)

Export Options

Download order data for external analysis or reporting:

CSV Export:

• Click the CSV button above the order table
• Downloads all visible columns for filtered orders
• Maximum 5,000 records per export
• Filename format: all_orders_YYYY_MM_D__HH_mm_ss.csv
• Exports status as text (not HTML)

Excel Export:

• Click the EXCEL button above the order table
• Downloads formatted Excel spreadsheet with all data
• Maximum 5,000 records per export
• Filename format: all_orders_YYYY_MM_D__HH_mm_ss.xlsx
• Preserves long tracking numbers as text (prevents Excel from converting to scientific notation)
• Exports status as text (not HTML)

Export Limits

If your query returns more than 5,000 records, you’ll see an alert asking you to refine your filters before exporting. Apply date range or other filters to reduce the result set.

Viewing Order Details

Orders link to different views based on their status:

• Pending orders (Status 3) - Links to Pending Orders view
• Processing orders (Status 4) - Links to Processing Orders view
• Shipped orders (Status 9) - Links to Shipped Orders view
• Other statuses - Links to All Orders view

Multibox Orders

Orders that have been divided show a “Multibox” button:

• Click Multibox button to filter and show all related divided orders
• Shows all orders with the same OrderID_DIV
• Useful for tracking orders split into multiple shipments

API Errors Alert

If there are API errors in the system, an alert appears showing:

• API Errors badge with error count
• Click to view error list
• Refresh button to update error count

Working with All Orders

Viewing Order Details

1. Find Order

   Use filters or browse the table to find the order you want to view.

2. Click Ship# Link

   Click on the Ship# (order ID) in the table.

3. View Order

   Order details open in a new window showing complete order information based on order status.

Filtering Orders by Status

1. Open Status Filter

   Click the Status filter dropdown below the Status column header.

2. Select Statuses

   Check boxes next to statuses you want to view (e.g., Pending, Processing, Shipped).

3. Apply Filter

   Table updates showing only orders with selected statuses.

Filtering by Date Range

1. Open Date Filter

   Click the date filter dropdown button (shows current filter: “Last 2 months”, “Last month”, etc.).

2. Select Date Range

   Choose from options:

   • Last 2 months (default)
   • Last month
   • Last 10 days
   • Specific year (if available)

3. Apply Filter

   Table updates showing orders within selected date range.

Filtering Orders Created Today

1. Click Today Button

   Click the Today button next to the date filter dropdown.

2. View Today’s Orders

   Table filters to show only orders created today.

Viewing Order SKUs

1. Find Order

   Locate the order in the table.

2. Click Items Button

   Click the items count button (+) next to the actions menu.

3. View SKUs

   Row expands showing all SKUs in the order with details:

   • SKU code
   • Product description
   • Quantity
   • Sold price
   • Stock status
   • Product images (if available)

4. Collapse Row

   Click the items button again to collapse the row.

Viewing Order Activity Log

1. Find Order

   Locate the order in the table.

2. Open Actions Menu

   Click the actions menu (⋮) on the order row.

3. Select Activity log

   Click Activity log from the menu.

4. Review Activity

   Activity log modal opens showing all changes and actions performed on the order.

Copying Ship# or Tracking#

1. Find Order

   Locate the order in the table.

2. Click Copy Button

   Click the clipboard icon (📋) next to Ship# or Tracking#.

3. Paste

   Value is copied to clipboard. Paste where needed.

Viewing Multibox Orders

1. Find Divided Order

   Locate an order that shows “Multibox” button in Status column.

2. Click Multibox Button

   Click the Multibox button.

3. View Related Orders

   Table filters to show all orders with the same OrderID_DIV (related divided orders).

Exporting Order Data

1. Apply Filters (optional)

   Filter orders to export only the data you need.

2. Check Record Count

   Ensure filtered results are 5,000 or fewer (check table info).

3. Click Export Button

   Click CSV or EXCEL button above the table.

4. Download File

   File downloads with timestamped filename. Open in spreadsheet application.

💡 Best Practices

Use Date Filters

Use date range filters to focus on recent orders. Default “Last 2 months” view helps manage current orders efficiently.

Filter by Status

Filter by status to focus on specific order types. Combine status filters with date filters for targeted views.

Export Regularly

Export order data regularly for reporting and analysis. Use CSV or Excel export to track order metrics over time.

Use Activity Logs

Check activity logs when investigating order issues. Activity logs show all changes and help track order history.

Track Multibox Orders

Use Multibox button to track divided orders. This helps ensure all parts of a divided order are processed correctly.

Monitor API Errors

Check API Errors alert regularly. Address errors promptly to prevent order processing issues.

Troubleshooting

Can’t See Orders

Problem: Order table is empty or shows no orders.

Solutions:

1. Check date range filter - default is “Last 2 months”, try expanding to specific year
2. Clear all filters - click Reset Filters button
3. Verify orders exist - check if orders are in valid statuses (not cancelled, deleted, or transfer)
4. Check user permissions - ensure you have access to view all orders
5. Refresh the table - click Refresh button
6. Try different date range - select “Last month” or specific year

Can’t Filter Orders

Problem: Filters don’t work or don’t apply correctly.

Solutions:

1. Clear filters and reapply - click Reset Filters, then set filters again
2. Check filter syntax - use comma-separated values for Ship#, Order#, etc.
3. Verify date ranges - ensure date ranges are valid
4. Check multi-select filters - ensure options are selected correctly
5. Refresh the table after applying filters
6. Try global search instead - use search box above table

Export Fails or Shows Error

Problem: CSV or Excel export doesn’t work or shows error message.

Solutions:

1. Check record count - if more than 5,000 records, refine filters first
2. Verify filters are applied - export includes only filtered results
3. Try smaller date range - reduce to last month or specific week
4. Check browser download settings - ensure downloads are allowed
5. Try different browser
6. Check available disk space

Order Details Don’t Open

Problem: Clicking Ship# doesn’t open order details.

Solutions:

1. Check browser popup blocker - ensure popups are allowed
2. Verify order status - order must be in valid status
3. Try right-click and “Open in new tab”
4. Check browser console for errors
5. Try different browser
6. Refresh the page and try again

Activity Log Doesn’t Open

Problem: Activity log option doesn’t work or modal doesn’t open.

Solutions:

1. Check browser JavaScript - ensure JavaScript is enabled
2. Try refreshing the page
3. Check browser console for errors
4. Verify order has activity - new orders may not have activity log entries
5. Try different browser

SKUs Don’t Expand

Problem: Clicking items button doesn’t show SKUs.

Solutions:

1. Wait a moment - SKUs load via AJAX and may take a few seconds
2. Check browser JavaScript - ensure JavaScript is enabled
3. Try clicking button again
4. Check browser console for errors
5. Refresh the page and try again
6. Verify order has items - empty orders won’t show SKUs

Copy Button Doesn’t Work

Problem: Copy buttons don’t copy Ship# or Tracking# to clipboard.

Solutions:

1. Check browser permissions - ensure clipboard access is allowed
2. Try clicking button again
3. Check browser console for errors
4. Try different browser
5. Manually copy - select text and use Ctrl+C (Cmd+C on Mac)

Multibox Button Doesn’t Work

Problem: Multibox button doesn’t filter orders.

Solutions:

1. Verify order is divided - check if OrderID_DIV is not 0
2. Check browser JavaScript - ensure JavaScript is enabled
3. Try refreshing the page
4. Check browser console for errors
5. Try clicking button again

Date Filter Not Working

Problem: Date filter doesn’t update table or shows wrong results.

Solutions:

1. Clear filters and reapply - click Reset Filters, then set date range again
2. Check date format - ensure dates are valid
3. Try different date range - select “Last month” or specific year
4. Refresh the table - click Refresh button
5. Check browser console for errors
6. Verify date picker is working - try clicking date fields

API Errors Alert Missing

Problem: API Errors alert doesn’t appear when there are errors.

Solutions:

1. Check if errors exist - visit error list page directly
2. Refresh the page - alert loads on page load
3. Check browser JavaScript - ensure JavaScript is enabled
4. Check browser console for errors
5. Verify user permissions - ensure you have access to view errors

Related Documentation

Next Steps:

• Pending Orders - View pending orders
• Processing Orders - View orders being fulfilled
• Shipped Orders - View shipped orders

Related Features:

• Order Management - Complete order management guide
• Order Statuses - Understanding order statuses
• Activity Logs - Tracking order activity