Results 1 to 5 of 5
  1. #1
    Newbie
    Join Date
    September 17th, 2008
    Posts
    7
    Generating lists of merchants
    Is there a way to query the SAS database and generate a list of merchants, their website address, an indication of if they allow direct link or not?

  2. #2
    Member
    Join Date
    December 11th, 2009
    Location
    UK
    Posts
    64
    I get a Pipe-Delimeted .txt file of joined merchant by going to..

    Get a Link/Banner
    Tick the box for.. Create Downloadable Text File
    Click the button.... View the report to view below
    Click the link.... click here to download it.

    Lee
    [URL="http://www.icodes-us.com"]iCodes US[/URL] - Coupon & Deals Feeds for 13 US Networks - [URL="http://webservices.icodes-us.com/ws2_us.php?UserName=pagerank10&SubscriptionID=c81e728d9d4c2f636f067f89cc14862c&RequestType=Codes&Action=All&Sort=Id&Page=1&PageSize=50&Network=shareasale"]Example Shareasale CODES Feed[/URL] - [URL="http://webservices.icodes-us.com/ws2_us.php?UserName=pagerank10&SubscriptionID=c81e728d9d4c2f636f067f89cc14862c&RequestType=Offers&Action=All&Sort=Id&Page=1&PageSize=50&Network=shareasale"]Example Shareasale OFFERS Feed[/URL]

  3. #3
    ABW Ambassador 2busy's Avatar
    Join Date
    January 17th, 2005
    Location
    Tropical Mountaintop
    Posts
    5,636
    That gets you a datafeed of one merchant's products, not a list of merchants and their rules which is what the OP asked about. There isn't anyway to know the merchant's rules without manually looking at each merchant's program. You can do a search of all merchants, but only by product/category/name, not by TOS details.

  4. #4
    Member
    Join Date
    December 11th, 2009
    Location
    UK
    Posts
    64
    Perhaps i'm mis-understanding something, but i've just done the above and it's certainly not just providing a datafeed of one merchants products...

    http://www.icodes-us.com/shareasale_merchants_all.txt

    Merchant Id|Merchant|WWW|Program Status|Program Category|Sale Comm|Lead Comm|Hit Comm|Approved|Link Url

    Sorry if i'm being a bit thick.


    Lee
    [URL="http://www.icodes-us.com"]iCodes US[/URL] - Coupon & Deals Feeds for 13 US Networks - [URL="http://webservices.icodes-us.com/ws2_us.php?UserName=pagerank10&SubscriptionID=c81e728d9d4c2f636f067f89cc14862c&RequestType=Codes&Action=All&Sort=Id&Page=1&PageSize=50&Network=shareasale"]Example Shareasale CODES Feed[/URL] - [URL="http://webservices.icodes-us.com/ws2_us.php?UserName=pagerank10&SubscriptionID=c81e728d9d4c2f636f067f89cc14862c&RequestType=Offers&Action=All&Sort=Id&Page=1&PageSize=50&Network=shareasale"]Example Shareasale OFFERS Feed[/URL]

  5. #5
    http and a telephoto
    Join Date
    January 18th, 2005
    Location
    NYC
    Posts
    17,708
    Quote Originally Posted by iCodes View Post
    Perhaps i'm mis-understanding something, but i've just done the above and it's certainly not just providing a datafeed of one merchants products...

    http://www.icodes-us.com/shareasale_merchants_all.txt

    Merchant Id|Merchant|WWW|Program Status|Program Category|Sale Comm|Lead Comm|Hit Comm|Approved|Link Url

    Sorry if i'm being a bit thick.


    Lee
    The OP is looking for PPC bidding info, while there is a list you can download of your joined merchants, like you pointed out, there is not a place to additionally automatically add the PPC bidding info. That would have to be added manually to your own spreadsheet.

    Also be aware that even programs that don't have restrictions, may not understand PPC bidding, so I recommend contacting the AMs for any programs you want to work with using PPC, especially trademark or direct to merchant linking.
    Deborah Carney
    TeamLoxly.com BookGoodies.com ABCsPlus.com

  6. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Email Lists
    By dtrmend in forum Marketing Resources & Power Tools
    Replies: 6
    Last Post: January 11th, 2011, 12:17 PM
  2. Affiliate lists
    By Artease in forum Midnight Cafe'
    Replies: 3
    Last Post: June 16th, 2008, 07:53 PM
  3. Generating an index page without generating detail pages
    By Pierre (aka Terdef) in forum WebMerge (Fourthworld.com)
    Replies: 6
    Last Post: July 15th, 2005, 10:16 AM
  4. Bulletted Lists
    By sweat in forum WebMerge (Fourthworld.com)
    Replies: 3
    Last Post: November 17th, 2004, 06:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •