Master List

Open your template file and go to the sheet/tab labeled 'MasterList'. Each row in this sheet will correspond to exactly one unique product. You will need to enter the following information for each product:

Excel Column Description Required Example
SupplierId GLN/NAMM partner ID X 1234567890123
SupplierItemId Supplier product identifier X EXL110
SupplierModel Supplier model identifier X EXL110
SupplierItemDesc Supplier item description X D'Addario EXL110 Nickel Wound Electric Guitar Strings, Regular Light, 10-46
Kit Item SKU made up of other SKUs. Y=Yes, N=No X N
Serialized Item has a serial number. Y=Yes, N=No X Y
BrandName Item brand name X D'Addario
CountryOrigin Country of origin. See ISO country code.   US
Length External item length X 5.00
Width External item width X 5.00
Height External item height X 0.25
DimUOM Dimension unit of measure X INCH
Weight Item weight X 0.25
WeightUOM Weight unit of measure X LB, KG
AnnounceDate Item announcement date. Format mm/dd/yyyy X 5/1/2001
AvailableDate Item availability date. Format mm/dd/yyyy X 5/1/2001
UnavailableDate Item unavailability date. Format mm/dd/yyyy    
EndOfProductionDate Item end of production date. Format mm/dd/yyyy    
ReplacementID Item replacement ID    
WarrantyPartTerm Parts warranty term (length) X 1
WarrantyPartUOM Parts warranty unit of measure X Year
WarrantyLabTerm Labor warranty term (length) X 1
WarrantyLabUOM Labor warranty unit of measure X Year
Condition Item condition   New
BarcodeID     019954141271
BarcodeType     GTIN-12

Special Notes:

  • Prefix all BarcodeID's with ' (single quote) to avoid Excel's automatic conversion to scientific notation as well as dropping leading zero. A single quote is removed during the conversion process.
  • Common types of barcodes:
    UPC (GTIN-12) code is 12 characters long. Valid for USA and Canada.
    EAN (GTIN-13) code is 13 character long. Valid in Europe, Asia, Australia, USA, Canada.