Skip to main content

Analyze Orders by Product (Analytics Feature)

Overview​

The Orders By Product page is one of the analytics features in the Merchant App. It lets you review aggregated order data for each product.

In addition to product-level aggregation results, you can also view a detailed breakdown for each product.

Purpose​

Use this page to understand trends in order quantities and amounts by product. This information can support demand forecasting, sales analysis, and decisions about sales policies.

You can also drill down to quantities by Buyer and SKU to review order breakdowns in more detail.

Feature Description​

Screen Configuration (Summary Page and Details Page)​

This feature consists of the following two screens.

  • Orders By Product page: Review aggregated and analyzed order data for each product.
  • Orders By Product Details page: For a selected product, review order quantities for each combination of Buyer and SKU.

Data Refresh Timing​

The displayed aggregation data is not automatically refreshed every time you open the page.

The time when the aggregation data was last retrieved is shown as Last Updated At, and you can refresh the data whenever needed.

Order Data Source on the Details Page​

On the Orders By Product Details page, you can choose the order data source used for quantity calculations: Confirmed Order or Original Order.

Filter Conditions and Available Aggregation Items​

In addition to the order date range, Currency, and Transaction Term, you can narrow down the aggregation target using a specific catalog and various Buyer and Product attributes.

If Currency is set to All, Transaction Term is automatically set to All as well.

If you specify conditions that determine the price, you can review various Estimated Amount values as well as the Original Price, which is the base unit price before trade-term-specific discount rates or wholesale rates are applied.

If you do not specify price-related conditions such as Currency or Transaction Term, only the total quantity across all currencies is calculated and displayed.

Handling of Products Without Order Results​

On the Orders By Product page, you can choose whether to include products without order results in the aggregation target.

Instructions​

You can review product-level aggregation results in either of the following ways.

  1. Specify conditions and review results on the Orders By Product page
  2. Check quantities for each Buyer and SKU combination on the Orders By Product Details page

1. Specify conditions and review results on the Orders By Product page​

Go to the Orders By Product page​

  1. Click the Analytics menu.
  2. Click Orders By Product.
    The Orders By Product page opens.

Refresh Aggregation Data​

  1. Check Last Updated At.
    If needed, click Refresh to retrieve the latest aggregation data.

Filter Aggregation Targets by Basic Conditions and Attributes​

You can narrow down the aggregation target as needed.

Some amount-related aggregation items require conditions that determine the price, such as Currency and Transaction Term.

  1. Order Date Period
    Use the radio buttons to specify the order date range for aggregation.

    If you select Custom, you can choose the start and end dates from the calendar.

  2. Currency
    Use the radio buttons to specify the currency for aggregation.

  3. Transaction Term
    Use the radio buttons to specify the transaction term for aggregation.

    *If you narrow down Currency, you can select a Transaction Term other than All.

  4. Search
    Enter conditions in the Buyer or Product fields to narrow down the aggregation target.

    tip

    To control whether products with no order results are included, use Product Display Conditions by Order Quantity in the Product search conditions. The options are as follows.

    • All: Displays all products, regardless of whether they have order results.
    • Show only ordered products: Includes only products with order results in the aggregation target.
    • Show only products not ordered: Includes only products without order results in the aggregation target.

Review Aggregation Results for Each Product​

  1. Review the aggregation results for each product. You can also do the following as needed.
  • Click a column header to sort the list in ascending or descending order by that item.
  • Click a numeric aggregation result to open the Order Analytics Details modal and review the details.

2. Check quantities for each Buyer and SKU combination on the Orders By Product Details page​

Go to the Orders By Product Details page​

  1. Click the Analytics menu.
  2. Click Orders By Product.
    The Orders By Product page opens.
  3. In the list of aggregation results, click the target product or Details.
    The Orders By Product Details page opens.

Refresh Aggregation Data​

  1. Check Last Updated At.
    If needed, click Refresh to retrieve the latest aggregation data.

Filter Aggregation Targets by Period and Catalog​

  1. Order Date Period
    Specify the order date range for aggregation.

    You can select the start and end dates from the calendar.

  2. Catalog
    Select the catalog to aggregate from the drop-down list.

Review Quantities for Each Buyer and SKU Combination​

  1. In the Order Summary section, choose one of the following as the basis for quantity aggregation, as needed.

    • Quantity (Confirmed Order)
    • Quantity (Original Order)

  2. You can review the order quantities in the order allocation table for each combination of Buyer and SKU.

Important Notes​

Freshness of Aggregation Results​

The display is not updated in real time.

Check Last Updated At, and click Refresh when you need to retrieve the latest data.

Prerequisites for Viewing Amounts​

For some amount-based aggregation items, if conditions needed to uniquely determine the price, such as Currency and Transaction Term, are not set consistently, only total quantity is calculated and displayed.

Before comparing or totaling amounts, make sure the required conditions are specified.

Orders Not Included in Aggregation​

Invalid orders, such as orders that have already been Rejected (Cancelled) or Returned, are excluded from aggregation.

If the order counts or quantities differ from what you expected, also check the status of the relevant orders.