Products File Format

Field

Data Type

Notes

Value Required

Cannot be Null

Values Will be Ignored

Product identifier

integer

Will be used as a primary key.

X

X

 

Product Type Identifier

integer

 

 

 

 

Product Style

string

100 characters maximum.

X

X

 

Product Name

string

150 characters maximum.

X

X

 

Product Attribute Group Identifier

integer

 

 

 

 

Product Description

string

 

 

 

 

Updated Date

datetime

Defaults to the current date.

 

X

 

Created Date

date

Defaults to the current date.

 

X

 

Active Flag

string

Value should be either “Y” or “N”, defaults to “N”. 1 character maximum.

 

X

 

Image Filename

string

 

 

 

 

Full Path of Image File

string

 

 

 

X

Promo Group Code

string

255 characters maximum.

 

 

 

Start Date

date

 

 

 

 

End Date

date

 

 

 

 

Url Name Override

string

 

 

 

 

Page Title Override

string

 

 

 

 

Meta Description

string

 

 

 

 

Meta Keywords

string

 

 

 

 

Product Keyword

string

 

 

 

 

Site Identifier

integer

 

X

 

 

First Alternate Image Filename

string

 

 

 

 

Second Alternate Image Filename

string

 

 

 

 

Third Alternate Image Filename

string

 

 

 

 

Fourth

Alternate Image Filename

string

 

 

 

 

Fifth Alternate Image Filename

string

 

 

 

 

Sixth Alternate Image Filename

string

 

 

 

 

See also

Category Metadata File Format

Category to Product File Format

Content Metadata File Format

Product Metadata File Format

Product Variant Prices File Format

Product Variants File Format

Store Notifications File Format

Stores File Format