homewetbar Posted August 10, 2005 Share Posted August 10, 2005 Please post your questions regarding the Low Stock Report v2.0 contribution here. WHATS NEW IN 2.0? ------------------------- NEW FEATURES: * It now shows you your sales on this item in the last 30 days so you can really know if this item is really selling or not * Estimated days stock, this is based off of the last 30 days of your sales, if you have 0 in stock it will display NA in red, if you have 15 days or less it will display the days in red, if you have no sales but stock it will display +30 Days. Pretty niffty ehh? Much more accurate. NOTE: It will only display items that need restocked that are at or below your restock level set in admin -> Stock, regardless of how many estimated days stock you have. This is because it has to execute a DB query for every item it estimates days of stock for so this is a way of limiting the queries to the most relevant items (item below restock levels). Maybe someone can further optimize my queries if they know how... This should be a hugely helpful addition to your store, thanks to all the other authors who wrote the previous versions and the people who wrote the stats products purchased contrib, these two contrib are which this code is based on. Regards, -Keith W. Quote Most Valuable OsCommerce Contributions: Also Purchased (AP) Preselection (cuts this resource hogging query down to nothing) -- Contribution 3294 FedEx Automated Labels -- Contribution 2244 RMA Returns system -- Contribution 1136 Sort Products By Dropdown -- Contribution 4312 Ultimate SEO URLs -- Contribution 2823 Credit Class & Gift Voucher -- Contribution 282 Cross-Sell -- Contribution 5347 Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.