Skip to main content

Bulk Import Products (1 Row per Product | Create Only | Excel)

Overview​

Using an Excel file (.xlsx), you can perform a Bulk Create Products operation in a 1 Row per Product format.

This feature only supports the Create (new registration) of products.

Purpose​

The primary purpose of this feature is to reduce the input workload when registering new Products and SKUs together, enabling product registration tasks to be completed in a short amount of time.

By using the 1-row-per-product input method, the effort required for initial registration is lower compared to SKU-based input (1 row per SKU).

Feature Description​

A type of Bulk Product Import feature​

This feature is a type of bulk product import function.
The import method uses an Excel file (.xlsx).

A single unit of work for this feature consists of a series of operations: downloading the "Product Data Import XLSX File," entering data, and performing the Import.

The input method is 1 row per product, containing multiple SKU information per row​

The input method is 1 Row per Product.
It has a structure that includes multiple SKU information within a single row.

Importing is possible for each individual SKU Template.

Data related to SKU Properties is entered as comma-separated values.
The structure does not hold individual differences for each SKU on a per-row basis.

It is not possible to individually specify different Attribute values for each SKU.

Expansion of SKU data during file import​

SKU Properties entered as comma-separated values are expanded into all possible SKU data combinations for each Product (row) before being registered to the corresponding product.

For example, for a product with Model Number model1, if you enter "BLACK,WHITE" for the Color (SKU Property) and "S,M,L" for the Size (SKU Property), SKUs will be expanded into all combinations of SKU Properties and created as follows:

  • model1_BLACK_S
  • model1_BLACK_M
  • model1_BLACK_L
  • model1_WHITE_S
  • model1_WHITE_M
  • model1_WHITE_L

SKU-level input items are registered uniformly for all SKUs​

SKU-level input items are registered uniformly for all SKUs within the corresponding product.

The SKU-level input items are as follows:

  • Not eligible for backorder
  • SKU weight
  • Price
  • Reference Retail Price
  • SKU manufacturing cost
  • Custom Attribute (SKU level)

Only supports the new registration of products​

This feature only supports the Create (new registration) of products.

  • Product data and SKU data are created simultaneously during new registration.
    • SKU numbers are auto-generated.
  • It does not support updating existing products.
  • It does not support registration or updates in an SKU-based (1 row per SKU) format.

XLSX file items and acceptable values​

The Column Names, number of columns, acceptable values, and Required/Optional status of the Product Data Import XLSX File vary depending on the Maker/Brand environment settings, the selected SKU Template, and settings at the time of Download (e.g., Number of Materials, Number of Category Groups, and selected Custom Attributes).
Always refer to the downloaded XLSX file as the definitive guide for input.

Input specifications change depending on the following elements:

  • Language-specific items: Depends on the languages enabled in Core Preferences.
  • Currency, Transaction Term, and Price: Depends on the settings in Core Preferences.
  • Tax: Depends on the master data in Create a Tax Master.
  • SKU Property: Depends on the selected SKU Template and the definition of SKU Properties (enter the SKU Property Value Code corresponding to each column).
  • Product Attributes such as Category, Material, and Custom Attribute: Depends on the master data in Products menu > Product Attributes and the selections made at the time of download.

Instructions​

Perform the Bulk Create Products (1 row per product, new registration only) using the following steps:

  1. Download the "Product Data Import XLSX File"
  2. Fill in the "Product Data Import XLSX File"
  3. Import the completed "Product Data Import XLSX File"

1. Download the "Product Data Import XLSX File"​

Navigate to the XLSX file download page​

  1. Click the Products menu.
  2. Click the Product Data Import tab.
  3. Click Download Products Data Import XLSX File under Product Data Import (1 Row per Product (Multi-SKU, Create-Only)).
    You will be redirected to the "Product Data Import (1 Row per Product (Multi-SKU, Create-Only))" page.

How to fill out the form​

  1. SKU Template
    Select the SKU Template from the pull-down menu to be used for the bulk import.

    It is not possible to perform a bulk import that mixes different SKU Templates.

  2. File Language
    Select Japanese or English from the pull-down menu.
    The Column Names in the Excel file will be displayed in the selected language.

  3. Number of Category Groups
    Enter the maximum number of category groups to be registerable for a product.

    Enter a number that matches the product with the highest number of category groups to be registered.

  4. Number of Materials
    Enter the maximum number of material items (e.g., shell, lining, other fabric) to be registerable.

    Enter a number that matches the product with the highest number of materials to be registered.

  5. Custom Attributes
    Specify whether to include all Custom Attributes using the toggle button.

    • Enable Include all custom attributes: Selects all Custom Attributes.
    • Disable Include all custom attributes: You can select specific Custom Attributes or download the file without selecting any.

    If you download with custom attributes selected, two items ("Product Level" and "SKU Level") will be added for each custom attribute.

    Input data into "Product Level" when setting custom attributes per product (Model Number), and into "SKU Level" when entering custom attribute values that differ for each SKU.

