Skip to main content

Bulk Reorder Catalog Display Order (Excel)

Overview​

This feature allows for the bulk update of the display priority of catalogs registered within a brand by downloading and importing an Excel file (.xlsx) for import.

Purpose​

Bulk Reorder Catalog Display Order is used to reduce the man-hours required to operate each item one by one on the screen, as the display order of a large number of catalogs can be changed at once.

In addition, bulk management using Excel files can be used for information management and centralization of the catalog list.

Feature Description​

Bulk Action Scope​

Only catalogs for which a "Catalog Code" has been set are subject to control by Bulk Sort.

The Catalog Code can be registered from the Catalogs menu > Edit of the relevant catalog > Basics > Code.

Sort Order Specifications​

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

  • Catalogs with smaller row numbers appear higher in the list.
  • Catalogs with larger row numbers appear lower in the list.

List Position Selection​

You can select where to place the imported catalogs collectively in the list.

  • Top of the list: The imported catalogs are placed at the top of the catalog list.
  • Bottom of the list: The imported catalogs are placed at the bottom of the catalog list.

Handling of Catalogs Excluded from Import​

The following catalogs are not subject to this reordering. They are automatically placed before or after the imported catalogs.

  • Catalogs not included in the Excel file
  • Catalogs for which no catalog code is set

In addition, the order among excluded catalogs will not be changed.

File Language Settings​

The language applied to each item (column name) in the file changes based on the File Language setting at the time of download.

Instructions​

Bulk Reorder Catalog Display Order is performed according to 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. Click Bulk Import Catalog Reordering.
    The "Bulk Sort Catalog Display Order" modal opens.

Download the XLSX file for import​

  1. Select the File Language from the dropdown.
    Specify the language to be displayed for column names and other items in the file.

  2. Click the Download button.
    The "Bulk Reorder Catalog Display Order Import XLSX File" is downloaded.

2. Edit the XLSX file for import​

Edit the XLSX file for import​

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

Do not rewrite the column names.
Rewriting column names will cause an import error.

  • Catalog Code
    An identifier that identifies the target catalog.

  • Catalog Name
    The name of the target catalog.

    This is a reference item for confirming the catalog and is not used for the import process.

Sorting Method​

Sorting defines the display priority of the target catalog group based on the row order in the Excel file (from the second row onwards).
The display order of the catalog list can be changed by rearranging the order of the rows.

Catalogs whose rows have been deleted are excluded from the sorting process.

After sorting the catalogs in the file, the display order of the catalogs is updated by inserting them at the position corresponding to the List Position setting item in Bulk Import the XLSX file for import.

Saving the XLSX file​

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

If formulas remain in the XLSX file, an error will occur 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. Click Bulk Import Catalog Reordering.
    The "Bulk Sort Catalog Display Order" modal opens.

Bulk Import the XLSX file for import​

  1. List Position
    Specify where to place the imported catalogs collectively in the catalog list.

    Select one of the following from the dropdown.

    • Top of the list: The imported catalogs are placed at the top of the list.
    • Bottom of the list: The imported catalogs are placed at the bottom of the list.

  2. Select File
    Select the edited "Bulk Reorder Catalog Display Order Import XLSX File".

  3. Click the Import button.

    If the import is successful, the display order of the catalog list is updated.
    If there is a problem with the input content of the file, the import fails and an error message is displayed.

Important Notes​

Catalog code registration is required​

Only catalogs for which a Catalog Code is registered can be included in the XLSX file for import and downloaded.
To use this feature, please register the Catalog Code in advance.

It can be registered from the Catalogs menu > Edit of the relevant catalog > Basics > Code.

Catalog name is a reference item​

The Catalog Name in the file is merely reference information for identifying the catalog, and even if the Catalog Name item is edited and imported, the name of the catalog itself will not be updated.