Skip to main content

Bulk Import to Reorder and Register Catalog Products (Excel)

Overview​

This feature allows you to change the display order of products linked to a specific catalog and perform bulk product addition/registration by downloading and importing an Excel file (.xlsx) for import.

Each row consisting of a combination of "Catalog Code" and "Model Number" in the Excel file is managed as one product within the catalog.

Purpose​

The primary purpose is to create time by reducing the man-hours required for reordering and additional registration of products within a catalog.

It is also useful for bulk management and centralization of information using Excel files.

Feature Description​

Import Mechanism​

During import, products are identified by matching them with the "Model Number" already registered in the system.

"Catalog Name" and "Product Name" are reference items and are not used for matching or data updates.

Reordering Specifications​

The order from the second row onwards in the Excel file becomes the display order for the catalog product list as is.

  • Products in the catalog with smaller row numbers will appear higher in the list.
  • Products in the catalog with larger row numbers will appear lower in the list.

Additional Registration Specifications​

By adding a "Model Number" that is not yet registered in the catalog as a row, you can execute product linking to the target catalog in bulk.

For rows to be added, both the "Catalog Code" to identify the target catalog and the "Model Number" are required.

Selection of Placement Position​

You can select where to collectively place the imported catalog products within the list.

  • Top of the list: The imported catalog products will be placed at the beginning of the catalog product list.
  • Bottom of the list: The imported catalog products will be placed at the end of the catalog product list.

File Language​

Based on the file language setting at the time of download, the language applied to each item (column name) in the file will change.

Instructions​

Bulk import for reordering catalog products is performed in the following flow.

  1. Download the XLSX file for import
  2. Edit the XLSX file for import
  3. Upload the XLSX file for import and perform bulk import

1. Download the XLSX file for import​

Move to the download page for the XLSX file for import​

  1. Click the Catalogs menu.

  2. From the catalog list, click the Detail button for the catalog you wish to configure.
    You will be redirected to the "Catalog Details" page.

    You can also narrow down catalogs by entering criteria in the Filter Catalogs.

  3. Click Bulk Import Catalog Product Reordering.
    The "Bulk Reorder Catalog Product Display Order (Also supports registering products to catalogs)" modal will open.

Download the XLSX file for import​

  1. Select the File Language from the drop-down menu.
    Specify the language to be displayed for column names and other items within the file.

  2. Click the Download XLSX File button.
    The "XLSX file for bulk import of catalog product reordering" will be downloaded.

2. Edit the XLSX file for import​

If there are already products applied to the source catalog, data will be entered for each product, one row at a time.

Editing the XLSX file for import​

Open the downloaded XLSX file and enter each item according to the following information.

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

  • Catalog Code
    An identifier to specify the target catalog.
    When adding new products to a catalog, enter the same catalog code.

  • Model Number
    The model number of the target product.
    When adding new products to a catalog, enter the target product number (model number).

  • Catalog Name
    The name of the target catalog.
    This is a reference item for confirming the catalog and is not used in the import process.

  • Product Name
    The name of the target product.
    This is a reference item for confirming the product and is not used in the import process.

How to Reorder​

Reordering defines the display priority of the target product group based on the row order (from the second row onwards) in the Excel file.
By swapping the order of rows, you can change the display order of the catalog product list.

Products whose rows have been deleted will be excluded from the reordering process.

After reordering the products in the file, the display order of the products will be updated by inserting them into the position corresponding to the LIST POSITION setting in the Bulk import of the XLSX file for import.

Saving the XLSX File​

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

Please note that if functions remain in the XLSX file, it will cause an error during import, so please paste using "Copy > Paste Special > Values" before saving.

3. Upload the XLSX file for import and perform bulk import​

Move to the bulk import page for the XLSX file for import​

  1. Click the Catalogs menu.

  2. From the catalog list, click the Detail button for the catalog you wish to configure.
    You will be redirected to the "Catalog Details" page.

    You can also narrow down catalogs by entering criteria in the Filter Catalogs.

  3. Click Bulk Import Catalog Product Reordering.
    The "Bulk Reorder Catalog Product Display Order (Also supports registering products to catalogs)" modal will open.

Bulk import of the XLSX file for import​

  1. LIST POSITION
    Specify where to collectively place the imported catalog products within the catalog product list.

    Select one of the following from the drop-down menu.

    • Top of the list: The imported catalog products will be placed at the top of the list.
    • Bottom of the list: The imported catalog products will be placed at the end of the list.

  2. Select File
    Select the edited "XLSX file for bulk import of catalog product reordering".

  3. Click the Import button.

    If the import is successful, the reordering settings for catalog products and product registration to the catalog will be completed.
    If there are issues with the input content of the file, the import will fail and an error message will be displayed.

Important Notes​

Catalog Code Registration is Required​

You can only download the XLSX file for import for catalogs that have a catalog code registered.
To use this feature, please register a catalog code in advance.

The catalog code can be registered from the "Catalogs menu > Edit for the relevant catalog > Basics > Code" item.

Causes of Import Errors​

The import process will fail in the following cases.

  • If a "Model Number" that does not exist in the system is included
  • If the file format or header language differs from the system definition

Catalog Name and Product Name Are Not Updatable​

"Catalog Name" and "Product Name" in the file are reference items that are not used for data matching or updates.

Even if you edit and import these reference items, the names on the system will not be updated.