Support Center » Knowledgebase » What is the column order in the Datafeed?
 What is the column order in the Datafeed?
Solution The column order of the Datafeed is as follows:

ProductID|Name|MerchantID|Merchant|Link|Thumbnail|BigImage|Price|RetailPrice|Category|SubCategory|Description|Custom1|Custom2|Custom3|Custom4|Custom5|LastUpdated|status|manufacturer|partnumber|merchantCategory|merchantSubcategory|shortDescription|ISBN|UPC|SKU|CrossSell|MerchantGroup|MerchantSubgroup|CompatibleWith|CompareTo|QuantityDiscount|Bestseller|AddToCartURL|ReviewsRSSURL|Option1|Option2|Option3|Option4|Option5|mobileURL|mobileImage|mobileThumbnail|||||||

Detailed Specification:

Column OrderDataData TypeMax LengthDescription
1ProductIDInteger8 bytesShareASale generated ID for use in conjunction with our online tools. Should not be used as a primary key.
2NameText255 charactersProduct Name
3MerchantIDInteger8 bytesMerchantID number
4MerchantText255 charactersMerchant Name
5LinkURL255 charactersURL to the product's page
6ThumbnailURL255 charactersURL to the products thumbnail image
7BigImageURL255 charactersURL to the product's large image
8PriceNumeric2 decimal placesProduct price
9RetailPriceNumeric2 decimal placesProduct full retail price (or MSRP)
10CategoryText50 charactersShareASale defined Category
11SubcategoryText50 charactersShareASale defined Subcategory
12DescriptionTextNo character limitProduct Description (HTML allowed)
13Custom1Text255 charactersMerchant Defined Data
14Custom2Text255 charactersMerchant Defined Data
15Custom3Text255 charactersMerchant Defined Data
16Custom4Text255 charactersMerchant Defined Data
17Custom5Text255 charactersMerchant Defined Data
18LastupdatedDateTimeN/ALast updated date
19StatusText50 charactersStock Status. instock refers to product in stock
20ManufacturerText255 charactersProduct Manufacturer
21PartNumberText255 charactersManufacture's part number
22MerchantCategoryText255 charactersMerchant defined category
23MerchantSubcategoryText255 charactersMerchant defined subcategory
24ShortDescriptionText255 charactersShort description (no HTML)
25ISBNText25 charactersProduct ISBN number
26UPCText25 charactersProduct UPC
27SKUText255 charactersMerchant SKU for this product. This is a unique value, and can be used to generate a primary key.
28CrossSellText255 charactersComma separated list of SKU values that cross sell with the product.
29MerchantGroupText255 characters3rd level category (sub subcategory) for the product
30MerchantSubgroupText255 characters4th level cateogy (sub sub subcategory) for the product.
31CompatibleWithText255 charactersComma separated list of compatible items in format of Manufacturer~PartNumber.
32CompareToText255 charactersComma separated list of items this product can replace in format of Manufacturer~PartNumber.
33QuantityDiscountText255 charactersComma separated list in the format of minQuantity~maxQuantity~itemCost. Blank Max Quantity represents a top tier.
34BestsellerBit1A 1 indicates a best selling product. Null values or zero are non-bestsellers.
35AddToCartURLURL255 charactersURL that adds this product directly into the shopping cart.
36ReviewsRSSURLURL255 charactersURL to RSS formatted reviews for this product.
37Option1Text255 charactersComma separated list of product options in the format optionName~priceChangeInDollarsPerUnit.
38Option2Text255 charactersComma separated list of product options in the format optionName~priceChangeInDollarsPerUnit.
39Option3Text255 charactersComma separated list of product options in the format optionName~priceChangeInDollarsPerUnit.
40Option4Text255 charactersComma separated list of product options in the format optionName~priceChangeInDollarsPerUnit.
41Option5Text255 charactersComma separated list of product options in the format optionName~priceChangeInDollarsPerUnit.
42MobileURLURL255 charactersURL to the product's page, optimized for mobile.
43MobileImageURL255 charactersURL to the product's large image, optimized for mobile.
44MobileThumbnailURL255 charactersURL to the products thumbnail image, optimized for mobile.
45ReservedForFutureUse--Reserved for future use.
46ReservedForFutureUse--Reserved for future use.
47ReservedForFutureUse--Reserved for future use.
48ReservedForFutureUse--Reserved for future use.
49ReservedForFutureUse--Reserved for future use.
50ReservedForFutureUse--Reserved for future use.
51ReservedForFutureUse--Reserved for future use.


Article Details
Article ID: 39
Created On: 07 Aug 2006 03:59 PM

 This answer was helpful  This answer was not helpful

 Back
 Search
 Article Options
Home | Knowledgebase | Downloads  

ShareASale Help Center