Execute Download​

  1. Once the input is complete, click the Download button.
    The XLSX file will be downloaded.

2. Fill in the "Product Data Import XLSX File"​

Open the downloaded "Product Data Import XLSX File" and fill in each item.

For the prerequisites of input items, please refer to XLSX file items and acceptable values in the Feature Description section.
It explains the underlying input specifications and items that depend on settings and master definitions.

Description of input items​

The columns displayed in the XLSX file will increase or decrease based on the Maker/Brand environment, SKU Template, and download settings (e.g., Number of Materials, Number of Category Groups, and selected Custom Attributes).

Please fill in each item referring to the following:

Do not rewrite the column names.
Rewriting column names will cause import errors.

  • Model Number
    Enter the Model Number.

  • Product Display Name
    Enter the Product Name for each language.

  • SKU Property
    Items used to create SKU combinations.

    Accurately enter the SKU Property Value Codes corresponding to each column, separated by commas.
    Do not enter extra spaces before or after the commas.

    info

    Refer to Expansion of SKU data during file import in the Feature Description for the SKU expansion logic.
    It explains the logic by which the system automatically expands SKUs with specific examples.

    Also, refer to Precautions when entering SKU Properties for input rules regarding SKU Property Value Codes.
    It also explains the reference locations for the master data used as input values.

  • Backorder Disallowed
    A flag to control whether to designate the item as not eligible for backorder.
    Enter true to designate it as not eligible for backorder, or false otherwise.

  • SKU weight
    Enter the weight according to the unit.
    Only numerical values can be entered.

    *Units are set during the initial setup of the Maker environment. Currently, they cannot be changed by the user.

  • Recognize Description As HTML
    Enter true to use HTML tags in the Product Description, or false otherwise.

  • Product Description
    Enter the detailed description of the product.
    Enter it for each language enabled in Core Preferences.

    If Recognize Description As HTML is set to true, HTML tags can be used.

    The available tags and attributes are as follows:

    • HTML Tags: h1, h2, h3, h4, h5, h6, br, b, strong, em, i, s, div, p, span, table, thead, tbody, tfoot, tr, th, td, ul, ol, li, dl, dt, dd
    • Attributes: style (Only color can be used.)

  • Product Short Description
    Enter a short comment for the Product List.
    Enter it for each language enabled in Core Preferences.

  • Catalog PDF Note
    Enter the remarks column for the Catalog PDF.
    Enter it for each language enabled in Core Preferences.

  • HS Code
    Enter the HS Code used for features such as Export Documents.

  • Product Description Attribute
    Enter the Description of Goods (details of contents) used for features such as Export Documents.
    Use values previously registered in the master data.

  • Price
    Enter the price for each combination of "Transaction Term" and "Currency."
    For "Wholesale Price / Recommended Retail Price," enter the retail price.

  • Reference Retail Price
    Enter the Reference Retail Price (Suggested Retail Price) corresponding to the currency.

  • SKU manufacturing cost
    Enter the manufacturing cost.
    Currently, only Japanese Yen is supported.

  • Tax
    Enter true to apply tax, or false otherwise.
    Taxes registered in the master data will be displayed for each column.

  • Country of Origin
    Enter the 2-letter alphabetic country code.

  • Is Selectable Delivery Date
    Enter true to enable, or false otherwise.
    If enabled, buyers can specify a delivery date at the time of order.

    Any date within the period from Delivery Date1(From) to Delivery Date2(To) can be specified.

  • Delivery Date1(From)
    Enter the estimated delivery date (From) in yyyy-MM-dd format.

    Example: 2026-01-01

  • Delivery Date2(To)
    Enter the estimated delivery date (To) in yyyy-MM-dd format.

    Example: 2026-01-31

  • Category
    Enter category names up to 3 levels.
    A combination of Category, Subcategory, and Subsubcategory forms one category group.
    Use values previously registered in the master data.

  • Material Type
    Enter the material type corresponding to one of the following. This item is related to exports.

    • woven
    • knit
    • leather
    • none: If there is no applicable material type

  • Material Name
    Enter the material composition (blend ratio).

  • Material Parts Name
    Enter the parts name of the material.

    Example (Apparel items): Part names such as "Body," "Shell," "Lining," "Other fabric."

  • Custom Attribute (Product Level)
    You can register values at the product level for custom attributes previously registered in the master data.
    For example, register items common to all SKUs at the product level.

  • Custom Attribute (SKU Level)
    You can register values at the SKU level for custom attributes previously registered in the master data.
    For example, register items that differ for each SKU at the SKU level.

