ShareASale the column order in the Datafeed?

ข้อมูล Datafeed ของ ShareASale เก็บไว้อ้างอิงสำหรับสร้าง script import สินค้าเข้า PrestaShop

 

Detailed Specification:

Column Order Data Data Type Max Length Description
1 ProductID Integer 8 bytes ShareASale generated ID for use in conjunction with our online tools. Should not be used as a primary key.
2 Name Text 255 characters Product Name
3 MerchantID Integer 8 bytes MerchantID number
4 Merchant Text 255 characters Merchant Name
5 Link URL 255 characters URL to the product’s page
6 Thumbnail URL 255 characters URL to the products thumbnail image
7 BigImage URL 255 characters URL to the product’s large image
8 Price Numeric 2 decimal places Product price
9 RetailPrice Numeric 2 decimal places Product full retail price (or MSRP)
10 Category Text 50 characters ShareASale defined Category
11 Subcategory Text 50 characters ShareASale defined Subcategory
12 Description Text No character limit Product Description (HTML allowed)
13 Custom1 Text 255 characters Merchant Defined Data
14 Custom2 Text 255 characters Merchant Defined Data
15 Custom3 Text 255 characters Merchant Defined Data
16 Custom4 Text 255 characters Merchant Defined Data
17 Custom5 Text 255 characters Merchant Defined Data
18 Lastupdated DateTime N/A Last updated date
19 Status Text 50 characters Stock Status. instock refers to product in stock
20 Manufacturer Text 255 characters Product Manufacturer
21 PartNumber Text 255 characters Manufacture’s part number
22 MerchantCategory Text 255 characters Merchant defined category
23 MerchantSubcategory Text 255 characters Merchant defined subcategory
24 ShortDescription Text 255 characters Short description (no HTML)
25 ISBN Text 25 characters Product ISBN number
26 UPC Text 25 characters Product UPC
The following columns will be added on August 1st, 2009
27 SKU Text 255 characters Merchant SKU for this product. This is a unique value, and can be used to generate a primary key.
28 CrossSell Text 255 characters Comma separated list of SKU values that cross sell with the product.
29 MerchantGroup Text 255 characters 3rd level category (sub subcategory) for the product
30 MerchantSubgroup Text 255 characters 4th level cateogy (sub sub subcategory) for the product.
31 CompatibleWith Text 255 characters Comma separated list of compatible items in format of Manufacturer~PartNumber.
32 CompareTo Text 255 characters Comma separated list of items this product can replace in format of Manufacturer~PartNumber.
33 QuantityDiscount Text 255 characters Comma separated list in the format of minQuantity~maxQuantity~itemCost. Blank Max Quantity represents a top tier.
34 Bestseller Bit 1 A 1 indicates a best selling product. Null values or zero are non-bestsellers.
35 AddToCartURL URL 255 characters URL that adds this product directly into the shopping cart.
36 ReviewsRSSURL URL 255 characters URL to RSS formatted reviews for this product.
37 Option1 Text 255 characters Comma separated list of product options in the format optionName~priceChangeInDollarsPerUnit.
38 Option2 Text 255 characters Comma separated list of product options in the format optionName~priceChangeInDollarsPerUnit.
39 Option3 Text 255 characters Comma separated list of product options in the format optionName~priceChangeInDollarsPerUnit.
40 Option4 Text 255 characters Comma separated list of product options in the format optionName~priceChangeInDollarsPerUnit.
41 Option5 Text 255 characters Comma separated list of product options in the format optionName~priceChangeInDollarsPerUnit.
42 Reserved - - Reserved for future use.
43 Reserved - - Reserved for future use.
44 Reserved - - Reserved for future use.
45 Reserved - - Reserved for future use.
46 Reserved - - Reserved for future use.
47 Reserved - - Reserved for future use.
48 Reserved - - Reserved for future use.
49 Reserved - - Reserved for future use.
50 Reserved - - Reserved for future use.
51 Reserved - - Reserved for future use.

Leave a Reply

Your email address will not be published. Required fields are marked *

CAPTCHA Image

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>