Skip to main content

Bulk Import Count Quantities (Excel)

info

This page describes procedures for environments using Inventory Management (New Method).

If your screen layout differs from the one shown on this page, see the Inventory Management (Conventional Method) manuals.

Overview​

This manual explains how to import stock quantities counted during a physical inventory count from an Excel file.

You can use one file to import count quantities for multiple locations within the count session's scope.

Purpose​

Use this feature to record count quantities for multiple locations at once and reduce the work of entering them on the screen for each location.

You can also use it to import count quantities managed in an external system or elsewhere from an Excel file.

Feature Description​

Bulk Import of Count Quantities​

Import count quantities for target locations into an existing count session. Once the session is ready, you can enter quantities in bulk without starting count entry for each location.

The import uses a template containing only field names. Since information such as locations and SKUs is not included, enter it in each row along with the count quantity.

Count quantities are recorded in count rows created for each combination of information such as location, SKU, and lot. Even for the same SKU, quantities can be recorded in separate count rows when the lot, expiration date, or other information differs.

The count row where a quantity is recorded is determined by the information in each row of the Excel file.

Preparing for a Count​

Before entering count quantities, create a count session that specifies the facility and locations to count.

Once count session preparation is complete, you can start entering count quantities for the target locations.

To create a count session, see Create a Count Session.

Fields in the XLSX File for Bulk Import​

Enter the following fields in the XLSX file for bulk import.

  • One is required: Location Code or Location Barcode
  • One is required: SKU Code or SKU Barcode
  • Required: Counted Quantity
  • Enter as needed: Lot Code, Actual Expiry Date, Inventory Segment Code
  • Optional: Memo

Specifying a Lot, Expiration Date, and Inventory Segment​

You can record count quantities by specifying a lot code, expiration date, and inventory segment.

If you import a lot or expiration date that is not in an existing count row, a new count row is added, and the quantity is recorded separately from existing quantities.

If the lot code, actual expiration date, or inventory segment code is left blank, information from an existing count row may be applied.

For information on lots and inventory segments, see the following manuals.

How Imported Quantities Are Handled​

The count quantities entered in the file are recorded in the count rows for the target locations.

You can also add SKUs that have no count rows at the target location if they are registered to the target brand and meet the import conditions.

When importing into a count row that already has a recorded count quantity, the quantity in that row is replaced by the quantity entered in the file. It is not added to the recorded quantity.

Under Count target locations, you can check the entry status of each location. If you import into a location with the status Saved, quantities that have already been entered may be replaced.

Status After Import​

Importing alone does not complete count entry for the locations.

After importing, you can still add or correct count quantities manually as needed.

Importing alone does not change stock quantities in the system. Stock quantities are updated after the subsequent review and approval.

Instructions​

Bulk import count quantities using the following steps.

  1. Download the XLSX File for Bulk Import
  2. Enter Information in the XLSX File for Bulk Import
  3. Import the XLSX File for Bulk Import

Download the XLSX File for Bulk Import​

  1. Click the Inventory menu.
  2. Click the Counting tab.
  3. Search
    Enter search criteria to narrow down the count sessions.
  4. Click the Proceed with count button for the target count session.
    The "Count session details" page opens.
  5. Click the Bulk count entry import button.
    The "Bulk Count Entry Import" modal appears.
  6. Click the Download template button.
    The XLSX template is downloaded.

Enter Information in the XLSX File for Bulk Import​

