Configure product templates
- 09 Aug 2024
- 1 Minute to read
- Print
- DarkLight
Configure product templates
- Updated on 09 Aug 2024
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
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.
Alternatively, download the template from the Content Management area:
- From the application left navigation area, select Administration.
- From the top navigation bar, select Content Management.
- Go to {root folder} > excels > Product.
- 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.
Download Products.xlsx from Content Management.
Select + to add a sheet.
Rename the newly added sheet as ProductDimension.
Define the ProductDimension sheet columns and their content as shown in the following image.
Hide Column A from view.
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
- From the application left navigation area, select Administration.
- From the top navigation bar, select Content Management.
- Select excels.
- Select
and then select the defined Product.xlsx template file to upload. - In the Overwrite popup, select Yes to override the existing file.
and then select the defined Product.xlsx template file to upload.Was this article helpful?
