Yes now the override works, thanks!
Since I don't use 'products in box' field I tried code below. (product_box)
This is visible but gives an error on sorting?
An error has occurred.
1054 Unknown column 'product_box' in 'order clause'
Guess it's wrong code in last part: <td><?php echo $product; ?> <?php echo $this->product->product_box; ?></td>
Hope you can help to get this fixed.
Thanks,
Pas
<thead>
<tr>
<th class="admin-checkbox"><input type="checkbox" name="toggle" value="" onclick="Joomla.checkAll(this)" /></th>
<th><?php echo $this->sort('product_name') ?></th>
<th><?php echo $this->sort('product_sku')?></th>
<th><?php echo $this->sort('product_in_stock','COM_VIRTUEMART_PRODUCT_FORM_IN_STOCK') ?></th>
<th><?php echo vmText::_('COM_VIRTUEMART_PRODUCT_FORM_ORDERED_STOCK') ?> </th>
<th><?php echo $this->sort('product_box','COM_VIRTUEMART_PRODUCT_BOX') ?></th>
<th><?php echo $this->sort('product_price','COM_VIRTUEMART_PRODUCT_FORM_PRICE_COST') ?></th>
<th><?php echo $this->sort('product_price', 'COM_VIRTUEMART_PRODUCT_INVENTORY_PRICE') ?></th>
<th><?php echo $this->sort('product_weight','COM_VIRTUEMART_PRODUCT_INVENTORY_WEIGHT') ?></th>
<th><?php echo $this->sort('published')?></th>
</tr>
</thead>
<tbody>
<?php
if (count($this->inventorylist) > 0) {
$i = 0;
$k = 0;
$keyword = vRequest::uword ('keyword', "", ' ,-,+,.,_,#,/');
foreach ($this->inventorylist as $key => $product) {
$checked = JHtml::_('grid.id', $i , $product->virtuemart_product_id);
$published = $this->gridPublished( $product, $i );
//<!-- low_stock_notification -->
if ( $product->product_in_stock - $product->product_ordered < 1) $stockstatut ="out";
elseif ( $product->product_in_stock - $product->product_ordered < $product->low_stock_notification ) $stockstatut ="low";
else $stockstatut = "normal";
$stockstatut='class="stock-'.$stockstatut.'" title="'.vmText::_('COM_VIRTUEMART_STOCK_LEVEL_'.$stockstatut).'"';
?>
<tr class="row<?php echo $k ; ?>">
<!-- Checkbox -->
<td class="admin-checkbox"><?php echo $checked; ?></td>
<!-- Product name -->
<?php
$link = 'index.php?option=com_virtuemart&view=product&task=edit&virtuemart_product_id='.$product->virtuemart_product_id.'&product_parent_id='.$product->product_parent_id;
?>
<td><?php echo JHtml::_('link', JRoute::_($link, FALSE), $product->product_name, array('title' => vmText::_('COM_VIRTUEMART_EDIT').' '.htmlentities($product->product_name))); ?></td>
<td><?php echo $product->product_sku; ?></td>
<td <?php echo $stockstatut; ?>><?php echo $product->product_in_stock; ?></td>
<td <?php echo $stockstatut; ?> width="5%"><?php echo $product->product_ordered; ?></td>
<td><?php echo $product; ?> <?php echo $this->product->product_box; ?></td>
<td><?php echo $product->product_price_display; ?></td>
<td><?php echo $product->product_instock_value; ?></td>
<td><?php echo $product->product_weight." ". $product->weigth_unit_display; ?></td>
<td><?php echo $published; ?></td>
</tr>