| 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 |