Woocommerce Order View Displays all orders

This support ticket is created 5 years, 6 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

Tagged: Views, Views plugin

This topic contains 3 replies, has 2 voices.

Last updated by Luo Yang 5 years, 6 months ago.

Assisted by: Luo Yang.

Author

Posts

June 18, 2019 at 9:28 pm #1272033

Nicholas

Hello I am trying to display orders on the product page that belong only to that particular product. I am trying do that with a toolset view. For some reason I can't show only the orders to that belong to that partucular product. Instead all orders are shown. Any idea why?

June 19, 2019 at 3:56 am #1272195

Luo Yang

Hello,

There isn't such a built-in feature within Toolset plugins, since Woocommerce plugin is using a custom database table "wp_woocommerce_order_itemmeta" to store the product ID for order post, it is out the range of Toolset or even WordPress range.

In your case, you might consider custom codes, I have searched it in google, and found this thread:
https://stackoverflow.com/questions/45848249/woocommerce-get-all-orders-for-a-product

For your reference.

June 19, 2019 at 5:31 am #1272231

Nicholas

Thanks,
what about this?
[wpv-conditional if="( wpv_woo_product_belongs_to_this_order() eq '1' )"]

June 19, 2019 at 8:16 am #1272381

Luo Yang

The wpv_woo_product_belongs_to_this_order() is a PHP function, you can follow our document to setup the [wpv-conditional] shortcode:
https://toolset.com/documentation-category/woocommerce-views/
section "Displaying customers associated with WooCommerce orders"

But I don't think it is a good idea, since that post view, will query all order posts each time, and then in the loop display the items by [wpv-conditional] shortcode, if there are lots of order posts in your website, it will conduct the performance problem.