---
title: "Configure product templates"
slug: "configure-product-templates"
description: "Learn how to configure a product template in Excel format, and upload it into the system."
updated: 2024-08-09T13:57:49Z
published: 2024-08-09T13:57:49Z
canonical: "docs.zilliant.com/configure-product-templates"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zilliant.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Configure product templates

In this topic, learn how to configure a product template in Excel format, and upload it into the system.

## Download a product template

Download the product template as described in [Download a product template](/v1/docs/download-a-product-template).

Alternatively, download the template from the **Content Management** area:

1. From the application left navigation area, select **Administration**.
2. From the top navigation bar, select **Content Management**.
3. Go to **{root folder} > excels > Product**.
4. Select **Products.xlsx**.

          Important

          

- The template file name must be **Products.xlsx**.
- The template file must have three sheets with these defined column names:
  - **_ MasterData**
  - **_ ProductMasterData**
  - **Product**
- You can modify product properties in the **Product** sheet only.

## Customize a product template

### Add a ProductDimension sheet

A product modeler can add a **ProductDimension** sheet to support the import and export capability for dimension fields.

1. Download **Products.xlsx** from **Content Management**.
2. Select **+** to add a sheet.
3. Rename the newly added sheet as **ProductDimension**.
4. Define the **ProductDimension** sheet columns and their content as shown in the following image.

![ProductSheetValues](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/ProductSheetValues.png?sv=2026-02-06&spr=https&st=2026-11-11T12%3A49%3A03Z&se=2026-11-11T13%3A49%3A03Z&sr=c&sp=r&sig=UT0nqyiDNWNzbfc3BKxXXgkdda1Zgz94ewfgGX6P51o%3D)
5. Hide **Column A** from view.
6. Select the **Product** sheet as the default sheet to be used when a user downloads the template from the system.

#### Expressions for the ProductDimension sheet

| Cell | Expression |
| --- | --- |
| A3 | <jx:forEach items="${Products}" var="product"> |
| A4 | ${product.id} |
| B4 | ${product.objectName} |
| C4 | ${product.objectERPId} |
| D4 | ${product.objectExternalId} |
| E4 | ${product.productGrossWeight} |
| F4 | ${product.productNetWeight} |
| G4 | ${product.hasProductWeightUOM.objectERPId} |
| H4 | ${product.productVolume} |
| I4 | ${product.hasProductVolumeUOM.objectERPId} |
| J4 | ${product.productDimesionSize} |
| A5 | </jx:forEach> |

### Define localization for column labels

A product modeler can define the column label to display in a language other than English. In this case, the **Label** and **Comment** column names must comply with the following naming conventions:

- **LABEL_** — A two-letter language code
- **COMMENT_** — A two-letter language code

          Note

          

Maintain the two-letter language codes system in **Administration > Language**.

A product modeler can add new label and comment columns for different languages by copying **LABEL_EN** and **COMMENT_EN** and then changing the name of the column header. For example, change the column headers to **LABEL_DE** and **COMMENT_DE** to define German language localization.

## Upload the product template into the system

1. From the application left navigation area, select **Administration**.
2. From the top navigation bar, select **Content Management**.
3. Select **excels**.
4. Select ![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/CPQ-icon_upload.png?sv=2026-02-06&spr=https&st=2026-11-11T12%3A49%3A03Z&se=2026-11-11T13%3A49%3A03Z&sr=c&sp=r&sig=UT0nqyiDNWNzbfc3BKxXXgkdda1Zgz94ewfgGX6P51o%3D) and then select the defined **Product.xlsx** template file to upload.
5. In the **Overwrite** popup, select **Yes** to override the existing file.