Jump to content

Unable to see sale items from admin side


Recommended Posts

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 ?

  • Like 1
Link to comment
Share on other sites

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


Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 9 months later...

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:


Change to:



Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...