how to reset the product popularity statistics

[Guest trevorrs]

Anybody know?

i dont see any obvious way of doing it so any help will be appreciated

Thanks

Trevor

[aPoLLo]

Hi Trevor,

Open the index.php file in the root of your shop directory and right at the end before the ?> put in this piece of code, upload the file, visit your shop, then go back and take these two lines out again before reuploading the file. Be very careful not to change anything else in this file as its rather important and remember to backup any files you make changes to.

Hope this helps you. It helped me.

$query = "UPDATE `CubeCart_inventory` SET popularity = '0' WHERE 1";

$db->misc($query);

Cheers

aPoLLo :)

[Guest evod]

Hi Trevor,

Open the index.php file in the root of your shop directory and right at the end before the ?> put in this piece of code, upload the file, visit your shop, then go back and take these two lines out again before reuploading the file. Be very careful not to change anything else in this file as its rather important and remember to backup any files you make changes to.

Hope this helps you. It helped me.

$query = "UPDATE `CubeCart_inventory` SET popularity = '0' WHERE 1";

$db->misc($query);

Cheers

aPoLLo

I have done this but its not working any ideas please

[Guest evod]

thanks sorted it now the above code does work i just had a space :yeahhh: