Affiliate Window feeds and Affilistore...

[matmat is verified member.]

Im having a bit of trouble with one of my sites.

I have the usual affilistore up and running with a affiliate window feed plugged into it.

The feed is exported with Plasma/LCD TVs inside of it (This is as far as you could drill down on affiliate window)

The problem is I only want the site to display the HD TVs.

Affilistore will allow filter keywords, but it takes them both and looks for any of them in the database. For example Samsung, HD as the filter keywords will look for items with Samsung OR HD inside them. Not Samsung AND HD

What are my best options? Could I sort the feed in Excel first before upload(how)? Am I missing a filter on Affiliate Window to do this before download??

Any help appreciated!

Mat

 

[dotukdomains]

post a request on their forum mat they are very helpful

or yeah like i had too edit with excel then reupload and configure options

 

[matmat is verified member.]

post a request on their forum mat they are very helpful

or yeah like i had too edit with excel then reupload and configure options

Did it through Excel. If anyone would like to know how here is the macro!

Sub DeleteNoString()

Dim roe As Long, c As Long, r As Long, i As Long

c = 1 'Change to your Column number
r = 1 'Change to start search at Row number = your row number

roe = Cells(65536, c).End(xlUp).Row

For i = 1 To roe
Cells(r, c).Select

'Change YOURSTRING to your string (keep the "")

If InStr(Cells(r, c), "YOURSTRING") Then
r = r + 1
Goto phred
Else
Cells(r, c).EntireRow.Delete
End If
phred:
Next
End Sub

 

[matmat is verified member.]

Fingers crossed the site should now ONLY display tvs of the HD variety.

HD TVs

Please let me know if you spot any mistakes

 

[MattUK]

Looks good. How do you get on with Affilistore? I've used it a few times before, but never looked into it seriously. Is it worth using it on my parked domains?

 

[dotukdomains]

i used it on comparisonsite.co.uk and had over 90 products from over 32 merchants lol

got too big and time consuming and complicated so stopped it but its awesome

 

[davedevelopment]

I think there's plenty of things that good be done to improve affilistore, filtering being one of them.

I end up filtering in excel before upload.

Does anyone know if you can get affiliatewindow data feeds *without* compression? If so, we might be able to make use of Yahoo Pipes

 

[devolution]

Just curious - I've started up my 1st Affilistore site tonight, wondering if you've had any decent comission from your site since it started running? (feel free to pm)
Thanks!

 

[Vialli]

Just curious - I've started up my 1st Affilistore site tonight, wondering if you've had any decent comission from your site since it started running? (feel free to pm)
Thanks!

This affilistore site has done ok over the last two years, plus I have another for football kits that has achieved even better earning results.

http://www.acorndomains.co.uk/uk-we...-biz-website-over-1k-revenue-so-far-year.html

 

[AdminAdmin is verified member.]

How are they ranking in Google? Mine didn't do so well after a couple of weeks or were delisted altogether.