List of items ordered

-- HikaShop version -- : 4.0.0
-- Joomla version -- : 3.8.12
-- PHP version -- : 7.2

Hi,

is it within Hikashop possible to create a overview of all items and their quantities being sold?

Example

articlenr name size quantity sold
12345 blue shirt L 10
54321

Hi,

Yes. You can go in the menu System>Mass actions, create a new mass action with the action "display the values" and in the columns you can select product_code, product_name, product_quantity, product_sales and the characteristics.

Thanks, that helps

would it also be posibble to count the values together ?

It now shows:

order_product_code	order_product_name	order_product_quantity
12345_3	Poloshirt: L	2
12345_4	Poloshirt: M	1
12345_3	Poloshirt: L	1

where i would want to have

order_product_code	order_product_name	order_product_quantity
12345_3	Poloshirt: L	3
12345_4	Poloshirt: M	1

Hello,

Your issue is coming from the fact that you have set the "Data" option of your mass action to "Order" instead of "Product", after you change the value of that option, you'll just have to follow Nicolas instructions :

mass action with the action "display the values" and in the columns you can select product_code, product_name, product_quantity, product_sales and the characteristics.

Kind regard,
Mohamed Thelji.

Hi,

when setting the data option to Product it shows like

product_code	product_name	product_sales	size
12345	Poloshirt	2	S
12345_4		1	M
12345_2		1	XL
12345_3		4	L

the product name is only showing for the first item and disadvantage of this is that also orders which are pending or cancelled are included

Guess the view how I want it isn't possible without changing code.

Hi,

The sales are counted when the stock is incremented/decremented. So the status of the orders being taken into account depends on how the order statuses are configured for the "invoice" column in the System>Order statuses menu and the option "Update the product stock on confirmed status" of the HikaShop configuration. Note however that the sales already counted won't be affected by changing these, it would only affect new orders.
Regarding the product_name being empty, that's probably because you didn't set any name in each variant of the product.

While you can do many things in different ways, your case is quite specific and it is indeed touching on the edges of what's possible by default.
You could also use the order data like you had before, export it instead of displaying it and then open it in Excel and sum the elements with the same names with a small excel script. That way, you would have an easier control on the data as the quantities taken into account would be dynamically retreived from the orders and not an accumulation of the sales updated each time an order would be placed or paid.