• Home
  • About
  • Best Practices
  • Webinars
  • Resources

ShareASale Blog

  • Twitter
  • Facebook
  • Pinterest
  • Google+
  • LinkedIn
  • ShareASale
  • Industry Insights
  • News & Events
    • Product Updates
  • Merchant Insights
    • Merchant training
  • Affiliate Insights
    • Affiliate training

ALERT: New Datafeed Fields – 9/16

September 9, 2013 by ShareASale 3 Comments

New Datafeed Fields – Mobile URL/Image/Thumbnail

On 9/16 ShareASale will release three new fields to the affiliate product datafeed. These new fields will be in columns 42, 43 and 44, which were previously “Reserved for Future Use”. The three new fields are for mobile optimization:

  • MobileURL: A ShareASale tracking URL that will deliver the end user to the product’s page optimized for mobile.
  • MobileImage: A URL to the product image, optimized for mobile.
  • MobileThumbnail: A URL to the product thumbnail image, optimized for mobile.
The total number of columns in the feed has not changed, so this change should be backward compatible. We are simultaneously releasing these columns to Merchants, so you should not expect to see these fields populated with data on day 1.

The full datafeed specification is below:

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
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 MobileURL URL 255 characters URL to the product’s page, optimized for mobile.
43 MobileImage URL 255 characters URL to the product’s large image, optimized for mobile.
44 MobileThumbnail URL 255 characters URL to the products thumbnail image, optimized for mobile.
45 ReservedForFutureUse – – Reserved for future use.
46 ReservedForFutureUse – – Reserved for future use.
47 ReservedForFutureUse – – Reserved for future use.
48 ReservedForFutureUse – – Reserved for future use.
49 ReservedForFutureUse – – Reserved for future use.
50 ReservedForFutureUse – – Reserved for future use.
51 ReservedForFutureUse – – Reserved for future use.

Filed Under: Industry Insights Tagged With: product datafeeds, technology

ShareASale

ShareASale

Comments

  1. Loyd buhler says

    September 14, 2013 at 12:13 pm

    Working on my site to be view in both desktop and mobile with out having two sites, one for each. Will I be able to use the new code for both or will I have to use desktop and mobile as separate site and listing. The sites at aandlmerchants.com and a-and-l-merchants.com can be used mobile or desktops using 1 address and no redirect to mobile from desktops.

    Reply
  2. Kristina Hughes says

    July 2, 2015 at 12:34 am

    Great overview on the topic indeed! But i have a question there what does mean by direct product url here?? Thumbinal image url?? full image url??

    Reply
    • Brian Littleton says

      August 19, 2015 at 1:46 pm

      If you need specific help on these, feel free to contact us through the “Help” link in your account and we can get back to you.

      Reply

Leave A Comment Cancel reply

Interested in hearing more from ShareASale?

To receive our latest news and email communications, please opt-in to our newsletter below.
* = required field
Tell us about you:



Events Calendar

«February 2023»
SunMonTuesWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
    

Merchant Discovery

Tags

#BestOf #BuildingBlocks #HowTo #LessonsLearned #Q4Prep #TheInterface affiliate affiliate resources affiliate summit affiliate timesavers affiliate tips around the office bfcm2016 black friday blogger tips blogging Brian Littleton client services conferences conference tips content tips cyber monday Featured fun friday general news gift guide gift guides gift guides 2016 interface merchant features merchant focus merchant programs merchant resources merchants merchant timesavers merchant tips month of the interface must have merchants new and notable new merchants product datafeeds q4 reports technology tip of the day

USEFUL LINKS

  • Industry Insights
  • Affiliates Insights
  • Merchants Insights
  • News & Events

RESOURCES

  • About Us
  • Contact Us
  • Resources
  • Best Practices
  • Webinars

Contact Us

SHAREASALE@SHAREASALE.COM
(312) 321-0487

  • Twitter
  • Facebook
  • Pinterest
  • Google+
  • LinkedIn
  • ShareASale