Internet Marketing and Web Development Resources
Home Site Map About Contact

ShareASale Product Datafeeds for Affiliates and Merchants



Table of Contents


ShareASale Product Datafeed for Affiliates


Return to Network Specific Implementation Guides and Documentations or to Affiliate Datafeeds Resources.

ShareASale is an affiliate network in the United States for small to medium size advertisers. ShareASale is the only network in the United States that does not allow affiliates to utilize desktop software to promote advertiser offers (such as browser toolbars and similar tools). ShareASale provides product data feeds via FTP to affiliates free of charge, but the advertiser has to enable feed access to affiliates manually and pay a nominal $1 activation fee per affiliate (one-time fee). The product data feed provided by ShareASale has the following format and structure:

Format: Delimited
Column Delimiter: Pipe/Vertical Bar
Row Delimited: CR + LF (Windows Line Break)
Text Qualifier: None

Header Row with Column Definition:
ProductID|Name|MerchantID|Merchant|Link|Thumbnail|BigImage|Price|RetailPrice|Category|SubCategory|
Description|Custom1|Custom2|Custom3|Custom4|Custom5|LastUpdated|status

Notes:
The Information for a product will be in a single line. The Line break in the example was only added for display purposes. The Download via Web Interface has the Header Row included and the (your) Affiliate ID is already encoded in the Link. The Feeds via FTP do not have the Header Row. Also the Links require the replacement of the string: YOURUSERID with the (your) ShareASale Affiliate ID.

To learn about the meaning of the columns in the feed, have a look at the Feed Definition for Merchants below.
It is very similar to the feed provided to Affiliates, because it is basically the basis for the Affiliate Datafeed.

There are three ways to access datafeeds through ShareASale.com.
1. File Download via the ShareASale.com Website
2. FTP Download via the ShareASale FTP Server
3. Real Time XML feed for Premier Affiliates

Flat File Download


Datafeed flies can be downloaded in a pipe separated format (|) from the ShareASale website.
Click the "Datafeeds Available" page to download files.

FTP Datafeeds


Datafeeds are available from the ShaerASale.com FTP server. You will need approval from each merchant partner to access the datafeed via FTP. The FTP server is at:

Address: datafeeds.shareasale.com
Port: 21
Username: Your ShareASale Username
Password: Your ShareASale Password

You can request access from the Datafeeds Available page and view your current approvals from the FTP Access for Datafeeds page.

You have to apply for FTP Access for each Merchant individually. Each activation (per Affiliate Account) cost the Merchant $1. Tip: If you apply for Feed access via FTP, explain why you need it and what you want to do with it. It helps to get approved.

Download Automation and DB Import


Downloading and processing datafeeds is a pain that can be automated.

Check out the free PHP and MySQL database automation script by Shawn "mobilebadboy" Kerr to ftp download feeds and import them into MySQL automatically on a frequent basis.

- top -

ShareASale Product Datafeed for Merchants


Return to Network Specific Implementation Guides and Documentations or to Affiliate Datafeeds Resources.
You have the option to maintain Products manually via the Web Interface by default.

Please contact ShareASale via Email to enable automatic/sheduled uploads of your Product Datafeed, if you require it.
The Datefeed file that needs to be sent to ShareASale has the following specifications.

CSV (Comma Separated Values) File / Comma Delimited Text File with Windows Line break (CR LF) as Row Delimited and Double Quote as Text Qualifier.
First Column has to contain the Column Header Labels.
It has to look like this:

"SKU","Name","URL to product","Price","Retail Price","URL to image",
"URL to thumbnail image","Commission","Category","SubCategory","Description",
"SearchTerms","Status","Your MerchantID", "Custom 1", "Custom 2", "Custom 3",
"Custom 4", "Custom 5"

Please note that each product should be on one line, no line breaks...there may be a line break in this example depending on your monitor size.

An Example:

"1183-4888","Shareasale.com Product 1",
"http://www.shareasale.com","199.00","500.00","http://www.shareasale.com/image1.gif",
"http://www.shareasale.com/image2.gif","100.00","4","32","This is a description of the product",
"Listing some search terms here","instock","47","Custom Field","Custom Field","Custom Field",
"Custom Field","Custom Field"

