ShareASale Product Datafeed for Affiliates
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.
ShareASale Product Datafeed for Merchants
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” …
Ref: http://www.cumbrowski.com/CarstenC/affiliatemarketing_datafeeds_shareasale.asp