Skip to main content

Bulk Import Original Delivery Notes (Excel)

Overview​

This feature allows you to create multiple original delivery notes in bulk through downloading and importing an Excel file (.xlsx) for import.

Purpose​

By using the Excel file for import to register multiple delivery notes at once, you can reduce the manual effort of individual creation and save man-hours.

It is useful for streamlining delivery operations and creating time, as it allows you to create delivery notes for multiple different buyers in a single import operation.

Feature Description​

About the bulk creation of multiple original delivery notes​

Based on the unique code registered to the buyer, you can create original delivery notes for multiple buyers in bulk.

As a preliminary preparation, the following masters must be registered.

  • Buyer Unique Code
    • To check or change the buyer master settings, refer to Edit a Buyer.
  • Product Model Number and SKU No.
    • To check or change the product master settings, refer to Edit a Product.

Currency, Transaction Term, and Deposit Condition​

Currency, Transaction Term, and Deposit Condition refer to the Buyer master settings.

To check or change the buyer master settings, refer to Edit a Buyer.

Required input items for the XLSX file for import​

In the XLSX file for import, the following items are required.

  • 納品書番号
  • 取引バイヤー固有コード
  • 請求書作成可能
  • 品番
  • SKU番号
  • 卸価格
  • 数量

Instructions​

Bulk import of original delivery notes is performed according to the following flow.

  1. Download an import file
  2. Input into the XLSX file for import
  3. Import the XLSX file for import

1. Download an import file​

  1. Click Transactions menu > Delivery Management.
  2. Click Bulk Import Delivery Notes.
    The "Bulk Import Delivery Notes" modal will be displayed.
  3. Click Download XLSX File.
    The "XLSX file for import" will be downloaded.

2. Input into the XLSX file for import​

Open the downloaded "XLSX file for import" and enter the data.

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

  • 納品書番号 (Required)
    Enter any value.

    During import, identical values are identified as a single delivery note.

  • 取引バイヤー固有コード (Required)
    Enter the unique code of the buyer who is the delivery destination.

  • 納品日
    This item corresponds to the delivery date (document date) of the delivery note.

    Enter in the format yyyy-MM-dd.

    Example: 2026-01-15

    If left blank, the delivery note will be created with the delivery date unregistered.

  • 請求書作成可能 (Required)
    Enter true to allow it to be linked to an invoice, or enter false to make it non-billable.

  • 品番 (Required)
    Enter the model number from the product master.

  • SKU番号 (Required)
    Enter the SKU number defined within the product master for the corresponding model number.

  • 卸価格 (Required)
    Enter the wholesale price according to the buyer's transaction currency.

  • 数量 (Required)
    Enter the quantity to be delivered per SKU.

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

3. Import the XLSX file for import​

  1. Click Transactions menu > Delivery Management.

  2. Click Bulk Import Delivery Notes.
    The "Bulk Import Delivery Notes" modal will be displayed.

  3. Click Select File.

  4. Select the created "XLSX file for import."

  5. Click the Import button.

    If the process is successful, original delivery notes will be created in bulk.

Important Notes​

Examples of import errors​

In the following cases, an error will occur during import.

ItemCondition for Error
Cell A1If cell A1 of the import file is edited or deleted
Required itemsIf required items are blank or values outside the rules are entered
取引バイヤー固有コード, 品番, SKU番号If a unique code for a buyer, model number, or SKU number that does not exist in the master is entered
Common items within the same delivery note codeIf values for 取引バイヤー固有コード, 納品日, and 請求書作成可能 do not match across rows for the same delivery note code
SKU No. within the same delivery note codeIf SKU numbers are duplicated within the same delivery note code

Be careful with input errors for Delivery Note Code​

Data in rows with the same 納品書番号 in Excel will be processed together as a single delivery note during import.

Do not enter the same delivery note code for delivery notes to different buyers or for data you wish to separate as different delivery notes.

On the other hand, please note that if you enter a different delivery note code for every row, data that should originally be combined will be created as separate delivery notes, and a large number of delivery notes may be created unintentionally.