Skip to main content

Set Product SKUs as Not Eligible for Backorder via Bulk Import

Overview​

Using Bulk Import Products Version 2 (Supports Create and Update), you can specify SKUs for multiple products as Not eligible for backorder in bulk.
The designation for not being eligible for backorder is made for each SKU.

Purpose​

The primary purpose is to specify settings to make multiple SKUs not eligible for backorder collectively using an XLSX file, rather than operating each item one by one on the screen.
Since it can be specified for each SKU, it helps reduce omissions or incorrect settings for target SKUs, leading to fewer mistakes and the prevention of erroneous operations.

In addition, by operating the downloading, input (editing), and importing of the XLSX file as a single business unit, it helps standardize work procedures and prevent dependency on specific individuals.

Feature Description​

Backorder and Not Eligible for Backorder​

Backorder is a system where products that are out of stock remain available for order, and once an order is placed, the products are shipped as soon as inventory arrives.
In catalogs where backorder is enabled, buyers can enter quantities and place orders even if the inventory is 0.

SKUs set to not eligible for backorder cannot be ordered if the inventory is 0, even in catalogs where backorder is enabled.

Unit of Specification for Not Eligible for Backorder​

The not eligible for backorder status can be specified for each SKU.

Bulk Setting per SKU Template​

Due to the specifications of Product Data Import Version2 (Supports Create and Update), bulk setting for not eligible for backorder is performed per SKU template.
Bulk imports containing a mixture of different SKU templates cannot be performed.

Overall Operation Flow​

This feature considers the following three operations as a single business unit.

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

Instructions​

1. Download "Product Data Import XLSX File"​

Navigate to the XLSX File Download Page​

  1. Click on the Products menu.
  2. Click the Product Data Import tab.
  3. Click Download Products Data Import XLSX File under Product Data Import Version2 (Supports Create and Update).
    You will be transitioned to the "Download Product Data Import XLSX File" page.

How to Fill Out the Form​

The minimum required items are explained below.

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

    Bulk imports containing a mixture of different SKU templates cannot be performed.

  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. Search Products
    You can search for target products by narrowing down each item.

  4. Select Products
    Check the box to select the target products.

    • To select all products that match the search conditions, click Select All.
    • To uncheck all, click Remove All Selections.

    Clicking the Select All button will select all products matching the search criteria.

Execute Download​

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

2. Input "Product Data Import XLSX File"​

  1. Open the downloaded "Product Data Import XLSX File."

  2. Edit the values in the Backorder Disallowed column.

    • SKU rows to be made ineligible for backorder: Enter true.
    • SKU rows to be made eligible for backorder: Enter false.

  3. Once data input is complete, save and close the XLSX file.
    It is recommended to save the file with a different name.

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 Product Bulk Import Screen​

  1. Click on the Products menu.
  2. Click the Product Data Import tab.
  3. Click Product Data Import under Product Data Import Version2 (Supports Create and Update).
    The "Product Data Import" modal will open.

Execute Product Data Import​

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

  2. Click the Import button.

    If the process is successful, products will be added or updated according to the file contents.
    If it fails, an error will be displayed. Correct the file according to the error details and import it again.

Important Notes​

Not Eligible for Backorder is Effective Across All Catalogs​

SKUs set to not eligible for backorder will be handled as such regardless of the catalog.
Currently, it is not possible to make an SKU not eligible for backorder only for a specific catalog.

When Updating, Please Download the Latest XLSX File​

When performing an update operation, always download the latest "Product Data Import XLSX File."
Reusing an XLSX file uploaded in the past may result in discrepancies with the current state of the product master.

Please Keep a Backup of the Downloaded XLSX File​

Always keep a backup of the downloaded XLSX file in case you upload incorrect data.

Avoid Conflicts with Product Master Updates During XLSX Input​

If another member updates the product master on the UI while the "Product Data Import XLSX File" is being filled out, the corresponding changes will not be included in the XLSX file.
Importing the XLSX file without correcting it may result in the other member's changes not being reflected.

Save with Hidden Rows/Columns and Filters Cleared​

Save the "Product Data Import XLSX File" with all rows and columns displayed.
If rows or columns are hidden, or if filters are applied, please clear them.

Convert Functions Used in the XLSX File to Values Before Saving​

If any functions were used in the "Product Data Import XLSX File," please convert them to values before saving.