bling007

Basically, if I understand it correctly, my requirement is to add TAX and GROSS SALES column under Analytics > Products.

Please refer the screenshot: https://prnt.sc/128tee7

wooptpm_get_cart_items is causing massive lag on page loads. Any fix possible?

Caching PLugin: wp-rocket.

• This reply was modified 5 years, 1 month ago by bling007. Reason: Caching

Yes. Unless the plugin name has changed. I have been trying many plugins for years. This is a new trial.

Switched from: https://wordpress.org/plugins/woocommerce-conversion-tracking/
Tried before: https://wordpress.org/plugins/woocommerce-google-dynamic-retargeting-tag/

Also currently installed and running: https://wordpress.org/plugins/woocommerce-google-analytics-integration/

Above does enhanced e-commerce tracking.

Great question. It did happen on the first save. Though it was ignored.
Now, it has happened on a later save. So reported.

Caching issue. Resolved.

I reverse my comment, after saving the filter again – it seems to get fixed. Will test more cases.

In my case, it was related to REST API plugin. Once I disabled it, the problem was resolved. I do understand the frustration this can cause, but avoid the temptation to touch the code or database.

Additionally, it always helps to know what plugin was the last on the update. Usually, it is the culprit. If not, then you need to disable all plugins except WC and start activating one by one till u notice the issue.

Thanks, Michael. You are correct, this solution is for Woocommerce (as per the question). I use a modified version that directly modifies the query. I provided the is_product() method to avoid conflict with page/post_types != product.
Assuming we still want to use the original plugin logic on other pages.

When it comes to suggesting related products, it does not matter how many are suggested as long as they are related. So for this case, I simply increased the number to 50, which easily gives me 20+ products. Pretty great in my view.

I would really not suggest excluding products before the query. Since products keep getting back instock and going outofstock, its better to rebuild cache and show as per the related-post’s stock status. It also saves the server’s resources.

However, no e-commerce store or requirement is similar. This solution does help majority of the cases.

function yarpp_custom_wp_query($query) {
	if(isset($query->yarpp_cache_type)){
		$query->set('post_type', 'product');
		$meta_query = [
			'relation' => 'AND',
			[
				'key' => '_stock_status',
				'value' => 'instock',
				'compare' => '=',
			]
		];
		$query->set('meta_query', $meta_query);	
	}
	
	return $query;
}
add_filter('pre_get_posts', 'yarpp_custom_wp_query', 100);

The above will not consider if the page is the product page.