Products Viewed - Exclude Spiders

[philip937]

Hi all,

Does anyone know if it's possible to stop spiders from incrementing the products viewed entries?

I would really like to know what my customers are looking at not the spiders..

Cheers,
Phil

[Ajeh]

The counter is in the:
/includes/modules/pages/product_info/main_template_vars.php

You should be able to surround that with an IF so that spiders are not counted:

if ($spider_flag == false) {
// products_viewed code
}

[philip937]

The counter is in the:
/includes/modules/pages/product_info/main_template_vars.php

You should be able to surround that with an IF so that spiders are not counted:

if ($spider_flag == false) {
// products_viewed code
}

will this do it? want to check first, dont want to break it..

if ($spider_flag == false) {
$res = $db->Execute($sql);
}

?

[Ajeh]

If you have that on the one under the select for:

    $sql = "update " . TABLE_PRODUCTS_DESCRIPTION . "
            set        products_viewed = products_viewed+1
            where      products_id = '" . (int)$_GET['products_id'] . "'
            and        language_id = '" . (int)$_SESSION['languages_id'] . "'";
    if ($spider_flag == false) {
      $res = $db->Execute($sql);
    }

Then it should work ...

Be sure to test this and see how well the changes work for you and that it still counts guests and customers ...

[philip937]

Yeah I did this:

//added to stop spiders incrementing
if ($spider_flag == false) {

    $sql = "update " . TABLE_PRODUCTS_DESCRIPTION . "
            set        products_viewed = products_viewed+1
            where      products_id = '" . (int)$_GET['products_id'] . "'
            and        language_id = '" . (int)$_SESSION['languages_id'] . "'";

    $res = $db->Execute($sql);
    
    }
//added to stop spiders incrementing 

seems to be working for customers/visitors just watching for spiders now :o)

[philip937]

couldn't be bothered to wait, fetched as googlebot from webmaster tools and no increment so seems to work a treat :)

Surprised this isnt already built in!

Thanks

Phil

[Ajeh]

Thanks for confirming that this worked for you ...

Some may want to know all counts ...

Personally, I'd like to see a count for spiders separate from the guest/customers ... but that is just me ...

[philip937]

Thanks for confirming that this worked for you ...

Some may want to know all counts ...

Personally, I'd like to see a count for spiders separate from the guest/customers ... but that is just me ...

Yeah could add an additional column in the table and have the second query run on the opposite logic to the if statement and then have the report show both.

I agree as it's still important to see that spiders are crawling all products so is an easy reference to check this.

Phil :)

[DivaVocals]

Thanks for confirming that this worked for you ...

Some may want to know all counts ...

Personally, I'd like to see a count for spiders separate from the guest/customers ... but that is just me ...

I HATE to bump an old post.. But how could this separate count be implemented??

[Ajeh]

The basic idea is that there is a flag set for:
$spider_flag

so when the Counter tables are updated, you would do one thing for spiders and one thing for none spiders ...