March 6, 2004

Affiliate Store - www.stateposters.us

Was cruising around the net and stumbled on http://www.allposters.com and started thinking about creating a targeted affiliate store. Did a little searching and decided that creating a store concentrating on the 50 US states seemed like a good idea. I could create state specific pages, each focusing on specific state posters and state prints.

Grabbed a domain from GoDaddy for a couple bucks - http://www.stateposters.us - for a couple bucks and had my ISP create a subdomain of http://stateposters.levinecentral.com and started to build the site. If it starts to take off, I'll just host a true domain with them, but the subdomain was free and I forward to it from GoDaddy.

To build the site I created a simple mySQL table that contains a key, the state abbreviation, the state name, the dynamic store id generated from allposters.com and a description.

I then built dynamic stores for each state. Most are just one page but for states with a lot of posters/prints I created multiple. Each store gets an id that I entered into the mySQL table.

I then wrote 1 page in ASP that generates every state page by reading the relevant record off the mySQL table plugging in the values in various areas of the code. It adds the description to the top to make it more personalized by state.

I created 1 main ASP page which just links to each state page and viola - a quick affiliate site. The longest time was actually on the allposters.com site selecting all the prints in each state category to build the individual dynamic stores.

Check it out at http://www.stateposters.us and buy something. Let me know how it works ;-)

Posted by David on March 6, 2004 1:07 PM