The file's text, extracted by GovTribe without its formatting.
Accompanying this memo is the Catalog_Template.xls Microsoft Excel spreadsheet you need to complete and return to us to load your contract into AdvantageME. The spreadsheet is set up in the exact format necessary to upload it into the system, so it is important that no changes are made to the spreadsheet’s format. Please DO NOT delete any of the optional columns if they will not be used. The following chart provides guidelines to complete the spreadsheet.
| Excel Column |
| Optional/Required |
| Field Type |
| Field Size (in characters) |
| Vendor Customer Code * |
| Optional |
| Alpha Numeric |
| 20 |
| Supplier Part Number ** |
| Required |
| Text |
| 32 |
| Supplier Name (Vendor) |
| Required |
| Alpha Numeric |
| 60 |
| Manufacturer Name |
| Optional |
| Alpha Numeric |
| 25 |
| Manufacturer Part Number |
| Optional |
| Alpha Numeric |
| 25 |
| Commodity Code *** |
| Required |
| Alpha Numeric |
| 5 |
| Item Description |
| Required |
| Alpha Numeric |
| 60 |
| Extended Description |
| Required |
| Alpha Numeric |
| 1500 |
| Unit of Measure **** |
| Required |
| Alpha Numeric |
| 4 |
| List Price |
| Required |
| Number |
| 14 before and 6 after decimal pt |
| Deliver Days |
| Required |
| Number |
| 10 |
| Product / Category |
| Optional |
| Alpha Numeric |
| 25 |
| Model |
| Optional |
| Alpha Numeric |
| 25 |
| Drawing |
| Optional |
| Alpha Numeric |
| 25 |
| Piece |
| Optional |
| Alpha Numeric |
| 25 |
| Serial Number |
| Optional |
| Alpha Numeric |
| 25 |
| Specifications |
| Optional |
| Alpha Numeric |
| 25 |
| Size |
| Optional |
| Alpha Numeric |
| 25 |
| Color |
| Optional |
| Alpha Numeric |
| 25 |
| Picture File Name ***** |
| Optional |
| Alpha Numeric |
| 255 |
If you leave blank, State of Maine Buyer will complete this column
Format as text, even if the Supplier Part Number contains only numbers – each supplier part number must be unique – no duplicates.
See NIGP Codes (5-digit) at: http://www.maine.gov/purchases/vendorinfo/vss.htm
(Note: Use 3-digit Class plus 2-digit Item to equal 5-digit Code.)
Select Units from the attached Unit_of_Measure.xls file Add picture file name only if you have images for the contract