Either Location Code or Location Barcode is required.
Either SKU Code or SKU Barcode is required.

  • Location Code
    Enter the location code of the location where the products to be counted are stored.

    • The location must be included in the count target locations.
    • You can enter multiple locations.
    • Locations not included in the count target locations cannot be imported.

    You can check location codes under Count target locations on the count session details page.

  • Location Barcode
    Enter the location barcode of the location where the products to be counted are stored.

  • SKU Code
    Enter the SKU code of the product counted.

  • SKU Barcode
    Enter the SKU barcode of the product counted.

  • Counted Quantity *Required
    Enter the total quantity actually counted for the SKU.

    • Enter an integer greater than or equal to 0. If the counted quantity is 0, enter 0.
    • Rows with a blank Counted Quantity are not imported.

    If specifying a lot or inventory segment, enter the required information and enter the stock quantity in the corresponding row.

  • Lot Code
    To specify a lot, enter the lot code of the stock being counted.

    If you do not manage stock by lot, leave it blank.

  • Actual Expiry Date
    If the stock being counted is managed by expiration date, enter its expiration date.

    Enter the date in YYYY-MM-DD or YYYY/MM/DD format.
    Example: 2027-01-31, 2027/01/31

  • Inventory Segment Code
    To specify an inventory segment, enter the code of a registered and active segment.

    If you do not manage stock by inventory segment or do not specify one, leave it blank.

  • Memo
    Enter a note if needed.

info

For details on how blank Lot Code, Actual Expiry Date, and Inventory Segment Code fields are handled, see Checking Lots, Expiration Dates, and Inventory Segments.

Import the XLSX File for Bulk Import​

  1. Click the Inventory menu.

  2. Click the Counting tab.

  3. Search
    Enter search criteria to narrow down the count sessions.

  4. Click the Proceed with count button for the target count session.
    The "Count session details" page opens.

  5. Click the Bulk count entry import button.
    The "Bulk Count Entry Import" modal appears.

  6. Click the Select File button and select the completed Excel file.

  7. A preview appears. Check the target locations, number of rows, and validation results.

    • A warning about replacing quantities appears for locations with quantities already entered. If importing into the same count row, the entered quantity is replaced by the quantity in the file.
    • If an error appears, check the details, correct and save the file, and select it again.
    tip

    Open File rows to check the location, SKU, count quantity, lot, actual expiration date, inventory segment, disposition, and import destination for each row to be imported.

    Import destination indicates whether an existing count row will be updated or a new count row will be added. Unknown may be displayed if the destination cannot be identified.

  8. Review the preview and click the Import button.
    When the import is complete, the number of imported rows and target locations are displayed. The imported locations remain in progress.

    To check count rows and count quantities, click the Continue count button for the target location.
    The count quantity entry screen opens, where you can check imported quantities and differences from theoretical stock.

Important Notes​

Import Prerequisites​

You can import when count session preparation is complete and the status is Ready to count or Counting.

A file containing locations where count entry is complete or that have been skipped cannot be imported. To import, cancel completion or remove the skip for the relevant locations.

If you cannot import count quantities, ask your manufacturer organization's primary owner, owner, or administrator to check your access to the target brand and inventory permissions.

For information on assigning roles, see Grant Roles to Members.

Entered Quantities and Blank Fields​

Previously recorded quantities in the same count row, including quantities entered manually or by barcode scan, are replaced by the file's Counted Quantity. Changes made by another person after preview may also be overwritten, so coordinate work with other staff.

Rows with a blank Counted Quantity and count rows not included in the file are not changed. A row with 0 entered is recorded as counted with a quantity of zero.

Checking Lots, Expiration Dates, and Inventory Segments​

Leaving Lot Code, Actual Expiry Date, or Inventory Segment Code blank does not necessarily record it as "none". Information from an existing count row may be applied.

If the lot code or actual expiration date differs from an existing count row, a new count row may be added.

Before importing, check the displayed information and import destinations in the preview.

File Limits and Checks​

The file must be in .xlsx format, no larger than 5 MB, and contain no more than 5,000 data rows excluding field names. Rows with a blank Counted Quantity also count toward the row limit. Merged cells cannot be used.

Treat location and SKU codes and barcodes as text in Excel so that leading 0s are not removed. If the same destination is specified in multiple rows, the quantities are not combined and an error occurs.

If an error prevents import, the entire file cannot be imported. Correct and save the file, select it again, and check the preview.