Skip to main content

Analyze Orders by SKU (Analytics Feature)

Overview​

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

In addition to SKU-level aggregation, you can specify SKU properties such as color and size to review ordered quantities for each attribute.

Purpose​

Use this page to understand ordered quantities and amounts by SKU or attribute. This information can help you assess inventory levels and sales trends.

You can also narrow down the aggregation target by order date range, transaction term, buyer, and product information so you can focus on the range you want to analyze.

Feature Description​

Aggregation by SKU and SKU Properties​

You can aggregate and review order data for each SKU.

You can also specify a Target SKU Property, such as color or size, to aggregate and display ordered quantities for each attribute in a list.

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 recorded, and you can refresh the latest aggregation data whenever needed.

Handling of Products Without Order Results​

You can choose whether to include products without order results in the aggregation target.

Instructions​

Go to the Orders By SKU Page​

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

Review Orders By SKU​

Refresh Aggregation Data​

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

Specify Aggregation Conditions​

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.

Choose the Aggregation Axis and Review Results​

Click one of the following aggregation tabs to switch the display based on what you want to review.

*By default, the By SKU tab is displayed.

  • By SKU
    You can review the ordered quantity for each SKU.
    To view amounts, specify price-related conditions such as currency and transaction term in advance.

    As needed, click a column header to sort the list in ascending or descending order by that item.

  • Summary By SKU Property
    In the Target SKU Property drop-down list, select the SKU property you want to display, such as color or size.
    The ordered quantity for each value of the selected SKU property is displayed.

    As needed, click a column header to sort the list in ascending or descending order by that item.

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 quantities such as ordered quantity and order count are calculated and displayed.

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

Content of "Original Price"​

The Original Price displayed when price-related conditions are specified is the base unit price before discount rates or wholesale rates based on the transaction term are applied.

This is different from the wholesale price.

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 count or quantity differs from what you expected, also check the status of the relevant orders.