Tickets created from Event are not properly counted in product category widget

[Gianpietro]

Hi,
I’m using woocommerce plugin and i placed the product categories widget on the right sidebar.
The widget displayes the number of items for each product category, but it seems it doesn’t work properly for tickets created by “The Event Tickets” plugin.

I created 4 “Event” (category) from woocommerce management and they are counted properly .
The 2 “Event” created with “The Event Tickets” plugin are not properly counted (see attached images).

Indeed, in class_wc_widget_product_categories.php the query is correct (see the attached query-result image), but the selection for the widget is from “wp_options” table and the insert is not correct:

INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_wc_term_counts’, ‘a:6:{i:10;s:1:\”3\”;i:11;s:1:\”4\”;i:17;s:1:\”0\”;i:12;s:1:\”1\”;i:13;s:1:\”5\”;i:14;s:0:\”\”;}’, ‘no’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

Do you have any idea to solve this malfunctioning?

Best regards,
Sara

[Brook]

Howdy Gian,

I would love to help you with this. I am not super familiar with the widget you’re using so I can not provide full support for it. But it seems likely that this widget is ignoring hidden products, which tickets are. You might want to manually edit the tickets to make them not hidden. From there, it seems very possible they will get counted and appear in the Woo store. Did that do what you needed?

Cheers!

– Brook

[Gianpietro]

Hi Brook,
great, you’re right!

Editing ticket to make them not hidden solved the issue.

Thank you.

[Brook]

Excellent! I am so happy that worked. Thank you for getting back.

Cheers!

– Brook

[Author]

Posts