ETA Management

What is ETA Management?

ETA Management is a specialized view that shows all orders in backorder status along with expected arrival dates (ETA - Expected Time of Arrival) of replenishments associated with these orders. This tool allows you to track when inventory needed to complete pending orders will arrive and communicate accurate delivery times to your customers.

When an order has out-of-stock products, the system marks it as backorder and searches for related replenishments that can satisfy those products. ETA Management displays this information in an organized way, allowing you to see which orders are waiting for inventory and when it’s expected to arrive.

Admin View

This view is only available for users with administrator level (UserLevel = 1). If you cannot access it, contact your system administrator.

Key Benefits

Backorder Visibility

See all your backorder orders in one place with their expected inventory arrival dates.

Replenishment Tracking

Identify which replenishments are associated with each order and their current status (IN-TRANSIT, PROCESSING, ARRIVED).

Customer Communication

Use ETA dates to inform your customers when they can expect to receive their orders.

Orders Without ETA Filter

Quickly identify orders that don’t yet have an assigned replenishment or ETA date.

SKU Details

Expand each order to see individual ETA for each SKU and its associated replenishment.

Backorders Export

Download the complete list of backorders for external analysis or reports.

How ETA Management Works

ETA Management uses a database view called eta that combines:

• Backorder Orders: All orders with OrderStatus = 7 (BACKORDER)
• Associated Replenishments: Replenishments linked to these orders through the crossdock table
• Expected Dates: The date_expected_arrival date from replenishment, or DateStatus if there’s no expected date

The system shows the most recent ETA date from all replenishments associated with each order, allowing you to know when necessary inventory will arrive.

Access ETA Management

1. Verify Your Permissions

   Only users with administrator level can access this view. If you don’t have access, contact your administrator.

2. Navigate to the View

   From the main menu, search for “X-Dock ETA” or navigate directly to /etalist.php.

3. You’ll See the ETA Table

   The system displays a table with all backorder orders that have associated replenishments, including:

   • Shipping# (OrderID)
   • OrderStatus (backorder icon)
   • Order# (orderNum)
   • Reference# (orderRef)
   • OrderDate
   • ShipMethod
   • Items (quantity of items)
   • Name (customer)
   • ETA (expected arrival date)
   • RepleID (associated replenishment ID)
   • Supplier (replenishment supplier)
   • RepleStatus (replenishment status)

Understanding the ETA Management Table

Shipping# (OrderID)

The unique ID of the order. Click it to open the complete order view in a new tab.

Example: 12345, 67890

---

OrderStatus

Shows the order status. In ETA Management, all orders have OrderStatus = 7 (BACKORDER), represented by the backorder icon.

Icon: backorder.png

---

Order# (orderNum)

The order number from the sales channel (Amazon, Shopify, etc.).

Example: 123-4567890-1234567 (Amazon), #1234 (Shopify)

---

Reference# (orderRef)

The order reference provided by the customer or channel.

Example: CUST-REF-001, WEB-2024-001

---

OrderDate

The date and time when the order was created.

Format: YYYY-MMM-DD HH:MM AM/PM

Example: 2024-Mar-15 10:30 AM

---

ShipMethod

The shipping method selected for the order.

Example: Standard Shipping, Express, Priority Mail

---

Items

The total quantity of items (SKUs) in the order.

Example: 3, 15

---

Name

Customer information, displayed in format:

• Full name (in bold)
• Country
• State, Postal Code

Example:

John Smith
United States
CA, 90210

---

ETA (Expected Time of Arrival)

The expected arrival date of the associated replenishment. This is the most recent date from all replenishments linked to the order.

Format: YYYY-MMM-DD

Example: 2024-Mar-22

Note: If there’s no date_expected_arrival in the replenishment, DateStatus (replenishment creation date) is used.

---

RepleID

The ID of the replenishment associated with this order. Click it to see complete replenishment details.

Example: 12345, 67890

Note: Only appears if there’s an associated replenishment with matching ETA.

---

Supplier

The name of the supplier of the associated replenishment.

Example: Acme Wholesale, Global Distributors

Note: Only appears if there’s an associated replenishment.

---

RepleStatus

The current status of the replenishment, shown with icons:

🚚 IN-TRANSIT

• Icon: reple_intransit.png
• Meaning: Replenishment is in transit to warehouse
• StatusRqt: 4, FlatID: 0

📦 PROCESSING

• Icon: reple_processing.png
• Meaning: Replenishment is being processed in warehouse
• StatusRqt: 4, FlatID: 1

✅ ARRIVED

• Icon: arrived.png
• Meaning: Replenishment has arrived at warehouse
• StatusRqt: 79

---

Reple

Internal field indicating if the order has an associated replenishment:

• Y: Yes, has replenishment
• N: No, doesn’t have replenishment

This field is hidden in the view but used for internal filters.

---

View SKU Details by Order

Each order can be expanded to see detailed information for each SKU:

1. Click the Expand Icon

   In the first column of each row, you’ll see an expand/collapse icon (details-control). Click it.

