Product File Format

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:
  • A=New
  • E=End Record (designates the end of file)
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