Import Products
After reading this, you'll be able to prepare a correctly structured CSV file for the product import, fill in all required fields, and resolve bundle relationships via parent SKUs.
You can import your entire product catalog into Univents via CSV file. This saves a lot of time during initial setup when you want to create many items, services, and bundles at once.
Prepare the file
The import file is a spreadsheet in CSV format. You can create it in Excel, Google Sheets, or any other spreadsheet application and then export it as .csv. Use a comma or semicolon as the delimiter — both are supported.
Each row represents one product. Bundles and their components go in the same file; the relationship is resolved via a shared SKU (column SKU).
Required fields
These fields must be filled in for every row:
| Column name | Meaning and allowed values |
|---|---|
Name Translation | Product name shown to customers (e.g. Bruschetta Classica) |
Internal Name | Internal name for sorting — not visible to customers |
OS Type | Product type: physical_product, service, digital_product, ticket |
OS Billing Model | Billing model: per_piece, per_guest, per_hour, per_kilometer, per_guest_and_hour |
Category | Category name (e.g. Catering, Technology) — must already exist in Univents |
Price Net | Net price as a number (e.g. 12.50) |
Tax Rate | Tax rate as a number without the percent sign (e.g. 7, 19) |
Color | Hex color code for the calendar view (e.g. #FF5733) |
isRental? | ja for rental items, nein otherwise |
Unlimited? | ja if stock is not tracked, nein for finite inventory |
Packaging Quantity | Package size (e.g. 1 for individual units, 2 for a 2 kg package) |
Optional fields
These fields can be added to import products more completely:
| Column name | Meaning |
|---|---|
SKU | Item number — required if you are importing bundles |
Description Translation | Description text shown to customers |
Unit 1 Alternative | Alternative label for the unit (e.g. Portion, Liter) |
Cost Net | Internal cost for contribution margin calculation |
Total Stock | Current stock level — only relevant if Unlimited? = nein |
Storage Location | Storage location |
Tags | Comma-separated keywords (e.g. cutlery,stainless-steel) |
hideWhenOffSale | ja / nein — hide the product outside of its season |
hideWhenOutOfStock | ja / nein — hide the product when stock reaches 0 |
Internal Comment | Visible internally only |
Allergens (List) | Comma-separated allergens (e.g. Nuts,Lactose) |
Weight, Height, Width, Length | Dimensions and weight for packing lists |
Wattage, Amperage, Power Connection | Technical specs for equipment (e.g. for function sheets) |
Supplier | Primary email address of the supplier |
Resolving bundles via parent SKUs
A bundle consists of multiple components. To define bundles in the import, you use two mechanisms:
- The bundle itself gets its own row with a SKU (e.g.
BUNDLE-DINNER-01). - Each component row contains that same value in the
Parent SKUcolumn.
Univents reads the Parent SKU column during import and automatically links all rows sharing the same parent SKU as components of the corresponding bundle. The Packaging Quantity column specifies how many units of the component are included per bundle unit.
Example:
| Name Translation | SKU | Parent SKU | Packaging Quantity |
|---|---|---|---|
| Dinner Package | BUNDLE-DINNER-01 | (empty) | 1 |
| Soup | COMP-SOUP | BUNDLE-DINNER-01 | 1 |
| Main Course | COMP-MAIN | BUNDLE-DINNER-01 | 1 |
Production-relevant fields (Kitchen Monitor)
If a product should appear in the Kitchen tab (Kitchen Monitor), add these fields:
| Column name | Meaning |
|---|---|
Production | ja / nein — shows the product in the Kitchen Monitor |
Production Category | Main category for the production view |
Subcategory | Sub-category for further sorting |
Production Lead Time | Lead time in hours (preparation time before delivery) |
Shelf Life | Minimum shelf life in hours |
Production Type | in_house (internal) or external (external) — write exactly as shown |
Recipe | Recipe description (optional) |
Starting the import
Navigate to Inventory in the menu. In the top right corner you will find the Import button. Click it and submit your completed CSV file. The Univents team will review the file and follow up with you for the final transfer into your account.
Frequently asked questions
Does the category need to be created in Univents beforehand? Yes. Categories are not created automatically during import. Create all categories first in the Categories tab in Inventory.
What happens if a required field is missing? Rows with missing required fields are skipped during import. You will receive feedback indicating which rows could not be imported.
Can I update existing products? The initial import creates new products. If you want to update an existing product by its SKU, contact the Univents team — an update run over existing records is available on request.
What file format is expected? A .csv file in UTF-8 encoding. Both comma and semicolon delimiters are supported. When exporting from Excel, use CSV UTF-8 (Comma delimited).