Print or export your item list

After reading this, you'll be able to print your items with price, tax rate and description (respecting the current filters and sort order) or download them as an Excel file.

Want to check your master data — prices, tax rates and descriptions at a glance? In Inventory → Catalog there are two ways: a print view and an Excel export.

  1. Open Inventory and stay on the Catalog tab.
  2. Set up the list the way you want it printed: search, categories, tags, item type and the sort order next to the filters.
  3. Click Print list next to the sort order. Your browser's print dialog opens — you can also choose “Save as PDF” there.

The printout contains exactly the list you see on screen — same filters, same order. The header shows the number of items, the sort order, active filters and the print date.

For each item the sheet shows: name with its description underneath, item number, category, unit, price net, price gross and tax rate. If an item is managed by gross price, the gross price you entered stays unchanged.

Export to Excel

Click Export products at the top right. You get an Excel file with all items in your workspace — regardless of the filters in the list. It contains item number, name, description, category, type, unit, price (net), tax rate, revenue account, cost center, debit/credit account and supplier item number. If you work with price groups, there is an extra “Price <group>” column per group with the fixed net group price; without a fixed price the cell stays empty. If an item has several suppliers, the columns “Supplier 2”, “Supplier 2 item number”, “Supplier 2 cost price”, “Supplier 2 cost basis”, “Supplier 2 package” and “Supplier 2 units per package” are added for each additional supplier — the import reads them back the same way. The file also contains the columns Variant of (SKU) and Variant label: the row of a size carries the main item’s item number and its own label, both cells stay empty on the main item. That way every size stays a size when the file is imported again. The column headings match the product editor (for example SKU, Tax, Units per tier and Only from guest count) and follow the order of its tabs: basic data, price & stock, accounting, suppliers, variants, quantity rule. Files with the earlier headings can still be imported. The export is the maintenance and accounting list with these fields, not a full dump of all product data.

  • The description is written as plain text (no formatting).
  • The columns match the product import: you can add accounts and upload the file again (see Import products).
  • The button only appears if your role has the Export data permission.

Good to know

  • Items with variants: in the catalog the main item appears as a group row with a price range and the number of its variants; Show variants expands the sizes. The export contains main item and sizes as separate rows, distinguished by the column Variant of (SKU). How variants work is described in Items with variants.
  • Need a filtered or sorted list as a file? Print it and choose “Save as PDF” in the print dialog.
  • If the list shows a notice that not all items were loaded, narrow it down by category or tag first.

Univents newsletter

Three topics, pick any. Roughly once a month, no more.

Topics