Import templates
You can load data into Popis from an Excel file. Download the template for what you're importing, fill it in and upload it with the Import button on the matching page. Every template has a row of column names and two example rows — delete or overwrite the examples.
| Template | Where it's imported | Columns, in order | Download |
|---|---|---|---|
| Items | Items → Import; in the app Goods → Import | Code, Name, Barcode, Unit, Price, Tax Rate, Weight, then for three package levels the quantity and barcode (commercial, transport, finishing), Tracking | items.xlsx |
| Fixed assets | Fixed assets → Import; in the app Assets → Import | Inventory Number, Name, Barcode, Unit, Serial Number, Type, Quantity | fixed-assets.xlsx |
| Locations | Codebook → Locations → Import | Code, Name, City, Address, Email | locations.xlsx |
| Warehouses | Codebook → Warehouses → Import | Code, Name, Location Code | warehouses.xlsx |
| Warehouse stock | Warehouse → > → Warehouse Items → Import | Article Code, Quantity, Price | warehouse-stock.xlsx |
| Customers | Codebook → Customers → Import | Code, Name, Tax ID, Address, City, Email, Phone | customers.xlsx |
| Suppliers | Codebook → Suppliers → Import | Code, Name, Tax ID, Address, City, Email, Phone | suppliers.xlsx |
| Partial count — items | Items of a partial goods count → Import | Code | partial-count-items.xlsx |
| Partial count — assets | Items of a partial asset count → Import | Inventory Number | partial-count-assets.xlsx |
| Count list items | A count list made in the portal → Import | Code, Quantity, Price, Note | count-list-items.xlsx |
| Record items | A record → Import (portal and app) | Code, Quantity, Note, Price, Expiry date | record-items.xlsx |
Special values are written as in the template, in English:
- item Tracking:
none(no tracking),serial(serial numbers) orlot(lots); - fixed asset Type:
fixed_asset(fixed asset) orsmall_inventory(small inventory).
Tip
The templates on this page are in English. In the portal, under Documentation → Sample Templates, and in the Import dialog (Download example), a template is downloaded in the portal's current language — any of the 14 languages.
How the file is read and what happens to existing data: How importing works.

