Skip to content

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.

TemplateWhere it's importedColumns, in orderDownload
ItemsItems → Import; in the app Goods → ImportCode, Name, Barcode, Unit, Price, Tax Rate, Weight, then for three package levels the quantity and barcode (commercial, transport, finishing), Trackingitems.xlsx
Fixed assetsFixed assets → Import; in the app Assets → ImportInventory Number, Name, Barcode, Unit, Serial Number, Type, Quantityfixed-assets.xlsx
LocationsCodebook → Locations → ImportCode, Name, City, Address, Emaillocations.xlsx
WarehousesCodebook → Warehouses → ImportCode, Name, Location Codewarehouses.xlsx
Warehouse stockWarehouse → > → Warehouse Items → ImportArticle Code, Quantity, Pricewarehouse-stock.xlsx
CustomersCodebook → Customers → ImportCode, Name, Tax ID, Address, City, Email, Phonecustomers.xlsx
SuppliersCodebook → Suppliers → ImportCode, Name, Tax ID, Address, City, Email, Phonesuppliers.xlsx
Partial count — itemsItems of a partial goods count → ImportCodepartial-count-items.xlsx
Partial count — assetsItems of a partial asset count → ImportInventory Numberpartial-count-assets.xlsx
Count list itemsA count list made in the portal → ImportCode, Quantity, Price, Notecount-list-items.xlsx
Record itemsA record → Import (portal and app)Code, Quantity, Note, Price, Expiry daterecord-items.xlsx

Special values are written as in the template, in English:

  • item Tracking: none (no tracking), serial (serial numbers) or lot (lots);
  • fixed asset Type: fixed_asset (fixed asset) or small_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.