Skip to content

Instantly share code, notes, and snippets.

@bookchiq

bookchiq/get-woocommerce-product-reviews-pro-transient.sql

Created March 17, 2021 17:12
Show Gist options
  • Save bookchiq/9d2b68e4fcfe5537948f0b7541c56a71 to your computer and use it in GitHub Desktop.
Save bookchiq/9d2b68e4fcfe5537948f0b7541c56a71 to your computer and use it in GitHub Desktop.
Download ZIP
Force WooCommerce Product Reviews Pro to recalculate the number of reviews
Raw
get-woocommerce-product-reviews-pro-transient.sql
# The plugin relies on a transient for the review count, but it seems like it's not always current.
# See if there's a transient saved for post ID 1575 (then delete it to force the recalculation next time the count is displayed).
SELECT *
FROM `wp_options`
WHERE option_name = "_transient_wc_product_reviews_pro_review_count_1575";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment