ProductCart Shopping Cart Software Forums : Converting Reviews from Image to Numerical Values https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 06:36:11 +0000 Mon, 23 Sep 2013 23:09:37 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=5664 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Converting Reviews from Image to Numerical Values : Thanks, Lindsay.I still haven&#039;t...]]> https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21619.html#21619 Author: Guests
Subject: 5664
Posted: 23-September-2013 at 11:09pm

Thanks, Lindsay.

I still haven't had the time to hash through exactly how PC is calculating/storing this value as it appears rather situational.

I any event, the code block I suggested above can be tamed to one decimal place by replacing:
<%=pcv_tmpRating%>
with:
<%=FormatNumber(pcv_tmpRating,1)%>

Looks like there's logic elsewhere to have that come out to either N or N.5, mostly for rendering the graphic representation. Not sure how important (or even desirable) it is to have the numeric representation render the same way, though.
]]> Mon, 23 Sep 2013 23:09:37 +0000 https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21619.html#21619 <![CDATA[Converting Reviews from Image to Numerical Values : Just a note on the code above,...]]> https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21617.html#21617 Author: Lindsay
Subject: 5664
Posted: 23-September-2013 at 4:25pm

Just a note on the code above, when I play with it on a product with a large number of reviews, pcv_tmpRating no longer rounds to the second decimal point. In the case of one popular product, this displayed: (4.82352941176471/5) based on 17 customer ratings


]]> Mon, 23 Sep 2013 16:25:11 +0000 https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21617.html#21617 <![CDATA[Converting Reviews from Image to Numerical Values : Thanks Sean for sharing that code,...]]> https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21604.html#21604 Author: Lindsay
Subject: 5664
Posted: 18-September-2013 at 11:13am



Thanks Sean for sharing that code, I will try inserting it later today and see if I can get it working for me.

My understanding is simplistic, I'm sure, but I believe I have added all the necessary schema product markup via editing viewPrdCode.asp and prv_increviews.asp, though I'm still trying to work out a few errors that show when I use google's Structured Data Testing Tool

I'm Interested in the fix for duplicate title tag, duplicate meta description tag with review pages, how much to purchase? I want to say EI already helped me with the canonical URLs issues, I'd have to check back in emails but I remember it was causing issues creating a sitemap and seems like we worked out a fix..
]]> Wed, 18 Sep 2013 11:13:55 +0000 https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21604.html#21604 <![CDATA[Converting Reviews from Image to Numerical Values : Hi Lindsay,Well, maybe not so...]]> https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21602.html#21602 Author: Guests
Subject: 5664
Posted: 17-September-2013 at 11:11pm

Hi Lindsay,

Well, maybe not so perfect after all.

Knowing that you are working on structured data/schema.org markup (which I am too), my quick edit above is way too down and dirty for that, and now that I look at the full implications of it, rather unsightly -- The numeric value will display next to everywhere the icons are called (via the WriteStar subroutine), including on each individual review. 

That, I think, makes it unsightly.

More to the point for structured data/schema.org markup, though, it's not practical: this sub can't be used to markup the aggregateRating properties, else they will recur over an over again.

The better solution is to append some code to the end of the pcs_ShowRating subroutine in viewPrdCode.asp and/or on prv_increviews.asp and then again on prv_allreviews.asp. 

Here's a rough on what that code would look like, though I would abstract this out to a subroutine called in each of these instances. In each of these files, find something like:
END IF 'Main Rating %>
(white space varies a bit in each file)
Just after that, add:
					<%
					query = "SELECT COUNT(pcRev_IDReview) AS revCnt FROM pcReviews WHERE (pcRev_IDProduct = "& pIdProduct &") AND (pcRev_Active = 1);"
					set rsTemp = connTemp.execute(query)
					if NOT rsTemp.eof then
					%>
					<span id="aggregateRating" itemprop="aggregateRating" itemscope itemtype="http://schema.org/AggregateRating">(<span itemprop="ratingValue"><%=pcv_tmpRating%></span>/<%=pcv_MaxRating%>) based on <span itemprop="reviewCount"><%=rsTemp("revCnt")%></span> customer ratings</span>
					<%
					end if
					set rsTemp = NOTHING