The Pipe character (|) is a reserved character and should not appear anywhere in your file.
Any double quotes in your data (") should be escaped by doubling them. For example, the product name


Frame, 13" square Would be written: "SKU","Frame, 13"" square","Product URL" ...


- top -


ShareASale Product Datafeed for Merchants Column Specifications


Return to Network Specific Implementation Guides and Documentations or to Affiliate Datafeeds Resources.

Column OrderDataData TypeMax LengthNull Value AllowedComments
1SKUText255 charactersNoMandatory Unique Value
2NameText255 charactersYesProduct Name
3URLURL255 charactersNoDirect URL to the product
4PriceNumeric2 decimal placesNoProduct Price
5RetailPriceNumeric2 decimal placesYes"Retail" or "List" price
6Full ImageURL255 charactersYesURL to product full size image
7Thumbnail ImageURL255 charactersYesURL to product thumbnail image
8CommissionFloat
-
YesDollar amount of product commission (do not enter in a commission percentage). This will not affect the tracking or the actual commission rewarded on the sale, and is only for a quick reference for the affiliate.
9CategoryInteger
-
NoProduct Category - see ShareASale defined category numbers below
10SubcategoryInteger
-
NoProduct Subcategory - see ShareASale defined subcategory numbers below
11DescriptionTextNo character limitYesProduct Description
12Search TermsText255 charactersYesComma separated list of product search terms
13StatusText255 charactersYesStock Status.
  • instock - Indicates an In Stock item
  • backorder - Indicates an item on backorder
  • cancelled - Indicates an item no longer offered
  • soldout - Indicates an item that is sold out.
14MerchantIDInteger
-
NoYour ShareASale MerchantID is 2123
15Custom1Text255 charactersYesAny extra data you would like to add. Your own category/subcategory information is highly recommended.
16Custom2Text255 charactersYesAny extra data you would like to add. Your own category/subcategory information is highly recommended.
17Custom3Text255 charactersYesAny extra data you would like to add. Your own category/subcategory information is highly recommended.
18Custom4Text255 charactersYesAny extra data you would like to add. Your own category/subcategory information is highly recommended.
19Custom5Text255 charactersYesAny extra data you would like to add. Your own category/subcategory information is highly recommended.

- top -


ShareASale Product Categories and Sub Categories

As of 9/5/2006

Return to Network Specific Implementation Guides and Documentations or to Affiliate Datafeeds Resources.

Category: One of the following integer values, representing Shareasale.com Categories:


  • 1: Art/Media/Performance
  • 2: Auto
  • 3: Books/Reading
  • 4: Business/Services
  • 5: Computer
  • 6: Electronics
  • 7: Entertainment
  • 8: Fashion
  • 9: Food/Beverage
  • 10: Gifts/Specialty
  • 11: Home/Family
  • 16: Metaphysical
  • 12: Personal Care
  • 13: Sports/Outdoors
  • 14: Toys/Games
  • 15: Travel

- top -

Subcategory: One of the following integer values, corresponding to a product Subcategory.


Art/Media/Performance Subcategories


  • 1: Art
  • 2: Photography
  • 3: Posters/Prints
  • 4: Music
  • 5: Music Instruments


Auto Subcategories


  • 6: Accessories
  • 7: Car Audio
  • 8: Cleaning/Care
  • 9: Motorcycles
  • 10: Misc.
  • 11: Repair
  • 12: Parts


Books/Reading Subcategories


  • 13: Art
  • 14: Careers
  • 15: Business
  • 16: Childrens
  • 17: Computers
  • 18: Crafts
  • 19: Education
  • 20: Engineering
  • 21: Gifts
  • 22: Health
  • 23: History
  • 24: Fiction
  • 25: Law
  • 26: Magazines
  • 27: Financial
  • 28: Medical
  • 29: Office
  • 30: Real Estate
  • 31: Misc.
  • 164: Religious


Business/Services Subcategories


  • 32: Advertising
  • 33: Motivational
  • 34: Coupons/Freebies
  • 35: Financial
  • 36: Loans
  • 37: Office
  • 38: Careers
  • 39: Mis.


Computer Subcategories


  • 40: Hardware
  • 41: Software
  • 42: Instruction
  • 43: Handheld/Wireless
  • 162: Web Hosting


Electronics Subcategories


  • 44: Audio
  • 45: Video
  • 46: Camera
  • 47: Wireless


Entertainment Subcategories


  • 48: Audio
  • 49: Video
  • 50: DVD
  • 51: Laser Disc
  • 52: Sheet Music
  • 53: Crafts/Hobbies


Fashion Subcategories


  • 54: Boys
  • 55: Clearance
  • 56: Vintage
  • 57: Girls
  • 58: Mens
  • 59: Womens
  • 60: Maternity
  • 61: Footware
  • 62: Accessories
  • 63: Baby/Infant
  • 64: Jewelry
  • 65: Lingerie
  • 66: Plus-Size
  • 67: Athletic
  • 161: T-Shirts


Food/Beverage Subcategories


  • 68: Baked Goods
  • 69: Beverages
  • 70: Chocolate
  • 71: Cheese/Condiments
  • 72: Coupons
  • 73: Diet
  • 74: Ethnic
  • 75: Gifts/Gift Baskets
  • 76: Nuts
  • 77: Cookies/Desserts
  • 78: Organic
  • 163: Tobacco


Gifts/Specialty Subcategories


  • 79: Anniversary
  • 80: Birthday
  • 81: Misc. Holiday
  • 82: Collectibles
  • 83: Coupons
  • 84: Executive Gifts
  • 85: Flowers
  • 86: Baskets
  • 87: Greeting Card
  • 88: Baby/Infant
  • 89: Party
  • 90: Religious
  • 91: Sympathy
  • 92: Valentine's Day
  • 93: Wedding


Home/Family Subcategories


  • 94: Bed/Bath
  • 95: Garden
  • 96: Cleaning/Care
  • 97: Furniture
  • 98: Home Décor
  • 99: Home Improvement
  • 100: Kitchen
  • 101: Pets


Metaphysical Subcategories


  • 160: Metaphysical


Personal Care Subcategories


  • 102: Cosmetics
  • 103: Exercise/Wellness
  • 104: Safety


Sports/Outdoors Subcategories


  • 105: Accessories
  • 106: Auto
  • 107: Outdoors/Camping
  • 108: Parlor/Backyard Games
  • 109: Baseball/Softball
  • 110: Cricket
  • 111: Billiards
  • 112: Boating
  • 113: Body Building/Fitness
  • 114: Bowling
  • 115: Boxing
  • 116: Canoeing
  • 117: Climbing/Mountaineering
  • 118: Cycling
  • 119: Diving
  • 120: Field Hockey
  • 121: Skating
  • 122: Fishing
  • 123: Football
  • 124: Frisbee
  • 125: Golf
  • 126: Gymnastics
  • 127: Hockey
  • 128: Horses
  • 129: Hunting
  • 130: In-line Skating
  • 131: Kayaking
  • 132: Lacrosse
  • 133: Martial Arts
  • 134: Racquetball
  • 135: Running
  • 136: Skateboards
  • 137: Ski/Snowboard
  • 138: Soccer
  • 139: Surfing
  • 140: Tennis
  • 141: Teamware / Logo
  • 142: Volleyball
  • 143: Wrestling
  • 165: Birding


Toys/Games Subcategories


  • 144: Action
  • 145: Animals
  • 146: Baby/Infant
  • 147: Board Games
  • 148: Card/Casino
  • 149: Electronic
  • 150: Educational
  • 151: Magic
  • 152: Misc.
  • 153: Musical
  • 154: Outdoor
  • 155: Video


Travel Subcategories


  • 156: Coupons
  • 157: Maps
  • 158: References / Guides
  • 159: Vacation Travel

- top -

Other Data Feed Guides for Affiliates and Advertisers


Cumbrowski.com Sponsors

See the Advertiser Kit to learn more about sponsorship opportunities at Cumbrowski.com. Press? Download my Media Kit.

Email Alert & Newsletter (privacy) My Blog Posts and Newsletter (read)


Enter your email address:

or ReveNews - Carsten Cumbrowski - Feed