|
devshb
Senior Member
United Kingdom
1904 Posts |
 Posted - August 31 2008 : 06:48:41
|
There is a low-stock-warning-level config option, but it's global (not product specific), if you wanted a product-specific low-stock check from the admin side to report on, then I think you'd just specify the low-stock level on one of the spare number/money fields (eg price2), and then run a fairly basic query from the advanced menu (or have a simple/dedicated screen to list them)
eg say you were using price2 to hold the low-stock warning level on the products, you'd then run a query something like this from the advanced menu:
select * from products where cstock<=price2
(the final sql might be a bit more complex than that, eg you might want to cater for null cstock/price2 values)
or, adjust the stock-low report to use that sql as part of its query.
Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons |
Edited by - devshb on August 31 2008 07:34:03 |
 |
|
All Forums
Low Stock Warning
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
