Admin Category Products Sale Updater
1 Attachment(s)
Hello Everyone,
We are constantly putting items on sale and taking others off sale. I have wanted a more efficient way of handling this without having to do export/edit/import. I finally got around to making the necessary changes in a couple of files. The attached image shows 3 new columns tacked on to the right. On the Admin Category Products page you can now edit the 'List Price(market price)' and if you have the "On Sale Module' you can turn the 'Sale' ribbon on and off too. If you have a value in both Price fields you will see the amount of discount. If 'Your Price' is greater than the 'List(market price)' it will show 'P>L ?'. Attachment 4918 I hope this is of use to some of you and feel free to edit/correct what I've done. Thanks, Paul In: include/process_product.php After: Code:
// Include 'avail' field into the updating list Add: Code:
if (isset($v['list_price']) && is_numeric($v['list_price'])) In file: skin/common_files/main/products.tpl Before: Code:
</tr> add: Code:
<td nowrap="nowrap">{$lng.lbl_list_price} ({$config.General.currency_symbol})</a></td> Before Code:
</tr> Add: Code:
<td align="center"> |
Re: Admin Category Products Sale Updater
Nice one Paul, hope the house is coming along nicely... :)
|
Re: Admin Category Products Sale Updater
Hi Phil !
Thanks! I'll send you a pic of the house progress later today. Can't wait to hear about your new template! Have a great day! Paul |
Re: Admin Category Products Sale Updater
1 Attachment(s)
I was using this yesterday morning and thought of a way to make it much easier and super quick. What if there was a pull down where I could select the discount and then click update and the price, list price, and On Sale Y/N selection would all be done for me. So I spent a few hours in the afternoon working on it.
Please feel free to post all edits/corrections. I've not fully tested if you don't have the "On Sale" Module. Test on your development store before using on your live store. Use at your own risk as I only know enough to be dangerous :smile: Edited: This only works for items < $1000 !!! The below attachment shows how it works. Attachment 5011 On the attachment you can see the new column added to set the discount amount. I had to add a field to the 'xcart_products' table called 'set_discount'. Code:
ALTER TABLE `xcart_products` ADD `set_discount` INT NOT NULL DEFAULT '99'; I set the default amount to 99. A value of 99 is the manual mode and with all products having a 99 default value no changes are made to existing pricing. I only use the 'list price' when I have something on sale and it's zero the rest of the time. If you use 'list price' differently you'll have to edit the code. The edited code sections are below and replace the original 3 edits from the above post. Code:
if ($v['set_discount'] != '99') { Code:
<td nowrap="nowrap">{$lng.lbl_list_price} ({$config.General.currency_symbol})</a></td> Code:
<td align="center"> |
All times are GMT -8. The time now is 06:49 PM. |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.