adding new field value to AW is possible?

[swathi_somaraj]

Tweet

I need merchant logo url from product feed.But this column is not mentioned in AW product feed.What should i do?

[scriptmonkey]

The merchant logo is available from this location

http://www.affiliatewindow.com/logos/MERCHANTID/logo.gif

just substitute MERCHANTID with the merchant ID (which is found in the product feed)

[swathi_somaraj]

Hi...
thanq..it is working good..
is storing of all merchants logos in my database possible?how can i store?

[scriptmonkey]

You want to store the logos, or the logo locations?

What kind of database?

[swathi_somaraj]

Hi..
I want to store merchant logo urls in my database for my site.
I created a database with AW product feed in order to speed up of loading.In that feed i haven't found the merchant logo urls info.
I also have a big doubt regarding this feed.From feed(products) in database,how should i select popular products????

[scriptmonkey]

You don't need to store the logo urls in your database, you can just write them out in php

<img src="http://www.affiliatewindow.com/logos/<? echo $row_products['merchant_id']; ?>/logo.gif" width="88" heigh="31" alt="<? echo $row_products['merchant_name']; ?>" />

To find popular products, then you will need to access the field called 'is_hotpick' (which may or may not have been populated by the merchant )

[swathi_somaraj]

Hi..
I want both hot pick products as well as popular products..
Anyway shall i know what is your opinion on TD feed?
How can i access their unlimited product feed?To access their feeds,is there any payment structure?

[scriptmonkey]

Apart from the 'is_hotpick' field, then there is no way to determine a 'popular' product in the Awin datafeed.

With Tradedoubler, you don't need to pay for their data, you just sign up to merchants who have a product feed.

My opinion on the TD feed. Unfortunately, there isn't a 'TD feed' as such, it's more of a bunch of merchant feeds sharing the same loose structure, so, what you may find in one feed, you won't find in another.

It depends from merchant to merchant, some are brilliant, some are a complete dogs dinner.

[swathi_somaraj]

Ok..Suggest me whose feed might be the best,AW or TD

[scriptmonkey]

Thats a very easy question to answer, AW

But, you will find that there are many people using AW feed, so, perhaps if you spend some time getting to grips with the TD feeds, then you may find more profit in TD?

[swathi_somaraj]

Thanq for ur quick response and suggestions...

[swathi_somaraj]

Hi...
Good morning..
Today i'm integrating merchants info in my page.There is no description for merchants in AW feed.how can i get this?

[scriptmonkey]

Good morning, the merchant data isn't available from the product feed, however, you can retrieve this data from the API;

Firstly, you will need a V3 API key from Awin Affiliate Marketing – Affiliate Window – Affiliate Network

Secondly, you will need the two files referenced in the top of the following code, they are here The API Core Files : Awin API Help & Code you will need to join to get access to them (get the V3 version)

Then apply the following.

Pass the merchant ID from your database to this bit of code.

<?
define('API', 'PS');
require_once('constants.inc.php');
require_once('classes/class.ClientFactory.php');
$oClient = ClientFactory::getClient();
$merchantcolumns = array(sStrapline,sDescription,sLogoUrl,sDisplayUrl,sClickThroughUrl,oDiscountCode);
$singlemerchantwithcodes = array('iMerchantId'    => 1107, "sColumnToReturn" => $merchantcolumns);
$oResponse= $oClient->call('getMerchant', $singlemerchantwithcodes);
 