%>
My preference would be to add it on prv_increviews.asp (rather than viewPrdCode.asp -- so's not to have this twice on the product page AND so's not to clutter up the top of the product page data with it) and then again on prv_allreviews.asp

Here's an example (WARNING: wear a hardhat -- work in progress) with this in all three locations:
http://pc47a-wms-net.3060.wmsmerchantservices.com/store/pc/viewPrd.asp?IDProduct=1&IDCategory=2

Hope this helps you out better.

Meanwhile, lots of structured data stuff to do regarding the reviews themselves on both product pages and the "all reviews" page for a product (along with other SEO issues with the latter including duplicate title tag, duplicate meta description tag, bad canonical URL tag, etc. -- issues I've already solved if you are interested).
]]> Tue, 17 Sep 2013 23:11:46 +0000 https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21602.html#21602 <![CDATA[Converting Reviews from Image to Numerical Values : PERFECT! Thank you Sean! ]]> https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21585.html#21585 Author: Lindsay
Subject: 5664
Posted: 10-September-2013 at 5:34pm



PERFECT! Thank you Sean!]]> Tue, 10 Sep 2013 17:34:04 +0000 https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21585.html#21585 <![CDATA[Converting Reviews from Image to Numerical Values : If you only want the numeric value...]]> https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21583.html#21583 Author: Guests
Subject: 5664
Posted: 10-September-2013 at 2:47pm

If you only want the numeric value to show on product pages, you could change
response.write Rev_SaveRate
to
if pcStrPageName = "viewprd.asp" then response.write Rev_SaveRate
or perhaps this is a bit nicer display:
if pcStrPageName = "viewprd.asp" then response.write "(" & Rev_SaveRate & "/5)"


Edited by Sean@WMS - 10-September-2013 at 2:52pm]]> Tue, 10 Sep 2013 14:47:50 +0000 https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21583.html#21583 <![CDATA[Converting Reviews from Image to Numerical Values : Great- but is there a way to hide...]]> https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21577.html#21577 Author: Lindsay
Subject: 5664
Posted: 08-September-2013 at 1:26pm


Great- but is there a way to hide that number on listings in search results?
]]> Sun, 08 Sep 2013 13:26:54 +0000 https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21577.html#21577 <![CDATA[Converting Reviews from Image to Numerical Values : In pc/prv_incfunctions.asp find...]]> https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21489.html#21489 Author: Hamish
Subject: 5664
Posted: 06-August-2013 at 6:21pm

In pc/prv_incfunctions.asp find the following two lines and uncomment the second one :-

            ' Uncomment the following line to show the text value (e.g. "3.5")
            ' response.write Rev_SaveRate

]]> Tue, 06 Aug 2013 18:21:09 +0000 https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21489.html#21489 <![CDATA[Converting Reviews from Image to Numerical Values : Since ProductCart&#039;s latest...]]> https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21409.html#21409 Author: Lindsay
Subject: 5664
Posted: 09-July-2013 at 6:49pm



Since ProductCart's latest release doesn't include structured data markup or the option to add metadata into product pages, I'm trying to use Google's Structured Data Markup Helper to add this information manually.

It appears that Google's tool is not able to recognize and convert productcart's stars, empty stars, and half stars to a numerical value- so I'm looking for a way to display a numerical value/aggregate score next to (or even instead of) the stars that are just under the product title, on the main product page.  Any suggestions?
]]> Tue, 09 Jul 2013 18:49:50 +0000 https://forum.productcart.com/converting-reviews-from-image-to-numerical-values_topic5664_post21409.html#21409