Standard Product File Format

Note: Use this documentation if your products are not part of the NMMA program. If you are participating in the NMMA install, refer to the NMMA Product File Format documentation instead.

File Format:

The imported file must be in CSV format.
Each column header represents a field name, and each row contains values for a product.

Example Formatting:

In this example, "ACTION" is the field name, and "A" (Add) is its corresponding value, following the format specifications in this documentation.

Adding Products:

You can include multiple products in one file. Each product should be on a separate row.

Uploading Your File:

Once your file is complete, refer to our FTP upload guide for step-by-step instructions on how to upload your file successfully.

Field Name	Required	Format	Length	Description
ACTION	X	“A”, “E”	1	Specifies the action to be performed on the data row: A = Add (Use for new records) D = Delete (Use to deactivate a record)
BRAND	X	string	128	Brand Code
PLANTCDE		string	6	Plant Code
PLANTNME		string	50	Plant Name
MNAME	X	string	80	Product Name
MCODE	X	string	50	Product Code
MYEAR	X	number	0-3000	Model Year
CAT1		string	48	Product Category Code Level 1 (Category) * Required if Level 2 (CAT2) is included.
CAT2		string	48	Product Category Code Level 2 (Segment) * Required if Level 3 (CAT3) is included.
CAT3		string	48	Product Category Code Level 3 (Length)
SKUCODE		string	50	SKU Code
PTYPENME		string	50	Product Type Name
APPCONTEXT		string	20	Application Context Code (B -Both, O - Owners Only, S - Sales Only, N - Neither)

Rollick Knowledge

Related Articles