display order weight

Hi,
is there a way to see the total weight of an order only on my backend?
Thanks

Hello,
To do that the solution will be to directly edit the code of the "show_products" file of the "Order" view of your back-end template via "Hikashop->Display->Views", note that some development skills will be required.

Hi,
but has the system the total weight already calculated?
If yes, what is the name of the variable?

Hi,

No it's not calculated, you will have to do a foreach on the products and increment a $weight variable for example and then display the value of this variable.

Hi,
like that it is too difficult for me.
But, why can not get the value of the shipping?
The system knows the weight because it has calculated the shipping cost.

Hi,

The fees are calculated in earlier based on the weight, etc. But the weight is not stored in the order, only the fees.
So the foreach is required in this case

Hi,
so, it is too difficult for me.
I hope that someone else ask you the same feature so that you can put it on your todo list!

Regards

needed it for something else, so just did the code

	$database = JFactory::getDBO();
    $query = 'SELECT a.order_product_quantity,b.product_weight FROM ' .
        hikashop_table('order_product') . ' as a LEFT JOIN ' . hikashop_table('product') .
        ' as b ON a.product_id=b.product_id WHERE order_id=' . $this->order->order_id .'';
    $database->setQuery($query);
    $rows = $database->loadObjectList();
    $weight = 0;
	foreach ($rows as $row) {
		$weight += $row->order_product_quantity*$row->product_weight;
	}

Jesper, thank you for providing this! Can you tell me where this code snippet goes? Does it go on a particular line in show_products.php, or somewhere else?

Thanks!

It should be able to be used anywhere you could need it... i used it in the backend to calculate the total wieght of the order to send the info with the shipping module to the postal provider.