2. Details Table Is Displayed

   An expanded table appears showing:

   • Sku: Product SKU (click to see history)
   • Qty: Ordered quantity
   • ETA: Expected arrival date for that specific SKU
   • RepleID: ID of replenishment containing that SKU

3. SKU ETA Information

   For each SKU, the system shows:

   • ASSIGNED: If SKU is already in stock (Instock = ‘Y’)
   • NOT ASSIGNED: If there’s no associated replenishment for that SKU
   • ETA Date: If there’s a replenishment, shows expected date

4. Access Details

   • Click Sku to see complete product history
   • Click RepleID to see replenishment details

Expanded table example:

Sku          | Qty | ETA          | RepleID
-------------|-----|--------------|--------
WIDGET-001   | 5   | 2024-Mar-22  | 12345
GADGET-002   | 3   | ASSIGNED     |
TOOL-003     | 2   | NOT ASSIGNED |

---

Filter Orders Without ETA

The view includes a special filter to identify orders that don’t have an assigned replenishment or ETA date:

1. Locate the Without ETA Filter

   At the top of the table, you’ll see an icon with text “Sin ETA” followed by a number in parentheses. This number indicates how many orders don’t have assigned ETA.

2. Click the Icon

   Click the icon to filter and show only orders without ETA.

3. Filter Activates

   Icon changes from SinETA1.png to SinETA2.png, and a “Reset” button appears.

4. View Only Orders Without ETA

   Table now shows only orders where Reple = 'N' (don’t have associated replenishment).

5. Reset Filter

   Click “Reset” to show all orders again.

Orders Without ETA

Orders without ETA are those that:

• Are in backorder but don’t have an associated replenishment
• Have replenishments but don’t have date_expected_arrival assigned
• Need attention to create a replenishment or update ETA dates

---

Download Backorders

You can export the complete list of backorders for external analysis:

1. Locate Download Link

   At the top of the page, you’ll see a link that says “Download backorders”.

2. Click the Link

   This takes you to ShippedSellerlist.php?exportb=ok which generates an export file.

3. File Downloads

   System generates a file with all backorders and their associated ETAs.

Export Format

The exact format of the export file depends on ShippedSellerlist.php configuration. Generally includes order information, customers, SKUs, and ETA dates.

---

Available Actions in the View

Expand/Collapse All Orders

In the DataTables toolbar, you’ll find buttons:

• Show all: Expands all rows to show details of all SKUs
• Hide all: Collapses all rows to hide details

Use: Useful when you need to review multiple orders quickly.

---

Search and Filters

The table includes complete DataTables functionality:

• General search: Search field at top to search across all columns
• Sorting: Click any column header to sort
• Pagination: Navigate between result pages

Default order: Table is sorted by ETA column in descending order (most recent dates first).

---

Common Use Cases

Case 1: Verify When Inventory Will Arrive for a Specific Order

Scenario: A customer asks when their order will arrive. The order is in backorder.

1. Go to ETA Management (/etalist.php)
2. Use search field to search by Order# or Shipping#
3. Locate order in table
4. Review ETA column to see expected date
5. (Optional) Expand row to see individual ETAs by SKU
6. Review RepleStatus to see replenishment status (IN-TRANSIT, PROCESSING, ARRIVED)
7. Communicate ETA date to customer

Result: Accurate information about when inventory will arrive to communicate to customer.

---

Case 2: Identify Orders That Need Replenishments

Scenario: Need to know which backorder orders don’t yet have an assigned replenishment.

1. Go to ETA Management
2. Click “Sin ETA” filter (icon with number)
3. Review list of orders without ETA
4. For each order:
   • Expand row to see which SKUs are missing
   • Review if there are SKUs with “NOT ASSIGNED”
   • Create replenishments for missing SKUs
5. After creating replenishments, reset filter to verify they appear with ETA

Result: List of orders requiring action to create replenishments.

---

Case 3: Monitor Status of Replenishments in Transit

Scenario: Want to see all orders waiting for replenishments that are in transit.

1. Go to ETA Management
2. Sort by RepleStatus column (if available) or visually review icons
3. Look for orders with IN-TRANSIT icon (🚚)
4. Review ETA dates to see when they’re expected to arrive
5. Expand orders to see SKU details
6. Monitor regularly to see when they change to ARRIVED (✅)

Result: Complete visibility of in-transit replenishment status and their associated orders.

---

Case 4: Delivery Time Analysis

Scenario: Need to analyze how long backorder orders are waiting.

1. Go to ETA Management
2. Export backorders using “Download backorders”
3. Open file in Excel or analysis tool
4. Compare OrderDate with ETA to calculate wait days
5. Identify orders with excessive wait times
6. Review if there are opportunities to improve replenishment times

Result: Data for performance analysis and delivery time improvement.

---

💡 Best Practices

Review ETA Management Daily

Regularly monitor backorder orders and their ETAs to keep customers informed and identify problems early.

Update ETA Dates in Replenishments

When creating replenishments or receiving supplier updates, update date_expected_arrival dates so ETA Management shows accurate information.

