Column |
Type |
Data required |
Description |
Example |
Act |
String |
Yes |
Type of import action to perform (Insert = i, Update = u, Delete = d) |
u |
ProductID |
Integer |
Yes/No |
Database object identifier.This value is required when performing an update or delete action if the ProductKey is not provided. |
12 |
ProductKey |
String |
Yes/No |
A unique key that can be used to uniquely identify this object. This could be a short meaningful text or simply a GUID. If you don't specify a value, the system will generate a unique key for you during insertion. This key can be used to lookup the object if the ProductID is not specified. |
apple-ipad |
AllowInternetOrder |
Boolean |
Yes |
Allow purchase online. |
True |
AllowPhoneOrder |
Boolean |
Yes |
Allow phone order. |
False |
AllowProductReview |
Boolean |
Yes |
Allow customers to post reviews and ratings. |
True |
AllowSalesChannel |
Boolean |
Yes |
Allow automatic publishing of product to configured sales channels (e.g. Facebook). |
True |
AvailabilityRule |
XML Rule |
No |
The rule to describe the conditions when the product can be purchased. |
|
BuyingGuide |
String |
No |
Buying guide text. |
|
BuyingGuideName |
String |
No |
Override default name for the buying guide description. |
|
CreateDate |
DateTime |
No |
|
|
DisplayOrder |
Integer |
Yes |
Product sort order from smallest to largest number. |
1000 |
DisplayTemplate |
String |
No |
Custom display template name. |
Custom12 |
DynamicFormCode |
XML Code |
No |
Custom HTML or input form elements. |
|
Extension |
XML |
No |
Extra data in XML string. |
<data><misc>True</misc></data> |
ExternalID |
String |
No |
Used to track data that may be sourced from an external system. |
|
FAQ |
String |
No |
FAQ text. |
|
FAQName |
String |
No |
Override default name for the FAQ description. |
|
Featured |
Boolean |
Yes |
Indicate if product is “featured” and should be displayed on product list module control even if no category is selected. |
False |
MetaDescription |
String |
No |
Meta description. |
Popular mechanics |
MetaKeywords |
String |
No |
Meta keywords. |
mechanics, engineers |
Name |
String |
Yes |
Product name. |
Popular Mechanics |
Overview |
String |
No |
Overview text. |
|
OverviewName |
String |
No |
Override default name for the overview description. |
|
PageTitle |
String |
No |
Page title. |
Popular books |
ProductDetailUrl |
String |
No |
Specify a custom product detail page for this product or set to empty or null to use the default product detail page. Enter a valid Tab ID number for the page. |
|
ProductType |
Integer |
Yes |
Regular = 1 |
1 |
Published |
Boolean |
Yes |
Enable display of the product. |
True |
RedirectUrl |
String |
No |
Redirect product detail page to URL location. Useful for maintaining SEO value for a discontinued product. |
|
SellerID |
Integer |
No |
Associate this product to a valid seller ID. |
3 |
SellerKey |
String |
Yes/No |
Reference the corresponding seller by its SellerKey. If you specify SellerID, the SellerKey will be ignored. |
microsoft |
ShowAddToCart |
Boolean |
Yes |
|
True |
ShowAddToWishList |
Boolean |
Yes |
|
True |
ShowBuyNow |
Boolean |
Yes |
|
True |
ShowInventory |
Boolean |
Yes |
|
True |
ShowMSRP |
Boolean |
Yes |
|
True |
ShowPrice |
Boolean |
Yes |
|
True |
ShowQuantity |
Boolean |
Yes |
|
True |
ShowRewardPoints |
Boolean |
Yes |
|
True |
ShowSavings |
Boolean |
Yes |
|
True |
ShowSeeDetails |
Boolean |
Yes |
|
True |
ShowSKU |
Boolean |
Yes |
|
True |
ShowSocialShare |
Boolean |
Yes |
|
True |
ShowUpdate |
Boolean |
Yes |
|
True |
Specifications |
String |
No |
Specifications text. |
|
SpecificationsName |
String |
No |
Override default name for the specifications description. |
|
StartDate |
DateTime |
No |
When to start publishing product. |
2010-10-15 |
StopDate |
DateTime |
No |
When to stop publishing product. |
2012-01-18 |
Summary |
String |
No |
Summary text. |
|
Terms |
String |
No |
Terms text. |
|
TermsName |
String |
No |
Override default name for the terms description. |
|
UpdateDate |
DateTime |
No |
|
|
UrlName |
String |
No |
Name to appear in URL for SEO purposes. |
Popular mechanics magazine |