Add column product category in back-office order view

[aguiu]

i want to add the column "category" (default product category) next to the product column in the products list of order view in back-office. I think that i have to modify:

 

\Backoffice\themes\default\template\controllers\orders\_product_line.tpl

 

and maybe AdminOrdersController.php

 

What code i need for that?

 

Prestashop 1.6.1.15 default bootstrap

 

[aguiu]

I want to insert the category column like in the attached picture:

[aguiu]

I have seen in another post something similar but with column condition, how i can do it with category default column?

 

to _product_line.tpl i added new column in table with products list

    <td>
    {assign var=condition value=Db::getInstance()->getRow("SELECT `condition` FROM ps_product WHERE id_product={$product['product_id']}")}
    {$condition.condition}
    </td>

to view.tpl i added new column heading

<th><span class="title_box ">{l s='Condition'}</span></th>