Magento – Passing sku code value to TrustPilot product review

magento-1.9sku

hope someone can help.

I'm trying to set up a 3rd party review platform (TrustPilot) for our Magento 1.9 CE store, using Ultimo theme. There is a product review box which will display individual product reviews on product pages. The code to display this box looks pretty simple, but it requires us to add the variable for the product sku and product name.

Here's the code (I've added in capitals where the two bits of data need to go);

<!-- TrustBox widget --> <div class="trustpilot-widget" data-locale="en-GB" data-template-id="5717796816f630043868e2e8" data-businessunit-id="51cd30a800006400054f735a" data-style-height="700px" data-style-width="100%" data-theme="light" data-sku="MY SKU CODE GOES HERE" data-name="MY PRODUCT NAME GOES HERE"> <a href="https://uk.trustpilot.com/review/valueincontinence.co.uk" target="_blank">Trustpilot</a> </div> <!-- End TrustBox widget -->

This code works fine if I hard code in the actual SKU (i.e. H12345). I was expecting to be able to replace the 'MY SKU CODE GOES HERE' with something like;

<?php echo $_product->getData('sku') ?>

…but that doesn't work.

I first tried this from the admin backend CMS in a custom block/tab – if I hard code sku, it works fine, if I try anything else, the code still works, but doesn't show any of the product related reviews/details which is should (i.e. it just looks like the product has no reviews).

I thought this might be something to do with custom blocks needing something else, so I tried it just on the main product description page (i.e. not in a custom block/tab) but still no joy.

I also tried creating a phtml file seperately, but couldn't get that to work either. Have looked through lots of posts about calling variables in other scenarios, here and elsewhere, but still no joy.

I'd really appreciate any suggestions.
Many thanks,
Bill

Best Answer

I had trouble with this also for the product pages so made the following code to get the sku and name to fill in the gaps for data-sku and data-name in the Trustbox dynamically for each product page. It works on products pages not sure if will work for catalog and search results.

<?php
$current_product = Mage::registry('current_product');
if($current_product) {
    $_sku = $current_product->getSku();
    $_name = $current_product->getName();
   }
?>
<!-- TrustBox widget - Product Reviews MultiSource SEO -->
<div class="trustpilot-widget" data-locale="en-GB" data-template-id="XXXXXXXXXXXX" data-businessunit-id="XXXXXXXXXXXX" data-sku="<?php echo $_sku?>" data-name="<?php echo $_name ?>">
<a href="https://trustpilot.com/review/YOURDOMAIN" target="_blank" rel="noopener">Trustpilot</a>
</div>
<!-- End TrustBox widget -->

Related Solutions

Magento – Magento get reviews filtered by product

There's nothing wrong with the posted code. I've checked it against 1.9.1.0 with sample data and using productId 337. I get a count of 6 each time and have been trying to break it, unsuccessfully (test script is below).

That means the error is in the code that you're not showing: the actual count() in the template file.

Test code used:

<?php
require_once('app/Mage.php');
Mage::app('default');
umask(0);
Mage::setIsDeveloperMode(true);
if( extension_loaded('xdebug') )
{
    ini_set('xdebug.cli_color', true);
    ini_set('xdebug.var_display_max_data', -1); // unlimited
}
$productId = 337;
$reviews = Mage::getModel('review/review')->getCollection()
    ->addStoreFilter(Mage::app()->getStore()->getId())
    ->addEntityFilter('product', $productId)
    ->addStatusFilter(Mage_Review_Model_Review::STATUS_APPROVED)
    ->setDateOrder()
    ->addRateVotes();

echo((string)$reviews->getSelect().PHP_EOL);
var_dump(count($reviews->getItems()));
var_dump($reviews->count());
echo(str_repeat('-', 80).PHP_EOL);
/** @var Mage_Review_Model_Review $review */
foreach($reviews AS $review)
{
    /** @var Mage_Rating_Model_Resource_Rating_Option_Vote_Collection $votes */
    $votes = $review->getRatingVotes();
    $total = 0;
    foreach($votes AS $vote)
    {
        $total += $vote->getPercent();
    }
    $avg = $total / count($votes);
    var_dump($total, count($votes), $avg);
    echo(PHP_EOL);
}

Magento 1.9 – Product Star Ratings Summary Not Displaying in Every Store View

I solved this by creating a new review/helper/summary.phtml template file in our custom theme and updated the code to:

<?php
$reviewSummary = Mage::getModel('review/review_summary');
$storeStructure = Mage::getSingleton('adminhtml/system_store')->getStoresStructure();
$productId = $this->getProduct()->getId();
$avgRating = 0;
$cumulativeRating = 0;
$storesWithRatings = 0;
foreach($storeStructure as $websiteStructure){
    foreach($websiteStructure[children] as $storeInfo){
        $storeID = $storeInfo[value];
        array_push($storeIds,$storeID);
        $currentRating = $reviewSummary->setStoreId($storeID)->load($productId)->getRatingSummary();
        if ($currentRating) {
            $storesWithRatings++;
        }
        $cumulativeRating = $cumulativeRating + $currentRating;
    }
}

if ($cumulativeRating && $storesWithRatings) {
    $avgRating = $cumulativeRating / $storesWithRatings;
}
?>
<div class="ratings">
    <?php if ($avgRating):?>
        <div class="rating-box">
            <div class="rating" style="width:<?php echo $avgRating ?>%"></div>
        </div>
    <?php endif;?>

This code is iterating over an array of each of the stores, getting the rating score for each of the products and putting the average rating from each of the stores into a variable called $avgRating.

A drawback to this approach is that even if a review is not visible in the current store view, it's rating will be added to the avgRating.

I think that in Magento when you set a review to be visible in a store view, the same should be applied to the ratingSummary.

Similarly, to have the star ratings to appear on the review itself no matter what the store view I followed this approach: https://magento.stackexchange.com/a/17731/6549

Best Answer

Related Solutions

Magento – Magento get reviews filtered by product

Magento 1.9 – Product Star Ratings Summary Not Displaying in Every Store View

Related Topic