Field

Data Type

Notes

Value Required

Cannot be Null

Product Variant Identifier

integer

Will be used as a primary key.

Style

string

This provides a reference that can be used to obtain the product ID.  100 characters maximum.

X

X

Product Identifier

integer

Will be used as a foreign key.

SKU

string

255 characters maximum.

X

X

Color Name

string

255 characters maximum.

Size Name

string

255 characters maximum.

Sequence Number

integer

defaults to 0

X

X

Updated Date

datetime

Defaults to the current date.

X

Back-orderable Flag

string

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

Back-order Date

datetime

UPC

string

14 characters maximum.

Inventory Level

integer

Color Code

string

255 characters maximum.

Size Code

string

255 characters maximum.

Taxable Flag

string

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

X

X

Variant Promo Group Code

string

255 characters maximum.

Pricing Group Code

string

255 characters maximum.

Start Date

datetime

End Date

datetime

Active Flag

string

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

X

X

Workflow Flag

string

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

X

Never Out Of Stock Flag

string

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

X

Pre-orderable Flag

string

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

X

Pre-order Date

datetime

Original Price

double

Store Pickup Available Flag

string

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

X

In-store Inventory Level

integer