Skip to main content
All CollectionsSales Imports & Mapping
How to Bulk Import Alternate Sale IDs
How to Bulk Import Alternate Sale IDs
Sara avatar
Written by Sara
Updated over a week ago

  1. Download the Release Sale ID Import template from the Templates menu in SR1.

  2. Fill out the template following the Instructions tab. Save and upload the completed template to the Remote Desktop Virtual Drive in SR1.

  3. Navigate to the Sale IDs tab of any Release. Click on Import Sale ID.

  4. Click on Import Sale IDs and select the appropriate file from the Uploads folder of the Remote Desktop Virtual Drive.
    ​

  5. Select your mapping criteria. Click on the yellow arrows to map the new alternate IDs to existing Releases.

    1. If the dot turns green, it has successfully matched to an existing release. If the dot remains red, the mapping criteria provided either matches to multiple Releases (ex: duplicate Catalog Numbers) or does not match to any existing Release.

  6. Click on Create Sale IDs.

  7. Close the Sale ID import window.

  8. Note: These are the required columns in the Release Sale ID Import template.

SR1 Release ID

SR1 will use this data to map the new sale ID to an existing release. If this field is filled out, then Alt Release ID – Catalog No does not need to be filled out.

Alt Release ID

SR1 will use this data to map the new sale ID to an existing release. If this field is filled out instead of SR1 Release ID, a second piece of data is needed to map correctly.

GRID

SR1 will use this data to map the new sale ID to an existing release. If this field is filled out instead of SR1 Release ID, a second piece of data is needed to map correctly.
​

ISRC

SR1 will use this data to map the new sale ID to an existing release. If this field is filled out instead of SR1 Release ID, a second piece of data is needed to map correctly.

Barcode
(UPC/EAN)

SR1 will use this data to map the new sale ID to an existing release. If this field is filled out instead of SR1 Release ID, a second piece of data is needed to map correctly.
​

Catalog No

SR1 will use this data to map the new sale ID to an existing release. If this field is filled out instead of SR1 Release ID, a second piece of data is needed to map correctly.

Map (Y/N)

This field should be filled in with Y.

ID Type

This is where you will designate the type of alternate ID you are importing (Sale ID, UPC, ISRC, GRID, CATALOG).

Sale ID

This is where you will enter the string of characters that make up the new alternate sale ID.

Did this answer your question?