Regis Posted February 5, 2019 Share Posted February 5, 2019 Hi, Is it possible in the Dashboard/Product list (Admin Control Panel) to wiev (and sort) column Sale Price instead of column Price (Retail Price)? Now it's a bit complicated to sort and view products based on actual Customer price (which in most cases is Sale Price not a Retail Price). Thank You in advance for any comment :) Regis Link to comment Share on other sites More sharing options...
Dirty Butter Posted February 5, 2019 Share Posted February 5, 2019 My Admin DOES sort by Sales Price. That may be something Bsmither helped me do a long time ago - will try to find it. Well I found it, but it's not quite what you need. I suspect what you need might take similar coding - but it's way past my abilities. https://forums.cubecart.com/topic/54197-need-help-with-sort-on-custom-quantity-discount-column/?tab=comments#comment-234658 Link to comment Share on other sites More sharing options...
bsmither Posted February 6, 2019 Share Posted February 6, 2019 Two simple edits. But, keep in mind that these edits will not survive an upgrade. So, after upgrading, re-edit the following files. In the admin template file products.index.php, near line 79, find: <td>{$product.product_code}</td> <td>{$product.price}</td> On a new blank line AFTER, add: <td>{$product.sale_price}</td> In the admin sources file products.index.inc.php, near line 1127, find: foreach ($GLOBALS['hooks']->load('admin.product.table_head_sort') as $hook) include $hook; $GLOBALS['smarty']->assign('THEAD', $thead_sort); On a blank line BEFORE that, add: $thead_sort['sale_price'] = $GLOBALS['db']->column_sort('sale_price', $lang['common']['price_sale'], 'sort', $current_page, $_GET['sort']); The new column values for Sale Price comes from the specific price entered as a Retail Sale Price on the Add/Edit Product screen, Pricing tab. CubeCart offers two Sales modes: Per-product (specific pricing) and Global percentage. The new Sale Price table column reflects the Per-product value. The Global percentage value is irrelevant to be shown here because the global discount is computed directly from the (retail) Price. So - just sort on the price. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.