Skip to main content

Export Partner Inventory List and Summary Sheet (Excel)

Overview​

This section explains the feature for extracting and summarizing partner inventory data and exporting it as an Excel (XLSX) file.

Purpose​

By exporting partner inventory lists or summary data in Excel format, you can check inventory status by buyer and SKU, and utilize it to analyze inventory imbalances or composition.

Based on the confirmed data, you can review product lineups or inventory allocation, helping with decisions that lead to sales.

Feature Description​

Data Export Type​

Specify one of the following three data export types as the unit for data aggregation during export.

  • Partner Inventory List Sheet:
    Exports a partner inventory list where each row represents a combination of a buyer and a SKU.

  • SKU Based Partner Inventory Summary Sheet:
    Exports a summary sheet where each row represents one SKU. In addition to SKU-wise aggregation, it exports a breakdown for each buyer in individual columns.

    If different manufacturing costs exist, they are exported in separate rows.

  • Buyer Based Partner Inventory Summary Sheet:
    Exports a summary sheet where each row represents one buyer. It exports the total sums of the number of products and SKUs.

Price Reference Source​

The exported prices refer to the following sources.

  • Manufacturing Cost: Refers to the cost at the time the partner inventory was dispatched.
  • Original Price: Refers to the latest product master.

Data Extraction Condition​

You can specify the Currency and Transaction Term.

The available choices for currency and transaction terms are determined by the settings enabled in Core Preferences.

How to Specify Export Targets​

The method for specifying export targets varies depending on the data export type.

  • Partner Inventory List Sheet: Specify buyers and products.
  • SKU Based Partner Inventory Summary Sheet: Specify products.
  • Buyer Based Partner Inventory Summary Sheet: Specify buyers.

Instructions​

Moving to the Data Export Screen​

  1. Select the Data Export menu.
  2. Click Inventory.
  3. Click the Data Export tab.
    *It is open by default.

How to Fill Out the Form​

Selecting the Data Export Type​

  1. From Data Export Type, select the desired format from the dropdown.

    • Partner Inventory List Sheet
    • SKU Based Partner Inventory Summary Sheet
    • Buyer Based Partner Inventory Summary Sheet

Specifying Data Extraction Conditions​

  1. Currency
    Select the currency to be exported from the dropdown.

  2. Transaction Term
    Select the transaction term to be exported from the dropdown.

  3. Include Zero Quantity Item
    Use the checkbox to specify whether to include inventory data where the current partner inventory quantity is 0 in the export.

    • When Include Zero Quantity Item is enabled: Includes inventory data where the current partner inventory quantity is 0 in the export.
    • When Include Zero Quantity Item is disabled: Excludes inventory data where the current partner inventory quantity is 0 from the export.

    Inventory data with a partner inventory quantity of 0 refers to inventory data that has a past dispatch record but has become 0 due to returns or sales.

Specifying Export Targets - For Partner Inventory List Sheet​

Specify buyers and products.

  1. Select Target Buyers
    Check the checkboxes for the buyers you wish to export data for.

    • You can narrow down buyers by entering criteria in Search Buyers.
    • To select all buyers matching the search criteria, click Select All.
    • To uncheck all, click Remove All Selections.

  2. Select Target Products
    Check the checkboxes for the products you wish to export data for.

    • You can narrow down products by entering criteria in Search Products.
    • To select all products matching the search criteria, click Select All.
    • To uncheck all, click Remove All Selections.

Specifying Export Targets - For SKU Based Partner Inventory Summary Sheet​

Specify only products.

  1. Select Target Products
    Check the checkboxes for the products you wish to export data for.

    • You can narrow down products by entering criteria in Search Products.
    • To select all products matching the search criteria, click Select All.
    • To uncheck all, click Remove All Selections.

Specifying Export Targets - For Buyer Based Partner Inventory Summary Sheet​

Specify only buyers.

  1. Select Target Buyers
    Check the checkboxes for the buyers you wish to export data for.

    • You can narrow down buyers by entering criteria in Search Buyers.
    • To select all buyers matching the search criteria, click Select All.
    • To uncheck all, click Remove All Selections.

Downloading the Data Export File​

After confirming the input details, click the Download button.

If the process is successful, the Excel file will be downloaded directly.

Important Notes​

Specifying Currency and Transaction Term​

Multiple currencies or transaction terms cannot be specified at once.

You must export for each combination of currency and transaction term.