---
title: How do I set up custom product attributes?
description: Use this article to learn how custom product attributes work and how they can be set up in your tRS Service.
---

[Skip to content](https://fundamentals.theretailscore.com/knowledge/how-do-i-set-up-custom-product-attributes#main-content)

English

Show submenu for translations

[Customer portal](https://fundamentals.theretailscore.com/support-client-view?hsLang=en)

![mousemat.png\]](https://fundamentals.theretailscore.com/hs-fs/hubfs/mousemat.png?height=40&name=mousemat.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Customer portal](https://fundamentals.theretailscore.com/support-client-view)
- Go to theretailscore.com

 Go to theretailscore.com

 The Retail Score Fundamentals

- There are no suggestions because the search field is empty.

1. [TRS Fundamentals](https://fundamentals.theretailscore.com/knowledge?hsLang=en)
2. [tRS Set Up](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en)
3. [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#01-getting-started)

# How do I set up custom product attributes?

## 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)*

![](https://fundamentals.theretailscore.com/hubfs/image-png-Sep-12-2021-04-52-11-48-AM.png)

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.

![](https://fundamentals.theretailscore.com/hubfs/image-png-Sep-12-2021-04-59-16-00-AM.png)

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.](https://fundamentals.theretailscore.com/knowledge/how-to-maintain-your-external-upload-files-in-trs?hsLang=en)

 

- [tRS Set Up](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#main-content)

    - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#01-getting-started)
    - [02 How to Guide](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#02-how-to-guide)
    - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#03-get-help)
- [tRS Insights Portal](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#main-content)

    - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#01-getting-started)
    - [02 How To Guides](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#02-how-to-guides)
- [tRS Pivot4Power Users](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#main-content)

    - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#02-how-to-guide)
    - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#03-get-help)
- [tRS Modules](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#main-content)

    - [01 General Ledger](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#01-general-ledger)
    - [02 Traffic Counters](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#02-traffic-counters)
    - [04 Google Analytics](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#04-google-analytics)
- [tRS Admin](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#main-content)

    - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#01-getting-started)
    - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#02-how-to-guide)
    - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#03-get-help)
- [tRS Case Studies](https://fundamentals.theretailscore.com/knowledge/trs-case-studies?hsLang=en#main-content)

    - [01 Analysis](https://fundamentals.theretailscore.com/knowledge/trs-case-studies?hsLang=en#01-analysis)
- [tRS Archive Library](https://fundamentals.theretailscore.com/knowledge/trs-archive-library?hsLang=en)
- [tRS Development Release Notes](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes?hsLang=en#main-content)

    - [Releases](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes?hsLang=en#releases)
- [tRS Connect](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#main-content)

    - [01 About](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#01-about)
    - [02 Set Up](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#02-set-up)
    - [03 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#03-getting-started)
- [tRS Planner](https://fundamentals.theretailscore.com/knowledge/trs-planner?hsLang=en)

[![Chill listening crop-3](https://fundamentals.theretailscore.com/hs-fs/hubfs/tRS1-2.png?width=102&height=55&name=tRS1-2.png "Chill listening crop-3")](http://theretailscore.com?hsLang=en)

theretailscore.com Help Center

Copyright © 2026, the Retail Score