How to fix menu counts?
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page pleaseIf you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
Please see https://midwesttread.com/ and click on Search Tires, then under Tire Brand, scroll to the bottom and see the option: YOKOHAMA (337). All Yokohama products are out of stock, so 337 should be zero. How do I ensure all counts of all types are updated correctly?
I've clicked all the regenerate look-up tables, and the similar option is the admin cleared the caches. I've also run the following queries:
UPDATE wp_term_taxonomy AS term
JOIN taxonomy_cnt_vw tax_vw
ON term.term_taxonomy_id = tax_vw.term_taxonomy_id
SET term.count = IFNULL(tax_vw.cnt,0)
WHERE term.taxonomy = 'product_cat'UPDATE wp_term_taxonomy AS term
JOIN taxonomy_cnt_vw tax_vw
ON term.term_taxonomy_id = tax_vw.term_taxonomy_id
SET term.count = IFNULL(tax_vw.cnt,0)
WHERE term.taxonomy = 'pa_tire-brands'
This is the related view:
CREATE VIEW taxonomy_cnt_vw AS
SELECT posts.term_taxonomy_id AS term_taxonomy_id,
SUM(`meta`.`meta_value`) AS `cnt`
FROM
(wp_postmeta meta
JOIN wp_term_relationships posts)
WHERE meta.meta_key = '_stock'
AND meta.post_id = posts.object_id
GROUP BY posts.term_taxonomy_id
Hello
Please paste your license key here - https://share.pluginus.net/image/i20210618130558.png -> https://share.pluginus.net/image/i20210618130614.png
Update the plugin to latest version - https://products-filter.com/how-to-make-auto-update-for-wordpress-plugins-and-themes-bought-on-envato