Skip to content

How importing works ​

The same principles apply to every import in Popis, in the portal and in the app.

File rules ​

  • Column order matters, not the column names. The first row is always skipped (it's the header), and columns are read in the order of the template. Don't delete or move columns; leave the ones you don't use empty.
  • Formats: .xlsx, .xls and .csv, up to 50 MB. Importing goods and assets in the app accepts .xlsx and .xls.
  • Several barcodes of one item are separated with a semicolon: 8600001234567;8600001234568.
  • Special values (tracking none/serial/lot, type fixed_asset/small_inventory) are written in English, as in the template.

Import with a preview ​

Items, fixed assets, locations, warehouses, warehouse stock, customers and suppliers are first shown in the portal on the Import Preview page — nothing changes until you confirm. A detailed example with screenshots: Import and export of items and assets.

Preview labelMeaning
NewThe code doesn't exist — it will be added.
UpdatedThe code exists and the data differs — it will be updated.
UnchangedThe code exists with the same data — nothing changes.
DuplicatesThe same code repeats in the file.
SkippedThe row can't be imported; the reason is on the row (e.g. Code is empty, Location not found in your catalog, Price is not a valid number).

Only New and Updated rows are imported. Existing records are matched by code (fixed assets by inventory number) and updated, not duplicated. An import never deletes anything that isn't in the file. An import that would go over your package's limit (e.g. the number of items) is refused.

In the app, importing goods and assets also first shows how many rows are New, Update and Same before importing.

Import without a preview ​

Items of a count list, a record and a partial count are imported at once:

  • if any row has an invalid quantity or price, the whole file is rejected and nothing is imported;
  • an item already on the record is replaced, a new one is added;
  • at the end you see how many were imported, e.g. Imported 12 item(s), skipped 0.

Warehouse stock ​

Importing warehouse stock writes the item's new quantity and price — it doesn't add them to the existing ones.