Merchant list

[Andy]

Hi

Sorry if this has already been covered, I can't find it anywhere.

Is it possible to get a list of Merchant names, their categories and their MID's in one list? If so, how?

[Confuscius]

Hi Andy

The AW Merchant metadata found under the datafeed exports section (go to the bottom of it) contains data such as follows - I do not know how the datafeeds relate to SW anymore and the Merchant Categort has nothing to do with product categories, etc, etc!! ANyways, a tidied up part of the file:

0 - Merchant ID,
1 - Merchant Name,
2 - Logo,
3 - Active,
4 - Merchant Metadata Version,
5 - Strapline,
6 - Description,
7 - Default Clickthrough,
8 - Merchant Category,
9 - Product Feed Enabled,
10 - Datafeed Version,
11 - Product Feed Last Refreshed,
12 - Product Feed Last Modified,
13 - Product Feed No. Products

"9",
"Fragrancedirect",
"http://www.affiliatewindow.com/logos/9/logo.gif",
"yes",
"5",
"Quality branded perfumes & aftershaves with up to 70% off",
"Fragrance Direct provide perfumes & aftershaves at up to 70% off high-street prices. With a massive selection of popular and unusual designer perfumes and aftershaves, they're perfect for gifts or just for yourself!",
"http://www.awin1.com/awclick.php?mid=9&id=xxxxx",
"Perfumes",
"yes",
"20",
"2007-05-10 09:01:06",
"2007-05-04 09:18:02",
"3297"

HTH.

Paul

[Andy]

Thanks Paul!

that's almost perfect, but the categories have names rather than IDs.

Maybe it would help if i mentioned what I want this for.

I want to add a function whereby people can search for a retailer. if it exists, it would provide a link to the merchants page on the api.

So the link needs to contain the MID and the CATID.
Obviously, I need the merchant name so there is something to search through.

[Glitz]

Agreed Andy,

In test, my most frequent request has been the ability to 'shop by merchant' instead of searching back through the product research they did yesterday!

Perhaps AWIN could help by providing a stripped down version (logo, brief description and link) of our 'joined' merchants so it would be up to date as we join new programs.

Anyway if you find a solution I would be grateful if you could share.

Jake.

[Andy]

I am seriously considering doing this by hand.
Using Pauls suggesstion, I have a third of the work done. All i would need to do is find a CatID that the merchant is "featured" on.

that way, i could construct the URLs.

I will be using this in a database driven function, so not sure if it'll help anyone else.

Once the donkey work is done, id be happy to email you a copy of the csv i create. Just PM me your email addy and ill send it along.

[Glitz]

Heck Andy,

I notice you don't sit around waiting for a fix! It's certainly beyond my ability at the moment but I'm sure I would benefit, even if placed in a standalone sub-domain page, so if you manage to complete the project I will try my best to implement it.

Appreciate your hard work. PM sent.

Jake.

[Andy]

Youre right, i never hang about waiting for a fix. If i can workaround anything in the meantime, i will.