How can I programmatically update the _wc_average_rating meta field in WooCommerce?

user_1978921 0
Viewed 717

I'm building a WooCommerce website that has a custom review system. I want to show the same reviews for multiple products that are variations but have their own product page.

Still I want to be able to sort products based on their rating, so I want to programmatically update '_wc_average_rating' whenever a custom review is placed. Also the rich data markup is using these fields to populate the rich data markup.

I'm using the following code to update the meta values.

update_post_meta( 13566, '_wc_review_count', 4);
update_post_meta( 13566, '_wc_rating_count', 4);
update_post_meta( 13566, '_wc_average_rating', 5.00);

For the review and rating count it is working fine, but for the average rating it's not working.

I tried different things, like:

update_post_meta( 13566, '_wc_average_rating', 5.00); 
update_post_meta( 13566, '_wc_average_rating', 5); 
update_post_meta( 13566, '_wc_average_rating', '5.00');

How can I update the _wc_average_rating meta field? Is there a function to do this?

Thanks so much!

woocommerce wordpress php
2 Answers

I've tried the following code to verify your approach, and on my site its totally working. My average rating for my product 249 gets changed to 2:

add_action( 'init', function () {
    $product = wc_get_product( 249 );
    error_log( $product->get_average_rating( 'edit' ) );
    update_post_meta( $product->get_id(), '_wc_average_rating', 2.00 );
} );

If you check this image - my first rating set the average rating to 5 and I changed it with my code to 2:

enter image description here

So I really don't know what's not working on your site. I just can confirm that updating the average rating is possible the way I showed you.

Maybe you can show me the place where you execute your code. Sometimes this may be the problem.

user_105155030

My website is running WPML, and that plugin uses it's own 2 meta fields to sync rating/reviews across different languages. The meta fields are:

_wcml_average_rating
_wcml_review_count

So to update the rating in a WPML website, you need to update all these fields:

update_post_meta( $product->get_id(), '_wc_review_count', $count);
update_post_meta( $product->get_id(), '_wc_rating_count', $count);
update_post_meta( $product->get_id(), '_wcml_review_count', $count);
update_post_meta( $product->get_id(), '_wcml_average_rating', $rating);
update_post_meta( $product->get_id(), '_wc_average_rating', $rating);
user_19789210
Related