Logo

Bulk Import via Excel

The Bulk Import via Excel feature allows users to quickly add multiple custom items to the Items list by importing an Excel file containing predefined item properties. This method is ideal for batch creation, saving time compared to manual entry.

Access the Item List

Go to the Items section. Here you can view your existing items, add new ones, or start a bulk import from Excel.Click Import Items (top-right) to open the bulk import screen.

Excel Import Screen

  • All values must follow the user’s unit settings.
  • Maximum 1000 rows are supported.
  • You can drag & drop your file, paste with CTRL+V, or select it manually.

The import screen asks you to upload an Excel file (.xls or .xlsx).Key points:

Download Template

If you’re unsure about the correct format, click Download Template (top-right).This gives you a ready-made Excel sheet with the required column names, preventing errors like missing or misnamed columns.

Excel Template Structure

The template contains the following columns:

  • BoxName: Name of the box
  • Count: Quantity (optional)
  • Color (HEX): Color in HEX format (optional, must start with #). If you do not select a color, the system will automatically assign one.
  • Length / Width / Height: Dimensions will follow the user’s unit settings.
  • Weight: Weight will follow the user’s unit settings
  • No Tilt / No Rotate / No Stack / On Floor: Restrictions (mark with X to enable)

Sample rows such as Sample Box 1–4 are included as examples.

Prepare, Upload, and Check Results

1.Prepare Your Excel File

2.Upload the File

After uploading, press Import to load your data into the system.

3.Check Import Results

Successful Import

Failed Import

  • Item with this name already exists.
  • Restriction fields should be ‘X’ or empty.
  • Width value is invalid.

To fix these issues, make the necessary corrections in Excel and re-import.