Does Products Reviews and Data Structure interfere with each other?

[TamyA]

Try this version of the file:
https://github.com/torvista/Zen_Cart...tured_data.php

Hi Steve,

I renamed the old file and added the new one insteated, i also got the reviews code that i added to the tpl_product_info_display.php to it is original code commenting the new hacks and uncomenting some of the code i added and it is working correctly on the number of reviews, it shows exactly the reviews for that product, it is not doubling up the reviews.
However,

 "aggregateRating": {    "@type": "AggregateRating",    "ratingValue": "0",    "reviewCount": "3"

the ratingValue shows 0 insted of the total of the stars for the reviews

[TamyA]

the ratingValue shows 0 insted of the total of the stars for the reviews

the ratingValue shows 0 insted of the total of the stars divided by the number of the reviews

[torvista]

Try again, same file location.

I assume the reviews are shown in the head, just the aggregate was wrong.

[TamyA]

Try again, same file location.

I assume the reviews are shown in the head, just the aggregate was wrong.

Yes you are correct.

Still showing the same thing

"aggregateRating": {
"@type": "AggregateRating",
"ratingValue": "0",
"reviewCount": "3"

the old file shows it this way

    if (!$reviews->EOF) {
        foreach ($reviews as $review) {
           $reviewsArray[] = [
                'id' => $review['reviews_id'],
                'customersName' => $review['customers_name'],
                'reviewsRating' => $review['reviews_rating'],
                'dateAdded' => (!empty($review['date_added']) ? $review['date_added'] : PLUGIN_SDATA_REVIEW_DEFAULT_DATE), // $review['date_added'] may be NULL
                'reviewsText' => $review['reviews_text']
            ];
            $ratingSum += $review['reviews_rating']; // mc12345678 2022-07-04: If going to omit this review now or in the future, then need to consider this value.
        }
        $reviewCount = count($reviewsArray);
        $ratingValue = round($ratingSum / ($reviewCount), 1);
    }

and the new file shows it this way

if ($is_product_page || $current_page === 'product_reviews') {
    $ratingSum = 0;
    $ratingValue = 0;
    $reviewCount = 0;
    // $reviewsArr may already have been loaded on product_review page or on product_info page
    if (count($reviewsArr) === 0) {
        $reviewQuery = 'SELECT r.reviews_id, r.customers_name, r.reviews_rating, r.date_added, r.status, rd.reviews_text
                FROM ' . TABLE_REVIEWS . ' r
                LEFT JOIN ' . TABLE_REVIEWS_DESCRIPTION . ' rd ON rd.reviews_id = r.reviews_id
                WHERE products_id = ' . (int)$_GET['products_id'] . '
                AND status = 1
                AND languages_id= ' . $_SESSION['languages_id'] . '
                ORDER BY reviews_rating DESC';
        $reviews = $db->Execute($reviewQuery);


        if (!$reviews->EOF) {
            //reviews found
            foreach ($reviews as $review) {
                $reviewsArr[] = [
                    'id' => $review['reviews_id'],
                    'customersName' => $review['customers_name'],
                    'reviewsRating' => $review['reviews_rating'],
                    'dateAdded' => (!empty($review['date_added']) ? $review['date_added'] : PLUGIN_SDATA_REVIEW_DEFAULT_DATE), // $review['date_added'] may be NULL
                    'reviewsText' => $review['reviews_text']
                ];
                $ratingSum += $review['reviews_rating']; // mc12345678 2022-07-04: If going to omit this review now or in the future, then need to consider this value.
            }
            //reviews NOT found
        } elseif (PLUGIN_SDATA_REVIEW_USE_DEFAULT === 'true') {
            $reviewsArr[0] = [
                'id' => 0, // not used
                'customersName' => 'anonymous',
                'reviewsRating' => (int)PLUGIN_SDATA_REVIEW_DEFAULT_VALUE,
                'dateAdded' => $product_date_added,
                'reviewsText' => ''
            ];
            $ratingSum = (int)PLUGIN_SDATA_REVIEW_DEFAULT_VALUE;
        }
    }
    $reviewCount = count($reviewsArr);
    $ratingValue = round($ratingSum / $reviewCount, 1);
}

[torvista]

Try again, added some debug info that displays in the Console.

[TamyA]

Try again, added some debug info that displays in the Console.

"aggregateRating": {
	"@type": "AggregateRating",
	"ratingValue": "0",
	"reviewCount": "2"

<script>console.debug("$reviewCount=2, $ratingValue=0");</script><script title="Structured Data: schemaOrganisation" type="application/ld+json">

[torvista]

You should be getting something like this in the console:


I've added even more logging..try again!

[TamyA]

<script>console.debug("691: $reviewCount=3, $ratingValue=0");</script>

"aggregateRating": {


    "@type": "AggregateRating",


    "ratingValue": "0",


    "reviewCount": "3"


  },

I am not sure why it is doing that to me, i think i will stay with the hacked code since it is doing what i want. Thanks Steve.

[torvista]

You posted the Rich Results tool results (that do not show any info), instead of the browser developer tools Console messages, where the debugging output was shown.
Shame to give up, there is always a solution.

[TamyA]

You posted the Rich Results tool results (that do not show any info)

Yes it does, the whole problem is the RatingValue, it is showing 0 and that is wrong, it should be 15 (the total of ratings for the 3 reviews)

instead of the browser developer tools Console messages, where the debugging output was shown.

I do not follow you.

Shame to give up, there is always a solution.

I never give up it just i have too many things on my plate and i have to balance the load.