Use this article to learn how custom product attributes work and how they can be set up in your tRS Service.
About
Custom product attributes can provide a valuable way of adding value to your reporting and analysis that may not be loaded into or not supported by your ERP. A good example is the Season Name where the season my be stored in your ERP as S20 or W22 etc, you can use a product classification file to convert these into Summer, Winter to make it easier to compare seasons.
Please note: Custom product attributes are maintained in an Excel workbook called Product Classification file and are mapped and integrated by a Style Code or description available in your tRS data warehouse.
Product Classification Template
Your location classification file must be formatted and maintained in a specific structure to be uploaded into your tRS service and this is best done in MS Excel.
When preparing your Product Classification Template, the final template with look like this
(Location classification template images shown below)
The Location Classification file supports upto 10 columns
The columns are optional so unused columns should be left blank
And will have the following column headings.
In summary, style product code (or what ever product level you are attributing) from your tRS data warehouse is in the rows with the custom attributes 1 to 10 as columns.
PLEASE NOTE:
1. When new products are added to your ERP and loaded into your tRS service that are used in the mapping, a notification email will be sent to alert the team that an additional product code has been added and will need to be coded up for the used classification columns.
2. Once your file has been set up by the tRS team, you will need to maintain it,
Please click here to see the instructions to maintain your classification file.