27 March 2012

Product Ratings Suite v1.6

A complete ratings package for your 1.4 PrestaShop store.

Allow customers/visitors to rate products. Add a BO Stats page and FO Block to show the best rated products.

- Ratings of Products in AJAX v0.97
- Best Rated Products BO Stats v1.2
- Best Rated Products FO Block v1.5
FREE Download
CHANGELOG:
v1.6 (2012-03-27)
[+] Added option to include Google Rich Snippets. (productrating)
v1.5 (2012-03-16)
[+] Added option to exclude products not available to order. (blockbestrated)
v1.4 (2011-07-14)
[*] Fixed missing quotes on database table name. (productrating)
v1.3 (2011-06-01)
[*] Moved included JS/CSS calls to header hook and added page recognition. (productrating)
v1.2 (2011-04-13)
[+] Added category related rated products when on product page. (blockbestrated)
v1.1 (2011-04-06)
[*] Fixed ratings for friendly urls. (productrating)
v1.0 (2011-03-27)
[+] First release of re-packaged 1.4 modules to the PrestaShop community.

104 comments:

  1. Hello,
    The module is really good. Thank you for the job.
    View the stars in the block would be ideal.
    Miguel

    ReplyDelete
  2. excell buddy keep it up.. can we also have the rating also displayed on front office.. that would be even cooler

    ReplyDelete
  3. installed this module in store prestashop version 1.3.2.3.
    Works ok in BO, but does not work on FO.

    FO in the store and does not display the following message appears:
    "Server error
    The website encountered an error while retrieving https: / /xxxx.com/ shop /. It May Be down for maintenance or configured incorrectly.
    Here are some suggestions:
    Reload this web page later.
    HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was Attempting to Fulfill the request. "

    ReplyDelete
  4. I installed the zip module but can't find the module to look at it... any ideas ?

    ReplyDelete
    Replies
    1. Hi,

      I have the same problem. please can you indicate in what section (hook) will appear?

      many thanx

      Delete
    2. There are three modules in this package. Two appear in "Front Office Features" and the other in "Administration" on your BO modules page.

      It is advisable to install the "Product ratings" module before the other two as this is the basis of the modification.

      Delete
    3. Hi, i'm a newbie here, i just start download prestashop yesterday. I would love to have your module added on my shop, i already installed the zip module , but still cannot find it anywhere in the "Front Office Features" and "Administration"

      I already search "blockbestrated" , "productrating", "statsbestratedproduct" but still can't find it. Please help me :) Thank you very much.

      Delete
  5. is it possible to show more than 2 pictures in the blockbestrated ? I configured it to see 5 products but only 2 pictures are visible, other products are in text mode.

    ReplyDelete
    Replies
    1. No, only two products show as per other similar default PS modules.

      Delete
  6. Your module works very fine!
    But I can just rate a product one time, when I take another account to rate again, It doesn't work! I can just post a comment but not rate... Why?
    Thanks

    ReplyDelete
    Replies
    1. Ratings use IP addresses to track who has rated, so you can only rate once (unless your IP changes).

      Delete
  7. Hi,

    Thanks for sharing!
    Is there a way to display the stars (rating) in the product-list...meaning where you browse for products?
    If there is no rating, just leave blank..

    Let me know what you think.

    Thanks,
    Eyal.

    ReplyDelete
    Replies
    1. Not at the moment, maybe in a future version this will be possible.

      Delete
  8. thank's for sharing :) good jobs

    ReplyDelete
  9. I would like to add product rate suite on my page. Now I would like to know that the above module version is compatible for prestashop version 1.4.4.1 or not.

    ReplyDelete
  10. Hi my name is Vladimir,

    and I must say that this module is great.
    I know, this module is only for product rating.
    But can I ask you, if is possible apply this module for manufacturer?

    My shop is about discount. It is discount e-shop. I have there sellers which sell own products only in discount or on sale.
    And I need make the rating for this sellers. Buyer can rate sellers. In prestashop I apply seller to manufacturer. Therefore I need actually rating for manufacturer.

    I hope, that I explain it right.

    Can you tell me please which way I must move to do this?
    What I must edit in your source to do this?

    Thank you for your answer

    Best Regards

    Vladimir
    killer_krajo@post.sk

    ReplyDelete
  11. hi
    I am shiv.

    I tried using this in prestashop 1.4.7 latest edition.

    After installation, it perfectly shows on the product detail page. Good job and great effort.

    But there is a slight issue for which i need your help.

    when I select the rating, it goes off again. What i mean here is, it is not preserving the rating i choose.

    Also, I have a list of icons showing up on the main home page. under that I want to show this rating. Please guide me how to do it. Kindly, help.


    Thanks
    Rgds

    Shiv

    ReplyDelete
    Replies
    1. Sorry mate, not sure why it's not working for you.

      Delete
  12. Hello,

    The module is really usefull. Works in 1.4.6.2. Thank you for share.

    One question, how to exclude from the ratings list those products, which are not available for order?
    Thanks

    ReplyDelete
    Replies
    1. An option to exclude products not available to order has been added to new 1.5 version.

      Delete
  13. Hi there,

    Thanks a lot for this awesome module, I was looking for this for a while now.

    The only thing I would like to do is to make this work with Google Rich Snippets.

    I know what classes I have to add, but I can't actually find the file where I need to edit them.

    For example I would like to change

    < div class="ratingblock" > to

    < div class="ratingblock" >< span class="item" >< span class="rating" >

    and all the rest which is needed for Google Rich Snippets.

    But I just can't find the tpl file where you write these out.

    Can you give me a hint please?

    Thanks a lot!

    ReplyDelete
    Replies
    1. Template code is created in modules/productrating/rating/_drawrating.php

      Delete
  14. Hi, tanks for this update ! we've just installed it but i get an error message when i go to a product page:
    "Error: SELECT command denied to user 'database_name'@'91.207.255.169' for table 'ps_ratings' " Did you already get this kind of error ? we use PS 1.5.1
    Thanks in advance, regards !
    Sune

    ReplyDelete
    Replies
    1. This modification is for PS 1.4.x. PS 1.5 is not yet stable enough for a production environment.

      Delete
  15. Thanks a lot! I have managed to update your module so now it supports Google Rich Snippets (ratings). If you want, I can send it to you so you can update it.

    Let me know.

    Thanks again for this great module!

    ReplyDelete
    Replies
    1. That would be great CyJambo !
      Regards,
      Sune

      Delete
    2. Thanks CyJambo, new version just uploaded has your code added. I've also added a BO admin switch to enable/disable GRS (as not everyone uses) and I fixed the ratings vote that was not showing in the template code. :)

      Delete
  16. Hi

    Super rating modul
    best regards

    Jean Philippe

    ReplyDelete
  17. once i activate the rating module, product page doesnt show anymore a make an error message.
    "Error: SELECT command denied to user 'ps1203_2'@'91.207.255.169' for table 'ps_ratings' "
    but the table is actually created in the DB, i have tried to put the names and adress in hard in _config-rating.php but is still get the same message. 1.4.5.1. I have no idea why
    If someboy got this issue, please let me know. Best regards, Sune

    ReplyDelete
    Replies
    1. In your config/config.inc.php file change:

      @ini_set('display_errors', 'off');

      to

      @ini_set('display_errors', 'on');

      Then post the error that is shown. Without errors as to what is causing your problem I do not know where to start looking for a solution.

      Delete
    2. Hi, thanks for your prompt reply, actually by setting the display_errors on, the message keeps same:
      Error: SELECT command denied to user 'p1203_2'@'91.207.255.169' for table 'ps_ratings'
      p1203_2 is the name of my wordpress database. so it seems the modules try to connect to the wrong database and fail because the logins are different.
      On install of the module the DB table ps_rating is created as it should, on PS database. I think the way is to force the module to connect to the right database ? i can send you my logs in PM if you need. Best regards, Sune

      Delete
    3. That's weird and a new one! It should be reading from the PS database. The module uses the same database information that PS uses. Very, very weird!

      Yes, send me login details via PS site and I'll see if there is something I can do to resolve it for you (and any others having the same problem)

      Delete
    4. Hi Zenith, just sent you a message. Yes it is very weird, _config-rating.php calls PS database, i dont get where it find the wordpress database because the names are different. Thks looking forward your answer. Best regards, Sune

      Delete
    5. Fixed Sune. Was due to a conflict caused by the Wordpress module you have installed. Ratings Suite module was not the problem. :)

      Delete
    6. Yes thats true ! Thanks so much for your help, as we de-activated it, we completely forgot about this one :-)) Thks again for your great work !

      Delete
  18. Re hello in the modul product rating the images did not post that comes from the file productrating-header.tpl line 5 I modified like this: background-image: URL (“. /modules/productrating/rating/stars/ {$star}”
    in place background-image: url('{$content_dir}modules/productrating/rating/stars/{$star}')
    best regards

    ReplyDelete
    Replies
    1. This code has not been an issue in the past. What version of PS are you using? Maybe the $content_dir variable is not defined in the version you are using.

      It is defined in the "classes/FrontController.php" file.

      Delete
  19. i install this module but site off,when uninstall it be ok,whats the problem? kvepinkis.lt

    ReplyDelete
  20. and not rulles how install this module step by step

    ReplyDelete
    Replies
    1. Instructions on installation are contained in the ~README file. Other than that it installs / uninstalls just like any other PS module from the BO.

      Delete
  21. thank you, this really good module, but where i can find related cotegory based on tag

    ReplyDelete
    Replies
    1. Sorry I don't understand what you are looking for...

      Delete
  22. Thanks for the module, just installed.
    I have a query.
    Why do some products are not the stars to vote?

    ReplyDelete
  23. this module worked in Version 1.3.3.0 ???? and if not what can i do who work it???

    ReplyDelete
  24. Thanks very much, i'll use in my shop. Great work

    ReplyDelete
  25. i install this module and it works fine,but when this rich snipets shows to google this stars?

    ReplyDelete
    Replies
    1. You can enable the Google Rich Snippets add-on from the BO Ratings Configuration page.

      Delete
  26. Hi. Is it possible to move it to move stars block to other hook. O just put the code in proper place in *.tpl?

    ReplyDelete
    Replies
    1. You could give it a try, just remember to backup your files before you make any code changes.

      Delete
  27. I added the module and prestashop say the module has been successfully added but I'm not able to find the downloaded module in the modules list. Can someone please help me figure out what has gone wrong.

    PS: I have done everything as said in the readme.

    ReplyDelete
    Replies
    1. Two modules are in the "Front Office Features" section, the other in the "Analytics & Stats" section.

      Delete
  28. module worked fine and show on google fine,but how to do show to product categories stars?

    ReplyDelete
  29. Hello, I'm podklonikom your module. I want to modify the rating for the producers but just starting to learn programming. Tell me how I do it.
    Thanks in advance for your reply.

    ReplyDelete
  30. ps_ratings database structure


    Paniced when installing u're great module for product rating and dropped the table.

    Would u please advice how it should look like when adding it manually?

    Thx a ton

    ReplyDelete
    Replies
    1. Just re-install the Product Ratings module from the PS BO to re-install the database table.

      Delete
  31. Yeah but it won't work so... It just says that the module can't be uninstalled/installed due to not being able to create table. Removing it and installing it completly says it's fine in BO. In FO it says the table is missing. Trying to restore module fails. So please table structure!

    ReplyDelete
    Replies
    1. Providing the table structure will not solve this installation error with the table. I need to check over the installation process.

      Delete
    2. I've just tested the installation and there are no issues with the table being installed when the module is installed via BO.

      After you install, check the database to see if the actual table (ps_ratings) exists.

      Delete
  32. I have checked and there is no table. I can install the module fine first time (but shows up active and installed), but on FO it says table is missing (which it is). Then when I try do de-install it fails. Repeating process just loops the scenario. So I'd say manually adding the table would solve the problem. Sinci I can't uninstall it couse it thinks there is table installed and it fails. And uploading it says it's still installed... So

    ReplyDelete
    Replies
    1. Un-installing removes the database table (if it exists).

      There must be a reason it won't install for you though. If you want PM me BO/phpMyAdmin/FTP details for the site in question via PS and I'll take a look myself.

      Delete
  33. Me puedes decir donde bajar el modulo, en Prestashop.com me dice error por favor
    gracias

    ReplyDelete
  34. Great Module. Would be awesome to finish the plan to implement the display in product-list.tpl and, like the criterions from productcomments-module, show the stars in the product comparison overview.

    anyway, GOOD WORK!

    ReplyDelete
  35. Tengo un problema, despues de instalarlo me surje este error en cada producto:

    Error: Table 'centrals_.ps_ratings' doesn't exist

    Alguien me puede ayudar , por favor?

    ReplyDelete
  36. Hi IE does not show the stars. Firefox and chrome shows fine. I clicked on stars to cast vote. It updated. But then it became not clickable. How do people change their vote?
    Thanks

    ReplyDelete
    Replies
    1. Stars show in IE for me. It is not possible to change a vote once it is cast.

      Delete
  37. I've modified the bestratedblock for our frontpage. Is it possible to show the stars as well?

    I can get the rating but I really want to know how to draw the result stars.

    ReplyDelete
    Replies
    1. Same problem I have trying to get stars to show on category page. I don't think it's possible to show the stars outside of the product page, at least nothing I could think of worked! If you have any success let me know and I'll finish off the category stars code.

      Delete
  38. Hi guys,

    Really great that you are contributing this, module is working, just have 2 points of attention
    1) after applying a while ago to have the rich snippets included in google serps, i got a mail recently that they dont show the rating anymore as it contains hidden content.

    main comment from google:
    ---

    HIDDEN MARKUPS
    Your content is marked up for rich snippets, but that content isn’t actually visible on the page itself. In general, Google won't display any content in rich snippets that human visitors can’t see.

    Here’s an example of the hidden content we found on your site:

    URL: http://www.pipeline-elektronische-sigaret.nl/nl/start-sets/38-ego-c-joyetech.html
    Markup Type: Review-aggregate, Shopping
    Hidden content:..<./.s.p.a.n.> <.d.i.v. property="gr:name" content="PIPELINE e-sigaret eGo-C" xml:lang="nl">
    ---

    I understand what they mean and why, now the getting this fixed part. Anyone able/willing to share some tips. hoping that based on some advise i could change the code to make it complaint (and of course share the result)

    Dave Walschot
    www.pipeline-elektronische-sigaret.nl
    info@pipeline-elektronische-sigaret.nl

    ReplyDelete
    Replies
    1. The GRS code was submitted by CyJambo so hopefully he may have a solution.

      Delete
    2. Dump, @Zenith is there any way we can reach CyJambo? We still havent re-applied at Google for including Rich snippets. Would be great if we can include these next to the goodrelations v1.4 by MakoLab S.A.

      Dave Walschot
      www.pipeline-elektronische-sigaret.nl
      info@pipeline-elektronische-sigaret.nl

      Delete
  39. Hello, one question, the stars are going to be displayed in Google?

    ReplyDelete
    Replies
    1. There is a configuration setting in the BO for the module to enable Google Rich Snippets, but if you read the post above it may not be working as it should.

      Delete
    2. No it wont definitly, all our rating have disappeared after the message from google about the hidden content.

      As a side note; now in Google webmaster tools there is also a section that details what rich snippets codes google is indexing from your site

      Delete
  40. Hi.

    Great module, but i neeed show rating stars in product-list.tpl. Its avialable?

    Also i need run module blockbestrated on prestashop 1.3.x. Maybe someone made this modification?

    Thnk for advice.

    ReplyDelete
    Replies
    1. At the moment ratings cannot be shown on category pages.

      Delete
  41. Hi,

    I have 1.4.8.3 prestashop version
    I have installated your module and changed product.php as you wrote but when I try to give a rate in a product, appear a waiting and dont save the rate.

    Can you help me? Thanks Andrea

    ReplyDelete
  42. Great Module !!! Works like a charm (hope category ratting will be avaible soon).
    Thank you very much for sharing. Prestashop community is amazing !!!

    ReplyDelete
  43. Hi, thanks for module! and little question: can we add 5 stars for all products in catalog?(in one moments)

    ReplyDelete
    Replies
    1. try this via phpMyAdmin:

      UPDATE `ps_ratings` SET `total_votes` = '1', `total_value` = '5' WHERE `id` > '0'

      Delete
    2. It works, thank a lot! for 7 votes: UPDATE `ps_ratings` SET `total_votes` = '7', `total_value` = '35' WHERE `id` > '0'

      Delete
  44. hi ,why i got error this

    Warning: This information will not appear as a rich snippet in search results, because it is contained in a hidden HTML element. Except in special circumstances, Google won't display content that is not visible to the user. You should mark up the text that actually appears to your users when they visit your web pages.

    ReplyDelete
  45. Hi, Does anyone know how to put the stars in the product-list.tpl?
    Thanks for this wonderful module

    ReplyDelete
  46. Hi. I neeed show rating stars in product-list.tpl. Its avialable? Thanks.

    ReplyDelete
  47. nice module, it work fine on PS 1.4.9.0 and on 1.4.6.2! thx a lot for sharing this.

    ReplyDelete
  48. Hi, is coming 1.5.x version also?

    ReplyDelete
  49. Can it work with 1.5.x with slight modification?

    ReplyDelete
  50. Hi Zenith,
    Thanks very much for your module, is perfect for improve SEO
    Do you plan to update this module to be compatible with PS 1.5.1 ??

    ReplyDelete
  51. Hi Zenith

    thanks for sharing. any plans for PS 1.5.17

    ReplyDelete
  52. Greate module, but in Google Structured Data Testing Tool I have error:
    "This information will not appear as a rich snippet in search results, because it is contained in a hidden HTML element. Except in special circumstances, Google won't display content that is not visible to the user. You should mark up the text that actually appears to your users when they visit your web pages."

    Anyone help me to fix this problem>

    ReplyDelete
  53. anything for Prestashop 1.5.3????

    ReplyDelete
  54. Can i use this module with snippets next to Goodrelations snippets module ?

    ReplyDelete
  55. You can fix this error "This information will not appear as a rich snippet in search results, because it is contained in a hidden HTML element. Except in special circumstances, Google won't display content that is not visible to the user. You should mark up the text that actually appears to your users when they visit your web pages." by editing productsrating.tpl file and change to ""
    But then there is penalty from google and "cloaking"
    Someone has to fix that soon...

    ReplyDelete
  56. Where i can turn on google rich snippet for this tool?

    ReplyDelete