| Column |
Type |
Data required |
Description |
Example |
| Act |
String |
Yes |
Type of import action to perform (Insert = i, Update = u, Delete = d) |
i |
| ProductAttributeID |
Integer |
Yes/No |
Database object identifier. This value must be specified when performing an update or delete action. |
9 |
| BooleanValue |
Boolean |
No |
Boolean type value. If you specify a value here, you must not specify the DecimalValue, IntegerValue, SelectionValue or StringValue. |
True |
| CreateDate |
DateTime |
No |
|
|
| DecimalValue |
Decimal |
No |
Decimal type value. If you specify a value here, you must not specify the BooleanValue, IntegerValue, SelectionValue or StringValue. |
1.2 |
| IntegerValue |
Integer |
No |
Integer type value. If you specify a value here, you must not specify the BooleanValue, DecimalValue, SelectionValue or StringValue. |
2 |
| ProductAttributeDefinitionID |
Integer |
Yes/No |
Associate this attribute to the Product Attribute Definition by its ProductAttributeDefinitionID. If you specify ProductAttributeDefinitionID, the ProductAttributeDefinitionKey will be ignored. |
1 |
| ProductAttributeDefinitionKey |
String |
Yes/No |
Associate this attribute to the Product Attribute Definition by its ProductAttributeDefinitionKey. If you specify ProductAttributeDefinitionID, the ProductAttributeDefinitionKey will be ignored. |
|
| ProductID |
Integer |
Yes/No |
Associate this attribute to the product by its ProductID. If you specify ProductID, the ProductKey will be ignored. If you specify the ProductID, you must not specify the ProductVariantID or ProductVariantKey. |
12 |
| ProductKey |
String |
Yes/No |
Associate this attribute to the product by its ProductKey. If you specify ProductID, the ProductKey will be ignored. If you specify the ProductID, you must not specify the ProductVariantID or ProductVariantKey. |
apple |
| ProductVariantID |
Integer |
Yes/No |
Associate this attribute to the product variant by its ProductVariantID. If you specify ProductVariantID, the ProductVariantKey will be ignored. If you specify the ProductVariantID, you must not specify the ProductID. |
14 |
| ProductVariantKey |
String |
Yes/No |
Associate this attribute to the product variant by its ProductVariantKey. If you specify ProductVariantID, the ProductVariantKey will be ignored. If you specify the ProductVariantID, you must not specify the ProductID. |
apple-ipad-white |
| SelectionValue |
String |
No |
Pipe delimited list of integer selection values. Value must correspond to the possible ProductAttributeDefinitionSelectionID values. If you specify a value here, you must not specify the BooleanValue, DecimalValue, IntegerValue or StringValue. |
12|32|1 |
| StringValue |
String |
No |
Localized string type value. If you specify a value here, you must not specify the BooleanValue, DecimalValue, IntegerValue or SelectionValue. |
|
| UpdateDate |
DateTime |
No |
|
|