About required items​

Required items (items that cause an import error if left blank) vary depending on the SKU Template, environment settings, and download settings.
Please follow the column definitions in the downloaded XLSX file for Required/Optional status.

The following are examples of required items (varies by SKU Template):

  • Model Number
  • Product Display Name
  • SKU Property
  • Price
  • Reference Retail Price

Saving the XLSX file​

Once data entry is complete, save and close the XLSX file.

If formulas remain in the XLSX file, it will cause an error during import. Please use "Copy > Paste Special > Values" before saving.

3. Import the completed "Product Data Import XLSX File"​

Import the completed "Product Data Import XLSX File" into DEXTRE using the following steps:

Navigate to the Bulk Product Import screen​

  1. Click the Products menu.
  2. Click the Product Data Import tab.
  3. Click Product Data Import under Product Data Import (1 Row per Product, Multi-SKU, Create-Only).
    The "Product Data Import" modal will open.

Execute Product Data Import​

  1. From Select File, select the edited "Product Data Import XLSX File."

  2. Click the Import button.

    • If the process succeeds: Products and SKUs are newly created according to the content of the XLSX.
    • If the process fails: An error message will be displayed. Please correct the file according to the error details.

Important Notes​

Does not support registration or updates in an SKU-based (1 row per SKU) format​

This feature does not support registration or updates in an SKU-based (1 row per SKU) format.
It is also not possible to individually specify different attribute values for each SKU.

To register or update attribute values that differ for each SKU, please use the other Bulk Product Import feature (1 row per SKU method).
The "Product Data Import XLSX File" for the 1 row per SKU method can be downloaded from the following page:

Products menu > Product Data Import tab > "Product Data Import Version2 (Supports Create and Update)"

Only supports new registration; enter strings for Model Numbers that do not duplicate existing products​

Since this feature only supports the new registration of products, please enter strings for Model Numbers that do not duplicate existing products.

Precautions when entering SKU Properties​

SKU Property Value Codes must be values registered in the master data via "Products menu > Product Attributes > SKU Properties tab."
Entering an unregistered SKU Property Value Code will cause an error during import.

Data related to SKU Properties must be entered as comma-separated values.
Do not enter extra white-space characters before or after the commas.

Save with rows, columns, and filters cleared​

Save the "Product Data Import XLSX File" with all rows and columns displayed.

  • If any rows or columns are hidden, unhide them.
  • If filters are applied, clear them.

Convert formulas to values before saving​

If you used formulas in the "Product Data Import XLSX File", convert them to values before saving.

Troubleshooting​

Import fails and an error message is displayed​

If the import fails, please check the following:

  • The Model Numbers do not duplicate existing products.
  • SKU Property data is entered as comma-separated values and does not contain extra white-space characters.
  • Items and acceptable values in the "Product Data Import XLSX File" are entered while considering their dependency on the Maker/Brand environment.
    • Language, Currency, Transaction Term: Core Preferences
    • Tax: Create a Tax Master
    • SKU Property, Description Attributes, Category, Custom Attribute: Products menu > Product Attributes
  • Any formulas used in the XLSX file have been converted to values.
  • No rows or columns are hidden, and no filters are applied.

Items or acceptable values in the import XLSX file are not as expected​

The items and acceptable values in the "Product Data Import XLSX File" vary for each Maker/Brand environment.
In particular, items and options included in the file change based on the following settings and master registrations:

  • Language, Currency, Transaction Term: Core Preferences
  • Tax: Create a Tax Master
  • SKU Property, Description Attributes, Category, Custom Attribute: Products menu > Product Attributes

I want to register different attribute values for each SKU​

  • With this feature, it is not possible to individually specify different attribute values for each SKU.
    To register or update attribute values that differ for each SKU, please use the other Bulk Product Import feature (1 row per SKU method).

  • The "Product Data Import XLSX File" for the 1 row per SKU method can be downloaded from the following page:
    Products menu > Product Data Import tab > "Product Data Import Version2 (Supports Create and Update)"