Database driven affiliate websites

Affiliate Datafeed Sites Ready

You read that right. Datafeed affiliate sites are ready for you.

Thanks to the beta testers that participated - I was able to check THE SCRIPT out on sites as the homepage, in a subdirectory, and as a subdomain.

Here's a brief tour of what these sites look like.

Home Page

The home page randomly selects an instock image from the database to display on each page load.

What remains consistent is the links to the categories - the gateway to the 1,400 unique pages that make up this site.

home page

Category

Lots of content on this page. Each category page will display a random, instock item with image at the top of the page, followed by a list of other items from the same category. Some little programming *twists* I put in include:

  • sorted by highest to lowest price
  • Decreasing amount of information per item - the first few items display the most amount of information, farther down the list, the items have less information about them, until you get the the last few items - all there is at that point is links. Why did I do this - to be different. I don't want these sites to be run-of-the-mill datafeed sites that are practically identical to other datafeed sites

category

Product page

Specific information about each instock item in the datafeed - includes a image, price, title, description.

product

What's unique about about these pages is:

  • Randomly arranged sentences - the sentences are not the exact same structure as what is provided - THE SCRIPT rearranges the results and displays them in a different order each time the page is refreshed ...
  • ... which leads to this, THE SCRIPT has a cache feature so the results remain the same for each dynamically generated page. During setup, the cache is either turned on or left off (I recommend having it on). If on, then specify how long pages are cached for before being regenerated. I don't see any reason to set the cache for anything less than 30 days.
  • Something you should know, there are actually 4,000+ items in the database. Unfortunately, most of the products are out of stock. That's a lot of perfectly good information going to waste. So what did I do, I include a random item description from an out of stock item from the same category for the same reason I added a few twists to the categories - to be different.
  • Also, the side bar - besides containing links to the categories - also includes links to random items in the same category

Search

Included a "smart" search feature - well, maybe not as smart as Google, but smart enough to almost guarantee relevant results showing up.

Here's how it works, say you type in "apple". THE SCRIPT will randomly pull results that have the word "apple" show up in the title. If THE SCRIPT doesn't find any results, then it makes a second pass through the database looks for the word "apple" in the description. Pretty smart, huh?

search

Ready To Go

A simple, powerful script that displays results from the datafeed in a unique fashion - that's what THE SCRIPT is.

P.S. - If you want a "behind the scenes" view of how the code works for this datafeed site, visit the link, http://www.youtube.com/watch?v=PLeGbqEb9L4.


Share: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • Sphinn
  • Mixx
  • StumbleUpon
  • MisterWong

15 Responses to “Affiliate Datafeed Sites Ready

  • 1
    Mike Baker
    April 17th, 2008 08:40

    Hi Dave,

    Looks very nice. I have not watched the video yet, but am wondering if you are going to sell something like this? I would be interested. Especially if it were simple on my end about inputing info.

    Mike

  • 2
    Linkvana
    April 17th, 2008 09:07

    Dave - the sites looks great. Way better than I would ever have imagined for a data feed driven website. Hats off to you man- great work.

    Mike

  • 3
    admin
    April 17th, 2008 09:56

    @Mike Baker,

    I plan on selling this.

    I *think* it is easy to setup, but I'm also the one that created it :)

    I'm offering to set these sites up now, so I can document the process for the all important help files.

    In about a week, this will be available for sale - including help files.

    Dave

  • 4
    admin
    April 18th, 2008 09:54

    @Mike,

    Thanks a lot. Glad you like it - a little creativity goes a long way.

    Dave

  • 5
    Chris
    April 18th, 2008 14:26

    Hi Dave,

    Looks great. Can't wait to see it implemented on my site.

    Good luck selling the script - I'm sure there will be a big demand for it once people see the videos and documentation.

    Thanks
    Chris

  • 6
    zamdoo
    April 21st, 2008 06:42

    Hi Dave,

    Just found your site through your videos on YouTube.

    The script certainly makes good looking sites.

    Please let me know when the script becomes available.

    Thanks.

  • 7
    Art Deco
    April 21st, 2008 22:23

    Hi Dave.
    I have a question about your script and MYSQL. I tried to add the same user to a city and state database (for growing zones) as you used for the affiliate database, and crashed both of the scripts with a not permitted error. Can you advise me on using the same login and password in MySQL?
    Art Deco

  • 8
    admin
    April 21st, 2008 23:39

    Hi Art Deco,

    Looks like you may have mistakenly changed the password for that user. I see the error message you are talking about.

    I logged in and deleted the username for THE SCRIPT, created it again, and assigned it to both the Shareasale database and the city/state database.

    The shareasale script is working again, not sure about the city/state since I don't know where it is being used.

    Dave

  • 9
    Art Deco
    April 22nd, 2008 05:42

    Thanks Dave - the City State DB is not in use yet so it doesn't matter - I was reasonably sure I had borked up the user password for your script, but was unsure about the fix. Anyway, nice script.

  • 10
    Jim Lorenzo
    April 28th, 2008 07:42

    Hi Dave:

    I just wanted to stop by and let you know that the gardening site you created for me at http:/www.garden-buffs.com is top-notch.

    I've been toying with the idea of creating a garden site that provides gardening advice, gardening tools, gardening supplies and gardening tips and your offer was in a word "timely".

    Thanks a ton to you and your boys for the excellent work!

    Jim

  • 11
    admin
    April 28th, 2008 08:38

    Jim,

    You are very welcome. I'll pass along this info to the boys.

    Dave

  • 12
    The Gardeners Supply
    April 28th, 2008 10:58

    Hey Dave,
    Very cool script you've created there! I guess I'm one of those "geeks" that likes to play around with the different scripts available! I'm waiting to see what further instructions you send about posting articles and all before I start to tweak the site.
    But it's a great looking site and a nice approach to utilizing the data feed.
    Thanks again!
    -Mark Krusch

  • 13
    admin
    April 28th, 2008 11:39

    Thanks Mark.

    Soon enough - by next weekend I should have further instructions out on how to manipulate everything.

    Dave

  • 14
    Gardening & Roses
    April 28th, 2008 17:05

    Hi Dave,
    Thank you for the quick setup of my site.
    Really like the concept.

    Your script sure does make some nice looking sites.

    Chuck Baslock

  • 15
    Handy Gardening Tips
    April 28th, 2008 21:46

    Hey Dave.

    Great gardening screen shots - and you did a great job on my website.

    Cheers

    Kevin

Leave a Reply