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.
- Printer-friendly version
- Log in or register to post comments