[Resolved] Woocomerce get total money spent on products

[Author]

Posts

[SteffenM1628]

Tell us what you are trying to do?

Hey there i am experimenting with woocomerce and i wonder if this is possible.
I have a user and the user can make a CPT. on this custom post type he can make products. The products are related to the CPT.
This works fine for me. Now the tricky part.
Now i want to show on the Custom post type for that user multiple things:

1. a total sum of the money he made from all his products. (like an addup from all product prices of the sold products)
2. orderdetails (Name, zipcode, adress...) from all orders to his products.
3. the total number of sold products from him. (like he sold 2 from product A and 4 of product B = 6 items in total)

Maybe there is a possibility in building a shortcode from a wpquery e.g. for 1. & 3?
Hope this is makeable!
Thank you.

[Minesh]

Hello. Thank you for contacting the Toolset support.

There is no native feature available for the options you shared.

You will require to add custom shortcode that should return the total sum.

Please check the following link that may help you:
1. a total sum of the money he made from all his products. (like an addup from all product prices of the sold products)
- https://stackoverflow.com/questions/30979770/how-to-get-total-sum-of-orders-by-a-user-in-woocommerce

3. the total number of sold products from him. (like he sold 2 from product A and 4 of product B = 6 items in total)
- hidden link
- https://docs.woocommerce.com/document/product-sales-count/