Shipped Orders Query
Prerequisites
- At least one outbound request has been submitted via 「Platform Orders」, 「Dropship Outbound Application」, 「Transfer Application」, or 「Scrap Application」, and the warehouse has completed the outbound operation.
- The outbound order status has changed to 「Shipped」, and the warehouse has completed the shipping process.
Operational Objectives
Centrally view all historical records of completed outbound shipments from the warehouse, covering three types: order outbound, transfer outbound, and scrap outbound. Unlike 「Outbound Overview」, 「Shipped Orders Query」 focuses on completed shipments, providing product-level cost breakdowns, suitable for:
- Financial Reconciliation: Filter by completion time, export shipping and handling fee details, and verify each item against warehouse bills
- Logistics Inquiry: Quickly locate packages and track logistics status based on tracking numbers or recipient information
- Cost Analysis: View the cost composition for each SKU, including packing handling fees and shipping fees, to analyze logistics costs
- Outbound Statistics: Understand outbound volume, primary shipping warehouses, and commonly used carriers over a period
Entry Point: Left Navigation → Outbound Management → Shipped Orders Query
Page Overview
After entering the 「Shipped Orders Query」 page, the system displays outbound records for the current month by default. The page is divided into four areas from top to bottom:
- Filter Area: Located at the top of the page, providing multi-dimensional filter conditions to quickly locate target outbound records
- List Area: Displays filtered outbound records, with each row corresponding to a product detail in an outbound order
- Total Area: Located at the bottom of the list, automatically summarizing the total shipping fees and various handling fees for all outbound records within the current filter range, eliminating the need for manual calculation
- Pagination Area: Located at the very bottom of the page, displaying the current page number and total record count, supporting switching the number of items per page (default 50) and page navigation
Common Business Scenarios
Scenario 1: Reconcile shipping fee bills with the warehouse at month-end
At the end of the month, you receive a shipping fee bill from the warehouse and need to verify each item for accuracy.
- In the 「Completion Time」 filter box, select the reconciliation month (e.g., last month).
- If you need to verify a specific warehouse, select the corresponding warehouse from the 「Warehouse」 dropdown.
- Check the 「Total」 row at the bottom of the list to confirm whether the total shipping fees and handling fees for each size match the bill.
- Click the 「Export」 button to export the details as an Excel file.
- In Excel, compare each row with the warehouse bill and mark any discrepancies.
Tip: The total row automatically calculates all fees within the filter range, including shipping fees, designated carrier fees, and packing handling fees for each size (100/120/140/160/180/200), making it convenient to quickly verify the total amount.
Scenario 2: Customer inquires about order logistics status
A customer reports not receiving the goods and needs to check the tracking number and carrier information.
- In the filter area, enter the 「Outbound Order Number」 or 「Order Number」 provided by the customer.
- Alternatively, filter by 「Contact Person」 or 「Contact Phone」 to locate the outbound record for that customer.
- Find the corresponding record in the list and check the following fields:
- Carrier: The logistics company (e.g., ヤマト運輸, 佐川急便)
- Tracking Number: The logistics tracking number, which can be used to track the shipment on the carrier's official website
- Shipping Address: The complete delivery address to confirm whether it matches the address provided by the customer
- Provide the tracking number to the customer, or check the delivery status on the carrier's official website yourself.
Tip: Fields such as outbound order number, SKU, SSKU, and tracking number in the list support one-click copy on mouse hover, making it convenient to quickly paste for inquiry.
Scenario 3: Analyze outbound history and logistics costs for a specific product
You want to understand the recent sales performance and logistics cost composition for a specific product.
- Enter the product code in the 「SKU」 or 「SSKU」 filter box.
- Set 「Completion Time」 to the analysis time range (e.g., last 30 days).
- The list will display all outbound records for that product, including:
- Quantity, shipping fee, and packing handling fee for each outbound
- Distribution of shipping addresses to understand the primary delivery regions
- Click 「Export」 to export the data and perform further analysis in Excel:
- Calculate total outbound volume and average shipping fee
- Analyze the proportion of packages of different sizes
- Calculate per-unit logistics cost
Scenario 4: Quickly统计 warehouse outbound volume
You need to understand the warehouse's outbound situation to evaluate warehouse usage efficiency.
- Clear the default filters (or keep the completion time).
- Select the warehouse from the 「Warehouse」 dropdown and observe the list data volume.
- Or click 「Export」 to export all data and perform statistics in Excel.
- Combined with the 「Outbound Type」 filter, you can further analyze the distribution of business types for the warehouse.
Filter Outbound Records
In the filter area, you can query by the following combined conditions:
| Filter Field | Type | Description | Applicable Scenario |
|---|---|---|---|
| Merchant | Multi-select dropdown | Select target merchants, supporting multiple selections simultaneously | Statistic outbound data by merchant dimension |
| Outbound Type | Single-select dropdown | Select outbound type: Order Outbound / Transfer Outbound / Scrap Outbound | Distinguish business types and analyze a specific type of outbound separately |
| Outbound Order Number | Multi-input | Enter outbound order numbers for query, supporting multiple inputs simultaneously | Precisely locate records based on outbound order numbers |
| Order Number | Multi-input | Enter order numbers for query, supporting multiple inputs simultaneously | Find corresponding outbound records based on platform order numbers |
| Completion Time | Date range | Select date range, supporting quick options (Today / Yesterday / Last 7 days / Last 30 days / This month / Last month) or precise calendar selection | Reconcile by time period, statistic monthly outbound volume |
| SKU | Multi-input | Enter product SKUs for query, supporting multiple inputs simultaneously | Query outbound history for a specific product |
| SSKU | Multi-input | Enter warehouse internal codes for query, supporting multiple inputs simultaneously | Query product outbound records by warehouse standard code |
| Warehouse | Multi-select dropdown | Select target warehouses, supporting multiple selections simultaneously | Verify outbound fees for specific warehouses |
| Transfer Type | Single-select dropdown | Select transfer type (only displayed for transfer outbound) | Distinguish different transfer methods |
| Tracking Number | Multi-input | Enter tracking numbers for query, supporting multiple inputs simultaneously | Reverse lookup orders based on logistics tracking numbers |
| Contact Person | Multi-input | Enter recipient contacts for query, supporting multiple inputs simultaneously | Find orders by recipient |
| Contact Phone | Multi-input | Enter contact phones for query, supporting multiple inputs simultaneously | Find orders by recipient phone number |
Tip: Fields marked as 「Multi-input」 support entering multiple keywords simultaneously, suitable for batch verification of multiple outbound records. For example, enter 10 order numbers in 「Outbound Order Number」 to quickly locate these records.
Quick Action Buttons
| Button | Description |
|---|---|
| Export | Export current filter results as an Excel file for offline reconciliation and archiving |
Tip: The filter area provides 「Reset」 and 「Refresh」 buttons on the right. Reset clears filter conditions (completion time defaults to keeping the current month), and refresh reloads the list data.
View Outbound Details
Each row in the list displays a single product detail in an outbound order. When an outbound order contains multiple product SKUs, it will be displayed as multiple rows, sharing the same outbound order number, outbound type, warehouse, completion time, and other information.
List Field Descriptions
| Field | Description | Focus During Reconciliation |
|---|---|---|
| Merchant | The merchant name to which the outbound record belongs | Distinguish data for different merchants |
| Outbound Order Number | The unique outbound order number generated by the system | Corresponds to warehouse bill number |
| Outbound Type | Order Outbound / Transfer Outbound / Scrap Outbound | Distinguish business types |
| Warehouse | The warehouse name that performed the outbound operation | Verify warehouse affiliation |
| Completion Time | The date when the outbound operation was completed, accurate to the day | Determine the month to which fees belong |
| Order Number | The associated order number; for transfer outbound and scrap outbound, the order number is the same as the outbound order number | Corresponds to platform orders |
| SKU | The product's inventory unit code | Verify products |
| SSKU | The warehouse's unique internal code, starting with OSL-. The warehouse uses SSKU as the absolute standard | The warehouse uses SSKU as the standard |
| Product Name | The complete product name | Assist in confirming products |
| Contact Person | The recipient's name | Confirm recipient |
| Contact Phone | The recipient's contact phone number | Contact recipient |
| Postal Code | The postal code of the shipping address | Confirm delivery region |
| Shipping Address | The detailed shipping address, automatically concatenated with prefecture, city, and detailed address | Confirm complete shipping address |
| Shipping Size | The shipping size specification of the package, such as 60-size, 100-size, 200-size, lightweight size, etc. | Verify shipping size classification |
| Carrier | The logistics company, such as ヤマト運輸, 佐川急便, エコ配 | Check logistics on the corresponding official website |
| Tracking Number | The logistics tracking number | Track package status |
| Shipping Fee (JPY) | The shipping fee for this outbound | Verify shipping fee amount |
| Designated Carrier Fee (JPY) | Additional fees incurred by the designated carrier | Verify additional fees |
| Packing Handling Fee | The packing handling fee for this size range (grouped by 100/120/140/160/180/200 size) | Verify handling fee |
| Packing Handling Fee Unit Price (JPY) | The unit price of the packing handling fee for this size range | Verify unit price standard |
| Packing Handling Fee Quantity | The number of packages in this size range | Verify package count |
Tip: Packing handling fees are divided into 6 groups by size (100/120/140/160/180/200), with each group containing three columns: fee, unit price, and quantity. The 「Total」 row at the bottom of the list summarizes the total fees for each column, making it convenient to quickly grasp the total fee expenditure within the filter range.
Outbound Type Descriptions
| Outbound Type | Description | Typical Scenario | Fee Characteristics |
|---|---|---|---|
| Order Outbound | Ship goods to end customers based on platform orders or dropship outbound applications | E-commerce platform order shipping, dropship outbound | Includes shipping fee + handling fee |
| Transfer Outbound | Transfer goods to other designated addresses based on transfer applications | Inter-warehouse transfers, forward to designated recipients | Includes shipping fee + handling fee |
| Scrap Outbound | Dispose of goods in the warehouse based on scrap applications | Disposal of slow-moving products, handling of non-conforming products | Only handling fee, no shipping fee |
Export Outbound Data
- Set filter conditions in the filter area to narrow the export scope (e.g., specify completion time range, outbound type, etc.).
- Click the 「Export」 button above the list.
- The system exports all outbound records within the current filter range as an Excel file.
- After downloading the file, you can open it locally for viewing, used for reconciliation, verification, or archiving.
Tip:
- It is recommended to narrow the data range through filter conditions before exporting to avoid exporting too much data and affecting processing efficiency.
- The exported file can be directly used for item-by-item verification against warehouse bills. It is recommended to use pivot tables in Excel to summarize and analyze by warehouse, outbound type, and month.