View Single Post
  #26  
Old August 30th, 2012, 12:08 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi
Quote:
Originally Posted by dhilditch View Post
I'm running into an issue since the 'description' column in DataFeedr for the coupons contains something like:

[begins:02/08/2012; ends:02/09/2012; code: WIGG10]

But I'm not seeing that in the database? This makes it impossible for me to write a custom function to do this. Any ideas where this data is going?
That data is in the products table in the description column.

Quote:
Originally Posted by dhilditch View Post
Also - is there a function like this:

AddReferrer(url, merchantid) // ideally something like this which transforms the DB url field into one containing the right referrerid for the affiliate network?
There's no function but a simple str_replace should work. Here's the PHP for the referrer:
PHP Code:
$referrer_id intval(@$_COOKIE['stortrak']); 
PHP Code:
str_replace("REFERRER_ID"$referrer_id$product->url); 
Eric


Eric