Have an account? / Register

Forgot your password?

Forgot your username?

Page 1 of 3 123 LastLast
Results 1 to 15 of 40

Thread: adding new field value to AW is possible?

  1. #1
    Registered User
    Join Date
    Oct 2009
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    adding new field value to AW is possible?



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

  2. #2
    Ex-User scriptmonkey's Avatar
    Join Date
    Jan 2009
    Location
    Back home in North Wales
    Posts
    1,742
    Thanks
    128
    Thanked 307 Times in 230 Posts

    Re: adding new field value to AW is possible?

    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)
    I've left the forum to farm sheep and cattle.

  3. #3
    Registered User
    Join Date
    Oct 2009
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adding new field value to AW is possible?

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

  4. #4
    Ex-User scriptmonkey's Avatar
    Join Date
    Jan 2009
    Location
    Back home in North Wales
    Posts
    1,742
    Thanks
    128
    Thanked 307 Times in 230 Posts

    Re: adding new field value to AW is possible?

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

    What kind of database?
    I've left the forum to farm sheep and cattle.

  5. #5
    Registered User
    Join Date
    Oct 2009
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adding new field value to AW is possible?

    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????

  6. #6
    Ex-User scriptmonkey's Avatar
    Join Date
    Jan 2009
    Location
    Back home in North Wales
    Posts
    1,742
    Thanks
    128
    Thanked 307 Times in 230 Posts

    Re: adding new field value to AW is possible?

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

    PHP Code:
    <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 )
    I've left the forum to farm sheep and cattle.

  7. #7
    Registered User
    Join Date
    Oct 2009
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adding new field value to AW is possible?

    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?

  8. #8
    Ex-User scriptmonkey's Avatar
    Join Date
    Jan 2009
    Location
    Back home in North Wales
    Posts
    1,742
    Thanks
    128
    Thanked 307 Times in 230 Posts

    Re: adding new field value to AW is possible?

    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.
    I've left the forum to farm sheep and cattle.

  9. #9
    Registered User
    Join Date
    Oct 2009
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adding new field value to AW is possible?

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

  10. #10
    Ex-User scriptmonkey's Avatar
    Join Date
    Jan 2009
    Location
    Back home in North Wales
    Posts
    1,742
    Thanks
    128
    Thanked 307 Times in 230 Posts

    Re: adding new field value to AW is possible?

    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?
    I've left the forum to farm sheep and cattle.

  11. #11
    Registered User
    Join Date
    Oct 2009
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adding new field value to AW is possible?

    Thanq for ur quick response and suggestions...

  12. #12
    Registered User
    Join Date
    Oct 2009
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adding new field value to AW is possible?

    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?

  13. #13
    Ex-User scriptmonkey's Avatar
    Join Date
    Jan 2009
    Location
    Back home in North Wales
    Posts
    1,742
    Thanks
    128
    Thanked 307 Times in 230 Posts

    Re: adding new field value to AW is possible?

    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.

    PHP 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

    PHP 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
    I've left the forum to farm sheep and cattle.

  14. #14
    Registered User
    Join Date
    Oct 2009
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adding new field value to AW is possible?

    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.....?

  15. #15
    Ex-User scriptmonkey's Avatar
    Join Date
    Jan 2009
    Location
    Back home in North Wales
    Posts
    1,742
    Thanks
    128
    Thanked 307 Times in 230 Posts

    Re: adding new field value to AW is possible?

    If you're downloading products from merchants you are subscribed to, then it would make sense to use Subscribed Merchants (Product Enabled only)
    I've left the forum to farm sheep and cattle.

Page 1 of 3 123 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. CPW - New Feed Field
    By SimonQuick in forum Affiliate Window
    Replies: 0
    Last Post: 20-02-09, 12:05 PM
  2. Level playing field!
    By futureweb in forum Affiliate Marketing Lounge
    Replies: 1
    Last Post: 06-11-08, 08:32 PM
  3. New Field In AW Feed
    By JTMobileFun in forum Affiliate Window
    Replies: 0
    Last Post: 08-09-08, 12:01 PM
  4. City Town : From Field
    By Lee_Owen in forum Programming
    Replies: 1
    Last Post: 08-06-06, 09:16 PM
  5. Field&Trek
    By kili in forum Tradedoubler
    Replies: 6
    Last Post: 06-06-05, 06:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
To Top

SEO by vBSEO 3.6.1