Creating an affiliate site with Drupal?
Ticktockman - March 14, 2006 - 16:38
Hi all - I'm wondering if anyone has created an affiliate site with Drupal? Meaning, using a datafeed from Commission Junction or LinkShare to generate pages. I'd love to take advantage of Drupal's other features such as forums/blogs in the future - but right now I need to mass-generate pages based from a spreadsheet. Is there a module that will allow Drupal to do this?
For those not familiar with affiliate feeds - the store will give you a spreadsheet containing all their product information, so I need to be able to generate pages (or nodes in this case) based on fields or variables from the spreadsheet. (a "price" variable will insert the price, description, image, shipping info, etc....)
Anyone have experience with this?
Also interested
I'm also interested. Does anyone have any ideea ? :)
------------------------------------------------------
Be smart, Think Free, Choose OpenSource
Yes, i am interested in this
Yes, i am interested in this too.
anyone have a customized module of hack that can do this?
thank you
lorry
http://magazinesus.info
Guess not
Well, friends, it appears not. :-(
As of now I'm planning on stalling drupal, then using this program:
http://www.fourthworld.com/products/webmerge/index.html
to generate product pages if I have to. If I come up with anything or find anthing I'll post it here.
Ticktockman
Newbie Has Untried Idea
I'm disappointed folk did not respond to your question. I have not tried the following, but I don't see why it wouldn't work.
Install the e-commerce module.
Find the table that has the matching fields for the data you want to upload. Using phpMyAdmin you upload the data from the spreadsheet to the database.
It's possible t he e-commerce module has its own user interface to import data from spreadsheets, but I don't know.
You still have to figure out how the e-commerce module works and configure it correctly to use on your site etc. But the data entry should be easy to do in bulk.
Shai
Eh, yeah
Hmm, that might work Kelev. I think it's just too much work for me :-)
I'm going to create a static site using that program I mentioned above, then later when I want to add articles/comments, I think I'll try to integrate an installation of WordPress. The time consuming part will be merging/modifying templates.
Good luck!
Datafeeds are not sql as far as I know
I could be wrong but datafeeds are xml documents and require interpretation via xml parsers.
It's more along the lines of rss technology and using xsl stylesheets and all that hoo haa.
Kinda
I've started toying with this... and found a site called GoldenCan.com. It is like and affiliate aggregator... you can basically sign up, put in your affiliate IDs for LinkShare, CJ, ShareASale, etc. They DO take credit for every 4th click on some stores (like Amazon, etc.). It functions by putting a .js code as a post on your drupal blog page. Works pretty slick. You can customize the .js style/look and feel to come close to your site colors, etc. Hope this helps.
Sounds Good
But still a datafeed integration has other benefits. Full integration will get the site spidered and provide more search engine content since the spiders can read html, but they can't read javascript.
There is only a limited number of merchants to promote. Datafeed integration will allow selection of a wider range of affiliate programs, which is necessary for the professional affiliate.
Any Follow-Up
Is there any new news on this subject? Anyone developing for it (or interested)??
Interested
Count me in as intersested in this, I do not have the knowledge to create a module myself but am planning on checking out the XML feed Linkshare provides.
-Tim
Timothy B. Adams
http://www.HostDr.com
WebMerge
Hi,
Could a possible solution be a 3rd party integration module with the WebMerge software mentioned above? I'd like to get something in the works.
TickTockMan, how are you using that software with Drupal? Care to provide an example?
*Bump* Any progress?
Anyone else started working on this integration? I've just recently started integrating the CJ.com ProductSearch 2.0 into a products table on my Drupal DB. I'll soon have it integrated into an e-commerce products.
My concern is the "human experience" at time of checkout. To my knowledge cj is only providing a buy link for each item; what about cases where there's more than one item to be purchased? Any ideas how that should be handled? If it should be handled? (If it shouldn't, scratch out the "shopping cart" idea - and simply do direct links (eek) from the product description page to the advertiser.)
Next question / comment request: should the calling advertiser page be iframed (can it be iframed? Any known legal restrictions?)? I haven't yet researched this case but if anyone else has success or failure stories with it - please share.
Thanks,
GNG
P.S. previous CMS integration of CJ was successful for me when I built my own product browser and placed that as an inframe into the J* CMS suite, the purchase links did go to the full page and google-analytics didn't show too high of a bounce rate.
I'm looking for a cleaner approach here and I'm quite interested with Drupal for other apps, so I figured I'd throw in the aff sites too.
shopping cart from affiliate data
i have some queries out to other forums, but i am looking for something similar --a way to import data from vendor datafeeds and then present a single user experience to shoppers, so they don't simply pay for each item one at a time, but rather fill a shopping cart then buy at once.
if anyone has done this, please do tell here.
if i get any info from another forum, i'll post. the import part shouldn't be too hard; if i figure it out, i'll post some info as well.
best,
m
any more progress?
Also looking for an affiliate style e-commerce site.
I'm sure it is possible with
I'm sure it is possible with Drupal. But if want the easier option, maybe use Joomla instead. There is already couple of extensions available: http://joomlashopbuilder.com/ (by the way, these are commercial extensions).
thanks,
Any update on this
Any update on this system??
Would really like to use datafeeds on my site
thanx
also interested in this.
also interested in this.
Hi, Would feedapi be an
Hi, Would feedapi be an alternative? Did somebody already pull this off?
Greetings, Martijn
Subscribing
Subscribing
subscribing
no one has tried http://drupal.org/project/affiliate_products_shop ?
henns20
links only?
I read the documentation on this module and it looks like it imports links, only. Not all the data in the product catalogue, which is what I'm looking for. If anyone has had some experience with this module, how did it work for you?
Connie
Feedapi + CCK + Views
I'm thinking that Feedapi is probably the best module to handle the feeds from the affiliate networks. Then it is just a matter of creating nodes from the feed and using views to display the info the required way.
I'll give Feedapi a go when I get a chance. Anyone fancy giving it ago as well?
-----
My Drupal Blog
Feedapi experience?
Blairski,
How did the feedapi integration go? Did you also use the Feed Element Mapper? I'm about to do the same and would appreciate any advice from your experience. I will share the same as soon as I get my site up and running.
Connie
Hi Connie, I haven't
Hi Connie,
I haven't actually had a chance to try it yet as I have been busy on other things. I am hoping to give it a go at some stage in the next few weeks.
Regards
Blairski
Subscribe
I'm interested in this, too.