Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#1 12-22-2015 15:12:05
- CrownRoyal
- Member
- Registered: 01-10-2009
- Posts: 716
3 reviews but review summary says 2, why?
All three rows in the table ecom_reviews have status=1
One of the reviews I edited using Terminal command; UPDATE ecom_reviews ...
I've looked at all three and all look ok, data dump below (edited for privacy):
Code:
+-----------------------+-------------+--------+------------+---------------+--------+---------------+-------------+-------------------------------------------------------------------------+------------------------+------------+-----------+----------------------+ | id | epochreview | status | prodid | subject | rating | ratingquality | ratingvalue | review | reviewpros | reviewcons | nickname | email | +-----------------------+-------------+--------+------------+---------------+--------+---------------+-------------+-------------------------------------------------------------------------+------------------------+------------+-----------+----------------------+ | WC0005-1450810495 | 1420810495 | 1 | WC0005 | awesome! | 5 | 5 | 5 | Easy to follow. | great customer service | | Sharon W. | x1@email.com | | WC0005-1450852000 | 1450852000 | 1 | WC0005 | easy to build | 5 | 5 | 5 | product make it super easy | | | Barb J. | x2@email.com | | WC0005-1442501478 | 1442501478 | 1 | WC0005 | fun project | 5 | 5 | 5 | This makes an awesome Christmas decoration | | | Jack | x3@email.com | +-----------------------+-------------+--------+------------+---------------+--------+---------------+-------------+-------------------------------------------------------------------------+------------------------+------------+-----------+----------------------+
Offline
#2 12-23-2015 08:01:06
Re: 3 reviews but review summary says 2, why?
Use admin to flip the status on all three to off, then use admin to flip each on on. The summary uses a field in the ecom_prod table which is updated as you approve reviews.
Nick Hendler
Offline
#3 12-23-2015 08:04:41
- CrownRoyal
- Member
- Registered: 01-10-2009
- Posts: 716
Re: 3 reviews but review summary says 2, why?
ah, ok, I recall that field now in the ecom_prod. thanks.
Offline
#4 12-23-2015 22:59:58
- meshugy
- Member
- Registered: 12-18-2004
- Posts: 349
Re: 3 reviews but review summary says 2, why?
Is there anyway to bulk update all the review count and average ratings? I have hundreds of older reviews that were imported into CCP8 before the review count and average ratings fields existed. So those reviews aren't counted in the display. Is there anyway to bulk update these older reviews so that they are included in the current review count and average rating counts?
Offline