Spotlight xstore widget showing the wrong number?

Hi @Nicolo,

The sale count function is coming from the WooCommerce plugin not from our custom code: wc_get_product_ids_on_sale();

After taking a look closer at the code, we could see that WooCommerce also count the sale of variation products:

		return $wpdb->get_results(
			"
			SELECT posts.ID as id, posts.post_parent as parent_id
			FROM {$wpdb->posts} AS posts
			INNER JOIN {$wpdb->wc_product_meta_lookup} AS lookup ON posts.ID = lookup.product_id
			$outofstock_join
			WHERE posts.post_type IN ( 'product', 'product_variation' )
			AND posts.post_status = 'publish'
			AND lookup.onsale = 1
			$outofstock_where
			AND posts.post_parent NOT IN (
				SELECT ID FROM <code>$wpdb->posts</code> as posts
				WHERE posts.post_type = 'product'
				AND posts.post_parent = 0
				AND posts.post_status != 'publish'
			)
			GROUP BY posts.ID
			"
		);

Please double check your variable products, it seems they’re on sale also.

Best Regards,
8Theme’s Team

Dear Nicolo,

We hope this message finds you well.

We would like to inform you that we have noticed a discrepancy in the count displayed under the Product Filter widget. As of now, there is no immediate fix available for this issue.

We have escalated this matter to our development team for further review and resolution. We will keep you updated on the progress and notify you once a solution has been implemented.

Thank you for your understanding and patience.

Best regards,
The 8Theme Team

Dear Nicolo,

We hope this message finds you well. I am writing to inform you that the AJAX feature is currently operational exclusively within the categories section. It has not yet been implemented in the following three filters: All Products, New Arrivals, and Sale.

For a clearer demonstration, please view our video at the following link: [https://www.awesomescreenshot.com/video/31169754?key=50c9e49c59060e9bec3b4a61ff98e21f](https://www.awesomescreenshot.com/video/31169754?key=50c9e49c59060e9bec3b4a61ff98e21f).

Thank you for your attention to this matter.

Best regards,
The 8Theme Team

Hi @Nicolo,

Can you please check again on the category images?

It might be the cache issue.

Best regards,
The 8Theme Team

Dear Nicolo,

We hope this message finds you well.

We would like to inform you that the Ajax filter is currently operational exclusively on the category images, as shown here: https://prnt.sc/le1DoBifvVRn.

To further enhance this feature, we kindly suggest that you consider submitting additional feature requests at the following link: https://8theme.upvoty.com/b/xstore/make-category-spotlight-ajaxrefresh-on-shop-page/.

Thank you for your attention to this matter. We look forward to your valuable feedback.

Best Regards,
The 8Theme Team

Dear Nicolo,

We hope this message finds you well. We kindly request that you review the URL stated when you clicked on each category image, as there appears to be an issue where all categories are combined when filtering the products. This functionality should mirror the product filter found on the left sidebar.

Thank you for your attention to this matter.

Best regards,
The 8Theme Team

Hi @Nicolo,

We meant the category items will combine when you click on each category.

This is the logic of Spotlight Categories Element is working for now.

We don’t have any custom codes to make it work as separated yet.

Best regards,
The 8Theme Team

Hi @Nicolo,

I see, will it stay like this?

Or are you working on it to filter separated?

We suggest you to add more comments to the feature request link so Jack can take a look on this.

And regarding the number issue, how is it going, what is the status?

Our development team is still working on it. Stay tuned.

Best regards,
The 8Theme Team