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|Manufacturer|PartNumber|MerchantCategory|
MerchantSubcategory|ShortDescription|ISBN|UPC|
LastUpdated|status

Notes:
Columns in red color are new.
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 breaks (CR LF/chr(13)+chr(10)) as Row Delimited
    • and Double Quotes (") as Text Qualifier.
  • The first column has to contain the column header labels.

It has to look like this (columns in red color are new):

"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","Manufacturer","PartNumber","MerchantCategory",
"MerchantSubcategory","ShortDescription","ISBN","UPC"


Please note that each product should be on one line, no line breaks (note that there are line breaks in this example for readability reasons).

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","Producer Inc.","PROD123","Stuff",
"Stuff for Buffs","This is a short product description.","978-0-00000-000-0","123456789012"


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.

#NameData TypeMax LengthNull Value AllowedComments
1SKUText255NoMandatory Unique Value
2NameText255YesProduct Name
3URLURL255NoDirect URL to the product
4PriceNumeric - NoProduct Price, numeric with 2 decimal places e.g. 100.99, without the currency name, code or symbol
5RetailPriceNumeric - Yes"Retail" or "List" price, numeric with 2 decimal places e.g. 199.99, without the currency name, code or symbol
6Full ImageURL255YesURL to product full size image
7Thumbnail ImageURL255YesURL 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
-
NoNumeric Product Subcategory (1-3 digits in length)- see ShareASale defined subcategory numbers below
11DescriptionTextNo limitYesProduct Description
12Search TermsText255YesComma separated list of product search terms
13StatusText255YesStock 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. You can find your Merchant ID in the top left corner of the ShareASale web interface for advertisers/merchants (login required).
15Custom1Text255YesAny extra data you would like to add and that help your affiliates. Which additional information could be useful to your affiliates depends on your niche or industry, such as product dimensions, weight, special delivery/shipping options, colors, product types, themes, styles, promotions, dates etc.
16Custom2Text255YesAny extra data you would like to add.
17Custom3Text255YesAny extra data you would like to add.
18Custom4Text255YesAny extra data you would like to add.
19Custom5Text255YesAny extra data you would like to add.
20ManufacturerText255YesName of the Product Manufacturer.
21PartNumberText255YesThis should be a manufacturer provided value that uniquely identifies this product. This could be a model number, part number, etc.
22MerchantCategoryText255YesProduct Category Name
23MerchantSubcategoryText255YesName of the Subcategory for the product.
24ShortDescriptionText255YesUse for providing a short and highly descriptive product description without any HTML markup or formating. This discription is often used by affiliates for the display in product listings or in product widgets and show-case creators.
25ISBNText25YesApplies to books, magazines and some other print publications only, the International Standard Book Number, short ISBN or ISBN13 (Bookland) for all publications after 1/1/2007. learn more ...
26UPCText25YesUnique Product Code (UPC-A, 12 digits) used in the United States and Canada only; or better, the EAN-13 code (13 digits), which was implemented by the International Article Numbering Association (EAN) in Europe. UPC-A is a subset of EAN-13, which means that all UPC-A codes can be converted to EAN-13, but not the other way around. If neither EAN-13 or UPC-A is known, provide the shorter UPC-E (8 digits representation of UPC-A), if available.

- top -

ShareASale Product Categories and Sub Categories

As of 10/22/2008 (categories in red color are new)

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
  • 173: Science


Business / Services Subcategories


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


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
  • 166: Big And Tall
  • 168: Petite
  • 169: Unisex
  • 172: Costumes


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
  • 176: Gourmet
  • 177: Meals / Complete Dishes
  • 180: Appetizers
  • 181: Soups


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
  • 170: Personalized


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


Parts / Equipment Subcategories


  • 167: HVAC (Heating and Air Conditioning)
  • 171: Medical
  • 182: Military


Personal Care Subcategories


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


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
  • 174: Prospecting / Treasure Hunting
  • 175: Swimming
  • 178: Basketball


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, Articles and Resources 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