Skip Navigation

[Resolved] Ordered Item Quantity in Views

This thread is resolved. Here is a description of the problem and solution.

Problem: I would like to use Views to display a list of WooCommerce Orders, the Products in each Order, and the prices and quantities of each Product.

Solution: You can use Views to create a list of Orders and the Products in each Order, but prices and quantities of each Product will require custom code.

Relevant Documentation:
https://toolset.com/learn/create-an-ecommerce-wordpress-site/displaying-more-information-from-woocommerce/how-to-display-woocommerce-orders-on-the-front-end/#how-to-display-ordered-products-when-listing-orders

This support ticket is created 6 years, 4 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
8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 - -
13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 - -

Supporter timezone: America/New_York (GMT-04:00)

This topic contains 4 replies, has 3 voices.

Last updated by Christian Cox 6 years, 3 months ago.

Assisted by: Christian Cox.

Author
Posts
#1072626
Order-Template-Missing-Info.png
Order-Template-Good.png

Hi,
I have created an Order Template to view the order and possibility to print it.
I want to show the quantity of every product in the invoice list but cant find a way to do so...

tried to follow this but not sure it does what i need:
https://toolset.com/forums/topic/display-woocommerce-order-number-shipping-address-and-ordered-products-quantity/

Order link: hidden link

is there a way to show the item quantity number ? and then maybe make quantity * Price = Total Product Price

By the Way please send a Screenshot of following to Amir:

I think this is the best Support ever and i feel we need to find a way that we customers, have the option after support ticket is resolved, to give a (tip) if we would like to, through PayPal for example. part of it goes to the Support Team and Part of it goes to the person who solved the Issue... maybe this sounds funny but i am indeed serious about it! ?

#1073404

This is the solution:
https://toolset.com/learn/create-an-ecommerce-wordpress-site/displaying-more-information-from-woocommerce/how-to-display-woocommerce-orders-on-the-front-end/#how-to-display-ordered-products-when-listing-orders

It is not intended to custom code this, instead Toolset offers a set of features to customize and display WooCommerce data.
They are limited, but powerful.

Toolset doesn't aim you to write PHP code.
Usually, we do not support this, especially, such code does not use any Toolset API.
I understand your last comment you ask me to forward as well in this light.
Usually, we should instead refer to contractors when Custom Code is required.
You already pay for Toolset Support, and would not need to spend money on us for such help.

However, can you let me know if the solution added in the above shared DOC, which allows you do display ordered Products, when you list orders, solves the requirements?

#1073415

I actually followed the instructions on the page you have sent me. this is already done and showing all ordered products here: hidden link

what i am trying to do is when admin want to see one of the orders he clicks on the eye icon then he should see the order details like screenshot i sent before (lets call it invoice page). to show this page i have created a single order Template with Layout.

on this invoice page i would like to show the Items that have been purchased in that specific order. (normally WooCommerce would show you Screenshot : Ordered-Items.png)

now to show this information in the invoice page i have created a view listing all Items that has been purchased in one specific order. this give me a listing result show the custom image of the item and name and price of the product.

so here already i have noticed i actually did something wrong. in the ordered product views i am showing the also the product price and this not right. because once the product price changes then it will change in the invoice page. so actually i need to pull the items information like screenshot "Ordered-Items.png".

So what i need is to show on the invoice page is following : Item Name / Cost / Qty / Total. like (Ordered-Items.png) but on the frontend.

#1073459
Ordered-Items.png

forgot to attach the image.

#1074376

Hi, display of WooCommerce Order information is limited in Toolset because WooCommerce Orders are not public post types. You can display a list of Orders and a list of Products in each Order, but there is not an easy way to display information about the prices and quantities of each Product in the Order. That would require custom code using the WooCommerce API. A skilled developer might be able to help you set up something like that. You can connect with independent contractors in our portal here: https://toolset.com/contractors