Materials

Manage your project's material catalog — prices, units, properties, and bulk import/export via Excel.

Overview

The Materials page is your project's product catalog. Each material represents a named item with pricing, units of measure, and optional technical properties. Materials are used by configurators to calculate order items.

Material list

Materials are displayed in a paginated table with the following columns:

  • Name — the material's display name and optional short description.
  • Group — a category label for grouping related materials, shown as a badge.
  • Vendor code — the supplier's article or SKU number.
  • Unit — the unit of measure (pieces, meters, square meters, etc.).
  • Purchase price — visible to members with purchase price permission.
  • Sale price — the price shown to customers, visible to members with sale price permission.
  • Dealer price — visible to members with dealer price permission.

Depending on your role, some price columns may not be visible.

Filtering

Use the filter bar above the table to search and narrow the material list by name, group, configurator, or other criteria.

Pagination

If the list is long, it is split across pages. Use the previous/next buttons at the bottom of the table to navigate between pages. The current page number is shown on the left.

Adding a material

Click the Add button in the top-right corner to open the material form. It has three tabs:

Main

The primary details of the material:

  • Name (required) — the display name.
  • Group — optional category. As you type, existing groups from your catalog are suggested as autocomplete options.
  • Vendor code — the supplier's article number or SKU.
  • Unit — the unit of measure (select from the available list).
  • Waste % — an optional waste factor (0–100%). If set, the configurator will account for this percentage of material loss when calculating quantities.
  • Description — a brief optional description shown below the name in the table.
  • Prices — purchase price, dealer price, and sale price. All are optional and default to 0.

Properties

An optional set of custom key-value properties for this material, entered in YAML format. Properties can be used by configurators to provide selectable options (e.g. colors, finishes, sizes).

As you type, the YAML is validated in real time. If there is a syntax error, it is shown below the editor and saving is blocked. A preview of the parsed structure is shown below the editor when the YAML is valid.

Example:

color:
  - White
  - Brown
  - Anthracite

Image

Upload an image for this material (PNG, JPEG, or WebP). The image is shown as a thumbnail. You can replace it by uploading a new file, or remove it with the Remove button.

The Image tab is currently disabled and will be available in a future update.

Click Save to create the material.

Editing a material

Click the edit icon on any row to open the same form pre-filled with the material's current data. Make your changes and click Save.

Duplicating a material

Click the copy icon on any row to open the material form pre-filled with all of that material's data, but without an ID — saving it creates a new separate material. Useful for creating variations of an existing item.

Deleting a material

Click the trash icon on a row to delete it. The row dims while deletion is in progress.

Import and Export (Excel)

Materials can be bulk-managed via Excel files using the Export and Import buttons in the top-right corner.

Export

Downloads the current material list as an .xlsx file (materials.xlsx) with three sheets:

  • Materials List — all your current materials, one per row.
  • Example — a sample row showing the expected format and column meanings.
  • Units — a reference list of all valid unit values.

If the catalog is empty, the exported file contains an empty template ready to fill in.

Import

Upload an .xlsx file (must contain a Materials List sheet with the same column structure as the export). The imported rows replace the current in-memory list on the page.

Import rules:

  • Rows without a name are skipped.
  • If a row has a valid existing uuid, it is treated as an update to that material; otherwise a new UUID is generated and a new material is created.
  • The unit must match one of the valid unit values (see the Units sheet in an exported file); invalid values default to pcs.
  • Properties must be valid YAML; invalid values are silently ignored and treated as empty.

The import only updates the list shown on the page — click Save on any affected item or refresh the page to confirm changes are persisted to the server.