--- title: How to maintain your external upload files in tRS? description: This article outlines the steps and upload process to keep your "external upload files" up to date. --- [Skip to content](https://fundamentals.theretailscore.com/knowledge/how-to-maintain-your-external-upload-files-in-trs#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 Admin](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en) 3. [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#02-how-to-guide) # How to maintain your external upload files in tRS? ## This article outlines the steps and upload process to keep your "external upload files" up to date. ### Background Whilst the majority of data is sourced from your ERP or other systems via API's, there are many examples where data is stored in flat files or excel spreadsheets that need to be integrated into your data warehouse.  Below are some of these examples: - Board Budgets, Sales Targets and Forecasts - Location attributes such as floor size by store or area manager store lists - Product attributes such as aggregating seasons into Next, Current and Past Seasons - General Ledger Account Master or Cost Centre Files - Like for like input file containing "is open" flags by location by week - Image URL mapping files to style colour codes **Please note:** - This article is relevant to all of the above but please note the pre-requisites before you begin. - Upon successful upload of a file, it will be brought into your Cube the next morning alongside the 'Master Load Refresh' ### Pre requisites - You must have access to your tRS insights portal with admin access - tRS will need to grant you admin access to the "wrench" icon in the right of the top ribbon - The upload template must first be set up by tRS for you Please contact tRS at support@theretailscore.com if you do not meet these requirements. ### The Steps Follow these steps to keep your external upload files up-to-date 1\. Log into your tRS **[Insights Portal](https://portal.theretailscore.com/login).** 2\.Navigate to the wrench icon, in the Portal Banner ![](https://fundamentals.theretailscore.com/hubfs/image-png-Nov-09-2021-03-03-31-47-AM.png) 3\. Navigate to the **Data Uploads** and relevant file  ![](https://fundamentals.theretailscore.com/hs-fs/hubfs/image-png-Nov-09-2021-03-04-03-79-AM.png?width=547&name=image-png-Nov-09-2021-03-04-03-79-AM.png) (This page will have all current files that are available for you to upload – If an upload you expect to have does not exist email support@theretailscore.com) ### Uploading Document Files ![](https://fundamentals.theretailscore.com/hubfs/image-png-Nov-09-2021-03-06-20-32-AM.png) 1\. Click on the vertical three dots and **download the last successful upload** 2\. Save the file for backup just in case you need to refer to it again 3\. Add or update the file as you need too **Warning:** Do not add or insert columns into the sheet and follow the instructions above the columns  4\. Save As a new file name  5\. Go back to the Admin portal and click on the three vertical dots and select **upload file** 6\. The Status will update immediately, showing **Completed.** 7\. Follow the steps if an error during upload occurs or contact support@theretailscore.com **Tip:**  If the file is unsuccessful, an error log is created that can be accessed by clicking on the icon containing the number of errors.  This will guide you to the cells that need your attention. Opening the file and reviewing the last column of the upload file will also record the errors by row in the workbook. **Warning:** Do not leave the upload file in a state of error as this may impact the daily refresh of your data.  If you do not have time to fix this, simply click on the three dots to the right of the file and clear the failed upload and re-upload the backup file you saved. If in doubt, please contact us at  **support@theretailscore.com**   - [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