Skip to main content

BOM Upload — Handling Common Errors

Use this guide to quickly understand error messages you might see after uploading a Bill of Materials (BOM) and how to resolve them.

Updated over a month ago

Before you upload (quick checklist)

  • One worksheet only (no extra tabs): use .csv and not .xlsx

  • Decimal separator is a dot (.)

  • File size ≤ 5 MB.

  • Items are mass-based (e.g., kg, g, t).

  • Column headers must match our template naming (case-insensitive)

  • Item name is required. If you include amount, you must include unit (and vice versa).

1) Excel file with more than 1 worksheet

How to fix it

  • Move the BOM data to one tab and name it clearly (e.g., BOM).

  • Delete extra tabs (including hidden ones) or copy the data into a new one-sheet workbook.

  • Re-save as .csv and re-upload.

2) Decimal separator must be a dot (.), not a comma (,)

How to fix it

  • Replace commas with dots in the Amount column (e.g., change 1,2 → 1.2).

  • Ensure cells are true numbers, not text (no thousand separators inside the cell value).

  • If your regional settings use commas:

    • In Excel: set the Amount column to Number and enter decimals with a dot, or temporarily switch File → Options → Advanced → Use system separators off and set Decimal separator to .

    • If working from CSV: ensure the file uses . for decimals

3) File exceeds limit (max. 5 MB)

How to fix it

  • Right-click the file and select "Properties" to find out the size of your file

  • Remove unused columns/rows, images, and formatting.

  • Remove unecessary tabs

  • Use online compressors

4) Only mass-based items supported

How to fix it

  • Convert counts/length/area/volume to weight

  • Use supported mass units (e.g., kg, g, t).

5) Wrong column name headers

How to fix it

  • Use the expected headers, for example:

    • Item Name (required)

    • Amount (number)

    • Unit (mass unit)

    • (Optional extras: country of origin,hs code,

  • Fix typos and extra spaces (e.g., use Item Name, not Item Nome).

  • Keep one header row only

  • Remove merged cells.

6) Only “Item Name” is mandatory, but “Amount” and “Unit” must come together

How to fix it

  • Option A: Provide both Amount and Unit for each row (e.g., 12.5 + kg).

  • Option B: Remove both fields entirely for a name-only upload (you can complete amounts later in the app).

  • Ensure numeric formatting for Amount (no text like 10 kg in the same cell).

Example minimal BOM (valid)

Item Name

Amount

Unit

Aluminum sheet

125

kg

PET pellets

2.3

t

Fastener M4

  • Rows 1–2: valid with Amount and Unit.

  • Row 3: valid name-only.

Still stuck?

  • Re-download the latest BOM template from the Help Center.

  • Try a small test upload (5–10 rows) to isolate the issue.

  • If problems persist, contact support with your file and a screenshot of the error message.

Did this answer your question?