Updating Assets Identifiers in Bulk
Overview
The "Asset Identifiers Bulk Updater" spreadsheet allows you to add, update, or delete identifiers on Albums, Tracks, Videos, and Works in bulk. Each row targets one identifier on one asset.
Warning: Leaving the "Asset Identifier Value" column empty on a row will delete the corresponding identifier from the asset. This action cannot be undone from the spreadsheet. Verify your data carefully before importing.
Where to Find the Template
The official template is available in Reprtoir's public template library under the name:
Other - Asset Identifiers Bulk Updater - Template (Reprtoir Public)
Important: Copy the template to your own Google Drive before starting by opening it and selecting "File > Make a Copy". Downloading the file locally will remove dynamic helpers such as dropdown menus and data validation. Do not reuse a copy from a previous import without verifying that the column structure is still current.
Spreadsheet Structure
The template contains three tabs.
| Tab | Purpose |
|---|---|
| Instructions | General information and guidance on using the template. |
| Assets Identifiers | The data entry tab. Each row represents one identifier to add, update, or delete on an asset. |
| Items | Reference lists used by the dropdown menus in the data entry tab. Do not modify this tab. |
All data must be entered in the "Assets Identifiers" tab only.
Columns
The "Assets Identifiers" tab contains five columns. Columns marked with an asterisk (*) are mandatory.
| Column | Name | Required | Description |
|---|---|---|---|
| A | Asset Type (*) | Yes | The type of asset to update. Select a value from the dropdown. |
| B | Asset Name | No | The name of the asset. Used for reference only and has no effect on the import. |
| C | Asset Reprtoir Identifier (*) | Yes | The Reprtoir Identifier (UUID) of the asset. Must match an existing asset in Reprtoir exactly. |
| D | Asset Identifier Name (*) | Yes | The type of identifier to add, update, or delete. Select a value from the dropdown. |
| E | Asset Identifier Value | No | The value of the identifier. Leave empty to delete the identifier from the asset. |
Getting the Reprtoir Identifiers
The "Asset Reprtoir Identifier" column requires the UUID assigned by Reprtoir to each asset. This value is not entered manually but exported from the workspace.
- Open the asset list you want to update (Albums, Tracks, Videos, or Works) in the left navigation menu under "Catalog Management".
- Select the assets you want to process.
- Export the list and retrieve the "Reprtoir Identifier" column.
- Paste the values into the "Asset Reprtoir Identifier" column of the spreadsheet.
Asset Types and Accepted Identifiers
The "Asset Type" column accepts the following values: Album, Track, Video, and Work.
The "Asset Identifier Name" column accepts different values depending on the asset type declared on the same row.
Albums
| Accepted Identifiers |
|---|
| UPC |
| Custom Album Identifier |
| Bandcamp Catalog Number |
| Clearspot Article Nr |
| Countdown Catalog Number |
| Discogs Release ID |
| Goodfellas Article ID |
| Heathen Natives Code |
| K7 Code |
| Kuroneko Code |
| L'autre Distribution Ref Producteur |
| Lionfish Music Catalog Number |
| Matrix Nr Cat |
| Not Now Music Catalog Number |
| Outre National Code |
| OVC Media Catalog Number |
| Perennial Catalog Number |
| Plaza Mayor Catalog Number |
| Pusher Code |
| RMP Global Catalog Number |
| RoyaltyShare Catalog Number |
| Rush Hour Cat |
| Shopify SKU |
| Shopify Variant ID |
| SUISA Code |
| Timeless Music Catalog Number |
| Tsunami Code |
| Warner Catalog Number |
Tracks
| Accepted Identifiers |
|---|
| ISRC |
| Custom Track Identifier |
| Connect Music Licensing Code |
| Crimson Music Code |
| ECAD Code |
| IPF Code |
| ISWC Code |
| Shopify SKU |
| Shopify Variant ID |
| Soundsnap / Beatopia NID |
| Warner Code |
| YouTube Asset ID |
Videos
| Accepted Identifiers |
|---|
| ISRC |
| Custom Video Identifier |
| YouTube Asset ID |
| YouTube ID |
Works
| Accepted Identifiers |
|---|
| ISWC |
| Custom Work Identifier |
| ABRAMUS Code |
| ABRAMUS Digital Code |
| ACAM Code |
| AdRev Code |
| AKM Code |
| AMRA Code |
| ASCAP Code |
| Audiam Asset ID |
| BackOffice Code |
| Balada ID |
| BMG Code |
| BMI Code |
| Bucks Music Song Code |
| BUMA Code |
| CCLI Creation ID |
| CMC Code |
| CMC RSN Code |
| CMRRA Work Number |
| ECAD Code |
| Freibank Song Code |
| Fujipacific Music Song Code |
| Gaga Code |
| Harry Fox Agency Code |
| HCM Code |
| ICE Services Code |
| ISRC Code |
| Kobalt Code |
| Luna Negra ID |
| Mayfair Code |
| MLC Code |
| Music Maestro Code |
| Music Reports Song ID |
| Musixmatch Identifier |
| OMSA Work Number |
| ONErpm Code |
| Praise Charts ID |
| PRS/MCPS Code |
| Regalias ID |
| SABAM Code |
| SACEM Code |
| SACM Code |
| SAZAS MWID Code |
| Secretly Publishing Code |
| Sentric Code |
| SESAC Code |
| SGAE Code |
| SIAE Code |
| SOCAN Code |
| SOCINPRO Code |
| Songtrust Code |
| Sony Song No. |
| SPA Code |
| SUISA Code |
| The Orchard Publishing Song ID |
| TuneCode SongCode |
| UMPG Code |
| Unison Work Number |
| Warner Chappell Code |
| Word Collections Code |
| YouTube Asset ID |
Add, Update, or Delete Logic
The "Asset Identifier Value" column controls whether the import adds, updates, or deletes the identifier on the asset.
| Asset Identifier Value | Result |
|---|---|
| Filled | The identifier is added if it does not exist, or updated if it already exists. |
| Empty | The identifier is deleted from the asset. |
Warning: This spreadsheet allows empty values in the "Asset Identifier Value" column. In such a case, the identifier of the asset would be erased.
Preparing the File
- Open the "Other - Asset Identifiers Bulk Updater - Template (Reprtoir Public)" and select "File > Make a Copy" to save it to your own Google Drive.
- Export the Reprtoir Identifiers of the assets you want to update from the relevant list in the workspace.
- Open the "Assets Identifiers" tab in the template.
- For each row, select an "Asset Type" from the dropdown.
- Optionally fill in the "Asset Name" column for reference.
- Paste the corresponding "Asset Reprtoir Identifier" value.
- Select the "Asset Identifier Name" from the dropdown. Verify that it is valid for the declared asset type.
- Enter the identifier value in the "Asset Identifier Value" column, or leave it empty to delete the identifier.
Exporting the File
Before importing into Reprtoir, export only the "Assets Identifiers" tab as a CSV file. Importing the full Google Sheets file is not supported.
- Open the "Assets Identifiers" tab in your Google Sheet.
- Click "File" in the top menu.
- Hover over "Download".
- Select "Comma Separated Values (.csv)".
The exported file will contain only the active tab. Do not rename the file before importing.
Importing the File
- Click "Catalog Management" in the left navigation menu.
- Click "Spreadsheet Importer".
- Click "New Spreadsheet" and select "Assets - Identifiers Update".
- Upload the exported CSV file.
- Start the process.
- Review the results. If errors are reported, correct the file and upload it again from step 4.
- If no errors are reported, the import is complete. Open the affected assets in the workspace to verify the changes.
Error Reference
| Error | Description |
|---|---|
| Invalid Asset Type | The value in "Asset Type" is not one of the accepted types: Album, Track, Video, Work. |
| Could not find asset of type [type] with Reprtoir Identifier | No asset of the declared type matches the provided Reprtoir Identifier. Verify that the UUID is correct and that the asset type matches. |
| Invalid Identifier Type for asset of type [type] | The identifier selected in "Asset Identifier Name" is not valid for the declared asset type. |
| Invalid identifier format for [identifier type] | The value provided in "Asset Identifier Value" does not match the expected format for that identifier type (for example, an ISRC with an incorrect structure). |
Limitations
- The "Asset Reprtoir Identifier" must be exported from the workspace. It cannot be constructed manually.
- Each row targets a single identifier on a single asset. To update multiple identifiers on the same asset, add one row per identifier.
- Leaving "Asset Identifier Value" empty permanently deletes the identifier from the asset.
- The identifier name must be valid for the declared asset type. Using an incompatible identifier will cause an import error on that row.
- The template must be used as a Google Sheet. Exporting as Excel (.xlsx) is not officially supported and may cause compatibility issues.
Updated about 2 hours ago