Category display in order's at admin panel

Hello, i need to display a product category in orders at admin panel, already tryed a lot of code, but still doesnt work How to do it? Thanks.

Hi there,

First you have to load the categories because they are not present in this form. Just add this code:

foreach($this->order->products as $k => $product){
	$ids[]=$product->product_id;
}
$db = JFactory::getDBO();
$query='SELECT * FROM '.hikashop_table('product_category').' as pc LEFT JOIN '.hikashop_table('category').' as c ON c.category_id=pc.category_id WHERE product_id IN ('.implode(',',$ids).')';
$db->setQuery($query);
$categories = $db->loadObjectList('product_id');

foreach($this->order->products as $k => $product) {

<td class="hikashop_order_item_category_value"><?php echo $categories[$product->product_id]->category_name;?></td>

			<td class="hikashop_order_item_edit_value" style="text-align:center">

<th class="hikashop_order_item_category_title title titletoggle"><?php echo JText::_('CATEGORY'); ?></th>

<th colspan="2" class="hikashop_order_item_remove_title title"><?php echo JText::_('ACTIONS'); ?></th>

Thabk you very much Maybe you can help me with individual discount prices for every user?

Thanks, but now i use a free version of Hikashop

Since it's the only solution, you will understand that we can't help you anymore

I need help again This category display solution doesnt work at checkout page in product listing, please can you help me with that?
Also, how to edit code of $amount for payment? ive made a discount system, but it does not affilate on payment amount

Already applied this changes, but its just doesnt work