Import & Export

Importing your collection into Fannabee

157 views February 22, 2016 July 29, 2016 admin 0

Importing products is useful especially if you switched to Fannabee from another site or you would want to finally showcase inventory in a perfect way.

When importing items, Fannabee does all the hard work for you. Instead of creating each product one at-a-time, Fannabee extracts data from your CSV file and match them into items in your collection.

You need to use a CSV (comma-separated values) file to import your collection from your Excel file.


Please make sure the fields “Catalog Number”, “Matrix Runout”, “Barcode” are formatted like text and not number

Here a sample product CSV file to use this as a template for creating  or adapting your own.

excel


Product CSV file format

It is suggested to have one file for each artist’s collection.
The first line of your product CSV has to include the field headers described below, the most important is the catalog number.

Here’s a description of each field:

Title
The title of your item. Example: La Isla Bonita

Catalog Number
Example: BVCP-751

Make sure this field is formatted like text and not number

Most releases have a catalog number, assigned to them by the record label releasing them. Generally, this number will include alphanumeric characters, often letters followed by numbers, perhaps separated by a dash, space or other punctuation.
It is used for tracking purposes by both the label and the distributor. Catalog numbers are typically printed on the spine of a CD, LP, etc and on the back of record sleeves, but you sometimes you’ll find them in other places on the artwork – and sometimes on the CD and the info label on the record itself.

Barcode
Example: 4988017050057

Make sure this field is formatted like text and not number

Barcodes are numbers used as stock control mechanisms by retailers. They usually appear in the form of a machine-readable series of black and white bars, hence the name “barcode”.

In music releases there are two kind of barcodes:
1) Universal Product Code (UPC), which is the original barcode used in North America. They are 12 digits long, but any number of zeros at the start can be left off, so the actual printed barcode can be shorter than this.
2) European Article Number (EAN) also known as Japanese Article Number (JAN), which is widely used in the rest of the world. The 13 digit type (EAN-13) is the most common, although there are others such as EAN-8. A UPC can be turned into an EAN-13 by adding a leading zero.

Matrix/Run-Out
Example: BVCP-751-1C V

Make sure this field is formatted like text and not number

It’s the information found on the inner rings: the silver area closest to the center hole. It contains mastering engineer / mastering studio / pressing plant information and some other useful info.

Category
Example: Album, Single…

Format
Example: CD, Vinyl…

Country
Example: Portugal

Year
Example: January 27th 1987 or simply the year

PRODUCT IMPORTER APP

  1. Start here by clicking on “START IMPORTING”
  2. import_wid

  3. Drag or Upload your csv file from here
  4. Upload your csv
    Importing

  5. Good! Now start matching your data
  6. Match data

  7. Make sure your CSV contains Barcode or Catalog Number
  8. Catalog Number is Mandatory

  9. Excellent! You’ll be notified when finished
  10. IMPORT 5

  11. Check what’s been matched before importing items into your collection
  12. Account import
    Account import aperta

  13. You can export not matched items in order to add them later manually
  14. Account import ricerca

  15. When you are sure about your collection click on “IMPORT MATCHED” and your collection will build magically!
  16. mycollectino

DO YOU HAVE AN EXISTING COLLECTION ON DISCOGS?

  1. If you are using Discogs to manage your collection, you can import all your items in one click
  2. DISCOGS

  3. Simply login into your Discogs account and then you’ll be redirected to Fannabee while importing your collection
  4. Screenshot 2016-02-22 16.54.12

Was this helpful?