Use Without ETA Filter Regularly

Frequently review orders without ETA to identify opportunities to create replenishments or update missing information.

Communicate ETAs to Customers

Use displayed ETA dates to proactively inform customers about expected delivery times, improving customer satisfaction.

Monitor Status Changes

Regularly review RepleStatus changes (IN-TRANSIT → PROCESSING → ARRIVED) to maintain updated information.

Export for Analysis

Download backorders periodically for trend analysis, wait times, and supplier performance.

Troubleshooting

I Don’t See ETA Management View

Problem: Cannot access /etalist.php or it doesn’t appear in menu.

Possible Causes:

1. Don’t have administrator permissions: Only users with UserLevel = 1 can access
2. No backorder orders: View only shows orders with OrderStatus = 7
3. No associated replenishments: View requires replenishments linked through crossdock

Solutions:

1. Verify permissions: Contact administrator to confirm your user level
2. Verify backorder orders: Review orders view to confirm there are orders with status 7
3. Verify replenishments: Make sure replenishments are correctly associated with orders

---

ETA Dates Don’t Appear

Problem: See orders in table but ETA column is empty.

Common Causes:

1. No date_expected_arrival date: Replenishment doesn’t have expected date assigned
2. No associated replenishment: Order doesn’t have a replenishment linked in crossdock
3. Replenishment doesn’t meet criteria: Replenishment doesn’t have Reple = 'Y' in eta view

Solutions:

1. Update dates in replenishments: Go to replenishments view and update date_expected_arrival field
2. Verify associations: Review crossdock table to confirm orders have associated repleid
3. Create replenishments: If replenishments are missing, create them and associate them with orders

---

Without ETA Filter Doesn’t Work

Problem: Click filter but view doesn’t change.

Causes:

1. JavaScript disabled: Filter requires active JavaScript
2. DataTables error: May be a problem with table initialization

Solutions:

1. Enable JavaScript: Make sure JavaScript is enabled in your browser
2. Reload page: Press F5 or Ctrl+R to reload
3. Clear browser cache: If it persists, clear cache and try again
4. Contact support: If problem continues, report error to support team

---

SKU Details Don’t Expand

Problem: Click expand icon but details don’t show.

Causes:

1. JavaScript disabled: Expand functionality requires JavaScript
2. Data loading error: May be a problem getting SKU information

Solutions:

1. Verify JavaScript: Make sure JavaScript is enabled
2. Review browser console: Open developer tools (F12) and check for errors
3. Reload page: Try reloading the page
4. Contact support: If it persists, report problem with console error details

---

Differences Between ETA Management and Other Views

Aspect	ETA Management	Orders View	Replenishments View
Focus	Backorder orders with ETAs	All orders	All replenishments
Order Status	Only BACKORDER (7)	All statuses	N/A
Information Shown	ETA + Associated replenishment	Order details	Replenishment details
Without ETA Filter	Available	Not available	Not available
SKU View	Expandable by order	In details view	In details view
Permissions	Admin only (UserLevel = 1)	According to user permissions	According to user permissions

---

Technical Reference Fields

For API integrations or development, these are the main fields in the eta view:

Field	Type	Description
OrderID	INT	Unique order ID
AcountID	INT	Account/customer ID
OrderStatus	INT	Order status (7 = BACKORDER)
orderNum	VARCHAR	Channel order number
orderRef	VARCHAR	Order reference
OrderDate	DATETIME	Order creation date
orderShipMethod	VARCHAR	Shipping method
items	INT	Quantity of items in order
Name	VARCHAR	Customer full name
custCountry	VARCHAR	Customer country
custState	VARCHAR	Customer state
custZip	VARCHAR	Customer postal code
ETA	DATE	Expected arrival date (date_expected_arrival or DateStatus)
Reple	CHAR(1)	‘Y’ if has replenishment, ‘N’ if not
repleid	VARCHAR	Associated replenishment IDs (comma-separated)

---

Related Pages

See Also:

• Replenishment Overview - Understand complete replenishment flow
• Creating Replenishment Requests - How to create new replenishments
• Archived Replenishments - History of completed replenishments
• Orders Overview - General order management
• Backorders - Information about backorder orders

Related Flow:

1. Order created → Some products out of stock
2. Order goes to BACKORDER → Status 7
3. Replenishment created → For missing products
4. ETA assigned → date_expected_arrival in replenishment
5. Appears in ETA Management ← You are here
6. Replenishment arrives → Status changes to ARRIVED
7. Order processed → Inventory available, order goes to PENDING/PROCESSING

---

Summary

ETA Management is your visibility and tracking tool for backorder orders and their expected inventory arrival dates. Use this view to:

✅ Track when inventory needed to complete pending orders will arrive
✅ Communicate accurate delivery dates to your customers
✅ Identify orders that need replenishments or attention
✅ Monitor status of replenishments in transit and processing
✅ Analyze wait times and supplier performance
✅ Export data for reports and external analysis

This view provides complete transparency about your backorders status and helps you keep customers informed while they wait for necessary inventory to arrive.