Products Viewed - Exclude Spiders

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

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
}

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
}

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

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

 
?

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

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)

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

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 ...:cool:

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 ...:cool:

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 :)

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 ...:cool:I HATE to bump an old post.. But how could this separate count be implemented??

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

Bringing this thread to life again. I there any way to get this working in v1.51?

the update of the products viewed count now appears to be in \classes\observers\class.products_viewed_counter.php as

function update(&$class, $eventID, $paramsArray = array())
  {
    if ($eventID == 'NOTIFY_PRODUCT_VIEWS_HIT_INCREMENTOR')
    {
      if (defined('LEGACY_PRODUCTS_VIEWED_COUNTER') && LEGACY_PRODUCTS_VIEWED_COUNTER == 'on')
      {
        global $db;
        $sql = "update " . TABLE_PRODUCTS_DESCRIPTION . "
                set        products_viewed = products_viewed+1
                where      products_id = '" . (int)$paramsArray . "'
                and        language_id = '" . (int)$_SESSION['languages_id'] . "'";
        $res = $db->Execute($sql);
      }
    }
  }
  }

I've added the spider_flag like so

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

but it has no effect on the view counter increment. No doubt something a little bit smarter is needed.