Autoposting Item to Drupal

Submitted by lunen on Mon, 2012-09-10 12:48 in Price Tapestry

Hi David,

I would like to take one product randomly from my database of products on price tapestry every day and post it to my drupal website. I'm thinking the easiest way to do this would be via an rss feed. So I could have an RSS file that drupal would grab during a cron job that contains the price tapestry product's: Title, Description, Image, Buy Link and Price.

Could you point me in the right direction on how to create this type of file in Price Tapestry?

Thanks!

Hi Lunen, Sure - there's an

Submitted by support on Mon, 2012-09-10 14:08

Hi Lunen,

Sure - there's an RSS export script in this thread - to export a single random product REPLACE line 14 in the code with:

$sql = "SELECT * FROM `".$config_databaseTablePrefix."products` GROUP BY name ORDER BY RAND() LIMIT 1";

Cheers,
David.
--
PriceTapestry.com