1- Make the request to the person responsible for this task in the following order: Remy.G, Adrien, someone in production, or yourself, if you have the rights.
2- Open the file List barcode Season of Mist (for SOM-SUA).xlsx in OneDrive – SEASON OF MIST\Production\Price codes – Boxes
3- Select the first barcode from the top that has not yet been allocated (which has #N/A in column B (Catalog #)).
4- Write the following format for this barcode [Catalog] – [Band] – [Title] – [Format].
5- Update the following files:
-> ISRC.xlsx (OneDrive – SEASON OF MIST\Mastering\Mastering)
-> Price Codes.xlsx (OneDrive – SEASON OF MIST\Production\Price Codes – Boxes)
6- Here you go!
Notes and explanations:
This file is not designed to be consulted or read, it is just there to obtain a barcode, nothing more.
Previously, the barcodes allocated to items had to have the master reference for the item in question, but this technique had the disadvantage of drastically reducing the number of available barcodes and making certain ranges inaccessible. It was therefore decided to stop using this method and to use the first available barcode.
To do this, Gilles and Remy G extracted (last update: 10/08/203) the barcodes that were already in use from the following sources:
– Interface SW (Barcode SW sheet)
– Interface CT (Barcode CT sheet)
– Product Index.xlsx
– ISRC.xlsx
– Price Code.xlsx
– The Orchard (website)
All barcodes have been added to the User barcode – old sys tab or duplicates have been removed. This sheet is the USEDBARCODE matrix which is used in the formula to determine whether the barcode is already in use.
If the Barcode tab is filled in correctly for each barcode request, there should be no need to update the various sheets.
For more information, please contact Remy.G