Field

Data Type

Notes

Value Required

Cannot be Null

Can Override Existing Data

Values Will be Ignored

Product Variant Price Identifier

integer

Used as primary key.

X

X

SKU

string

SKU provides a reference that can be used to obtain a PRODUCT_VARIANT_ID.

X

Product Variant Identifier

integer

Will be used as a foreign key.

X

X

Quantity

integer

defaults to 1

X

X

Source Identifier

integer

defaults to 1

X

X

Price

double

X

X

Y

Start Date

datetime

Y

End Date

datetime

Y

Updated Date

datetime

Defaults to the current date.

X

X

Active Flag

string

Value should be either “Y” or “N”.

X

Y

Source Name

string

X

Source Code

string

X

Product Identifier

integer

X

Product Name

string

X

Style

string

X

Color Name

string

X

Size Name

string

X

Site Name

string

X

Workflow Flag

string

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

X

X

Original Price

double

Y