$iId = $oResponse->oMerchant->iId;
        $sName =$oResponse->oMerchant->sName;
        $sStrapline = $oResponse->oMerchant->sStrapline;
        $sDescription = $oResponse->oMerchant->sDescription;
        $sLogoUrl = $oResponse->oMerchant->sLogoUrl;
        $sDisplayUrl = $oResponse->oMerchant->sDisplayUrl;
        $sClickThroughUrl = $oResponse->oMerchant->sClickThroughUrl;
        echo '<a href="'.$sClickThroughUrl.'" title="'.$sName.'">'.$sName.'</a><br/>'.$sStrapline.'<br/><img src="'.$sLogoUrl.'" alt="'.$sName.'" /><br/>'.$sDescription.'';
        
        
        $arraycheck1 = $oResponse->oMerchant->oDiscountCode;            
            if(!empty($arraycheck1) and is_array($arraycheck1)){
            
                     echo '<div style="margin: 5px 0; background: #D5D5D5; line-height: 0; height: 1px;"></div><h3>Vouchers for '.$sName.'</h3>';    
                    foreach($oResponse->oMerchant->oDiscountCode as $key=>$details2){    
                    $sCode = $details2->sCode;         
                    $sDescription = $details2->sDescription;  
                    $sUrl = $details2->sUrl;  
                        if ($sUrl=='') $sUrl = $sClickThroughUrl;      
                            $sEndDate = $details2->sEndDate;     
                            $sEndDate = explode('-',$sEndDate);
                            $sEndDate = $sEndDate[2].'/'.$sEndDate[1].'/'.$sEndDate[0];        
                           echo '<div style="margin: 5px 0; background: #D5D5D5; line-height: 0; height: 1px;"></div><a href="'.$sUrl.'"  title="'.$sName.'"><img src="'.$sLogoUrl.'" alt="'.$sName.'"  border="0"/></a><br><b>Voucher Code: <a href="'.$sUrl.'">'.$sCode.'</a></b><br/> <font color="red">(Expires '.$sEndDate.')</font><br/>'.$sDescription.'';                      
                    }            
            }   
             elseif(!empty($arraycheck1) and !is_array($arraycheck1))
             {
             echo '<div style="margin: 5px 0; background: #D5D5D5; line-height: 0; height: 1px;"></div><h3>Vouchers for '.$sName.'</h3>';    
                       
                    $sCode = $oResponse->oMerchant->oDiscountCode->sCode;         
                    $sDescription = $oResponse->oMerchant->oDiscountCode->sDescription;  
                    $sUrl = $oResponse->oMerchant->oDiscountCode->sUrl;  
                        if ($sUrl=='') $sUrl = $sClickThroughUrl;      
                            $sEndDate = $oResponse->oMerchant->oDiscountCode->sEndDate;     
                            $sEndDate = explode('-',$sEndDate);
                            $sEndDate = $sEndDate[2].'/'.$sEndDate[1].'/'.$sEndDate[0];        
                            echo '<div style="margin: 5px 0; background: #D5D5D5; line-height: 0; height: 1px;"></div><a href="'.$sUrl.'"  title="'.$sName.'"><img src="'.$sLogoUrl.'" alt="'.$sName.'"  border="0"/></a><br><b>Voucher Code: <a href="'.$sUrl.'">'.$sCode.'</a></b><br/> <font color="red">(Expires '.$sEndDate.')</font><br/>'.$sDescription.'';
                            }  
                                
?>

That should result in this page

http://www.easynewshop.com/11.php

If you don't want to show the voucher codes, then simply use the following code

<?
define('API', 'PS');
require_once('constants.inc.php');
require_once('classes/class.ClientFactory.php');
$oClient = ClientFactory::getClient();
$merchantcolumns = array(sStrapline,sDescription,sLogoUrl,sDisplayUrl,sClickThroughUrl);
$singlemerchantwithcodes = array('iMerchantId'    => 1107, "sColumnToReturn" => $merchantcolumns);
$oResponse= $oClient->call('getMerchant', $singlemerchantwithcodes);
 
$iId = $oResponse->oMerchant->iId;
        $sName =$oResponse->oMerchant->sName;
        $sStrapline = $oResponse->oMerchant->sStrapline;
        $sDescription = $oResponse->oMerchant->sDescription;
        $sLogoUrl = $oResponse->oMerchant->sLogoUrl;
        $sDisplayUrl = $oResponse->oMerchant->sDisplayUrl;
        $sClickThroughUrl = $oResponse->oMerchant->sClickThroughUrl;
        echo '<a href="'.$sClickThroughUrl.'" title="'.$sName.'">'.$sName.'</a><br/>'.$sStrapline.'<br/><img src="'.$sLogoUrl.'" alt="'.$sName.'" /><br/>'.$sDescription.'';
?>

giving you this page

http://www.easynewshop.com/12.php

[swathi_somaraj]

Hi..
I know this well,retrieving merchants info with API calls.
Now i don't want to use these functions like getCategory, getProduct, getMerchant....etc.
What i 'm doing is i am dumping categoryList.csv, datafeed_apiID.csv and also awMerchantsMetadata in my database.I want to develop my site with my database only...
Today only i found merchants metadata in AW.But there are 4 type
-Subscribed Merchants
-Subscribed Merchants (Product Enabled only)
-All Merchants
-All Merchants (Product Enabled only)
What are these?Do u know about these four types.
Which one makes the best combination with AW product feed.....?

[scriptmonkey]

If you're downloading products from merchants you are subscribed to, then it would make sense to use Subscribed Merchants (Product Enabled only)