If you are going to import a file via FTP to upload Products into Aimbase, you must follow this file format guide.
Use an excel spreadsheet, but be sure to save it as a .csv file. The field name will be the column headers in your file and below them in each column, you will have a value. For example, PurchaseDt is the Field Name and the Value is below it in YYYYMMDD format.
You can add as many products to one file as you want. Each individual product will be a row.
Once you have completed your file, go to our instructional guide on how to use a FTP software to upload your file successfully.
Field Name | Required | Format | Description |
ACTION | X | “A”, “E” | Specifies the action to be performed on data row:
|
BRAND | Product brand name | ||
PLANTCDE | Alpha-numeric code used for reporting at the plant level | ||
PLANTNME | X | Common name used for the plant reporting at the plant level | |
MFGPCAT | X | Product category information assigned by the manufacturer, if applicable | |
MNAME | X | Common model name | |
MCODE | X | Model code | |
MYEAR | X | YYYY | Model year |
MLENGTH | X | Column head must be present in the document, but the values can be left blank | Two digit number representing the length of the product in feet |
MDESC | X | Column head must be present in the document, but the values can be left blank | The common description of the product |
NMMACAT1 | X | NMMA Product Category | |
NMMACAT2 | X | NMMA Product Segment | |
NMMACAT3 | X | NMMA Product Size |