Unable to see sale items from admin side

[keat]

If i enter in to admin > products and bring up a list of products, there's no indication which items are discounted or on sale.

So the only way to see which items we have listed on sale is via the customer side.

Am i missing something obvious ?

[bsmither]

You are not missing anything. There is no indication.

There are two sales modes: global and per product. An after-market mod may also provide the method of setting all products associated with chosen categories on sale.

The global setting obviously would indicate nothing distinctive because everything would have such an indicator.

The per-product setting relies on the sale price being greater than zero and less than the regular price.

What kind of indicator would you like?

* A different tint of table row background color
* A Sale Price sortable column
* Something else

 

[keat]

I guess a sale price column that could also be sorted would be good.

My V3 does show the sale price underneath the normal price on the admin side, but I'm not sure if this was normal or a mod.

[bsmither]

Did this ever get developed?

In /admin/sources/products.index.inc.php, near line 1259, find:

	foreach ($GLOBALS['hooks']->load('admin.product.table_head_sort') as $hook) include $hook;

	$GLOBALS['smarty']->assign('THEAD', $thead_sort);

On a blank line above that, add:

$thead_sort['sale_price'] = $GLOBALS['db']->column_sort('sale_price', $lang['common']['price_sale'], 'sort', $current_page, $_GET['sort']);


In the admin skin template products.index.php, near line 46, find:

<th nowrap="nowrap">{$THEAD.price}</th>

Change to:

<th nowrap="nowrap">{$THEAD.price}</th><th nowrap="nowrap">{$THEAD.sale_price}</th>

Near line 79, find:

<td>{$product.price}</td>

Change to:

<td>{$product.price}</td><td>{$product.sale_price}</td>

 

[keat]

We had a black friday event, and because sale mode doesn't omit items already on sale, I ended up resorting all my sale items to a fixed discounted price.

We now have a boxing day even coming up, so I never re-instated the sale prices.

Now I've nothing really to test against.

Maybe in the new year when I've done my database migration, i'll have a play with this.