Skip to main content

Analyze Orders by Catalog (Analytics Feature)

Overview​

Orders By Catalog summary is a feature within the Analytics of the Merchant App that allows you to summarize and check order data for each catalog.

You can access it from the list of all catalogs, select a catalog, and drill down into detailed perspectives.

Purpose​

The purpose is to organize order trends by catalog to support information use and analysis, providing a basis for sales strategy decisions.

It can be used to understand ordered quantity and amounts for each sales channel or lineup, compare different conditions, and check breakdowns by combining various axes.

Feature Description​

Order Data Subject to Summarization​

Summarization does not include orders in an invalid state, such as Canceled Orders.

Screen Composition (Summary and Details)​

This feature consists of the following two stages of screens:

  • Summary: Check the summarization results for all catalogs in a list.
  • Details: Select a specific catalog to check summarization from more detailed perspectives.

Timing of Summarized Data Updates and Display​

Summarized data is not always switched to the latest version at the moment of access.

The date and time when the summarization information was retrieved is recorded, and you can re-acquire the latest summarization information as needed.

Summarization Axes on the Detail Screen​

In addition to basic conditions such as Order Date Period, Currency, and Transaction Term, you can flexibly narrow down the summarization targets using various Attribute data of buyers and products.

Starting from the summary by catalog, you can check details by axes such as Product, SKU, SKU Property, Buyer, and Custom Attribute.

Handling of Products Without Order Results​

For specific summarization axes, you can toggle whether to include products without order results in the summarization.

Instructions​

You can check the Summary or Details of summarization results by catalog using the following methods.

  1. Checking the Overall Status on the Summary Screen of Orders By Catalog
  2. Checking Conditions and Summarization on the Details Screen of Orders By Catalog

1. Checking the Overall Status on the Summary Screen of Orders By Catalog​

  1. Click the Analytics menu.

  2. Click Orders By Catalog.
    Transitions to the "Orders By Catalog" page.

  3. You can check the summarization results for all catalogs in a list.

    You can also do the following as needed:

    • You can narrow down buyers by entering conditions in each item of Search Buyers.
    • By clicking the column labels of each item, you can sort the list in Ascending or Descending order of the values corresponding to the items.
    • You can select the currency to display in the Display Price type dropdown.

2. Checking Conditions and Summarization on the Details Screen of Orders By Catalog​

Moving to the Details Screen of Orders By Catalog​

  1. Click the Analytics menu.
  2. Click Orders By Catalog.
  3. From the list of summarization results, click the target Catalog Name or Detail. Transitions to the "Orders By Catalog Details" page.

Re-acquiring Summarized Data to the Latest State​

  1. Check the Last Updated At.
    As needed, execute the Refresh button to re-acquire the latest summarization information.

Narrowing Down Summarization Targets by Basic Conditions and Attributes​

You can narrow down the summarization targets as needed.

For some summarization items related to amounts, it is necessary to specify conditions for identifying prices, such as Currency and Transaction Term.

  1. Order Date Period
    Specify the period of the order dates to be summarized.

    The start and end dates of the period can each be selected from a calendar.

  2. Currency
    You can specify the currency to be summarized using radio buttons.

  3. Transaction Term
    You can specify the transaction term to be summarized using radio buttons.

    *When Currency is filtered, transaction terms other than All can be selected.

  4. Search
    You can narrow down the summarization targets by entering conditions in each item for Buyer or Product.

    tip

    Whether to include products without order results is specified in the Product display conditions by order quantity dropdown within the Product search conditions. The options are as follows:

    • All: Displays all products regardless of whether there are orders.
    • Show only ordered products: Targets only products with order results for summarization.
    • Show only products not ordered: Targets only products without order results for summarization.

Choosing the Axis for Summarization​

Depending on the content you want to check, click the tabs for the following summarization axes to switch the display.

*The Summary tab is displayed by default.

  • Summary
    The summary of the summarization results for the target catalog is displayed.

  • By Product
    Summarization results by product are displayed. You can also do the following as needed:

    • Switching data sources: Click Original Order or Confirmed Order to switch the display.
    • Sorting products: Select a sorting criterion from the Sort dropdown.

  • By SKU
    Summarization results by SKU are displayed. You can also do the following as needed:

    • Select whether to include products without order results in the Product display conditions by order quantity dropdown.
    • Click the column labels of each item to sort the list in Ascending or Descending order of the values corresponding to the items.

  • By SKU Property
    Summarization results by SKU property are displayed. You can also do the following as needed:

    • Narrow down targets by entering a string in the Filter By SKU Properties input field.
      SKU properties containing the specified characters will be displayed.
    • Click the column labels of each item to sort the list in Ascending or Descending order of the values corresponding to the items.

  • By Buyer
    Summarization results by buyer are displayed.

    As needed, click the column labels of each item to sort the list in Ascending or Descending order of the values corresponding to the items.

  • By Product Custom Attribute
    Summarization results by product custom attribute are displayed.

    As needed, click the column labels of each item to sort the list in Ascending or Descending order of the values corresponding to the items.

  • By Product SKU Custom Attribute
    Summarization results by product SKU custom attribute are displayed.

    As needed, click the column labels of each item to sort the list in Ascending or Descending order of the values corresponding to the items.

  • By Buyer Custom Attribute
    Summarization results by buyer custom attribute are displayed.

    As needed, click the column labels of each item to sort the list in Ascending or Descending order of the values corresponding to the items.

Important Notes​

Freshness of Summarization Results​

The display is not always updated in real-time.

Check the Last Updated At and click the Refresh button to re-acquire the data as needed.

Prerequisites for Viewing Amounts​

For some items that summarize amounts, if conditions for uniquely determining prices, such as Currency and Transaction Term, are not aligned, only quantities such as Ordered Quantity and the number of orders will be calculated and displayed.

Please check whether conditions are specified before comparing or totaling amounts.

Orders Not Included in Summarization​

Invalid orders, such as those already rejected (canceled) or returned to cart, are excluded from summarization.

If the count or quantity differs from what is expected, please also check the status of the target orders.