Lalla Posted December 31, 2004 Share Posted December 31, 2004 Is there a contribution that will show a total of inventory in your store. I know that I can click on the different categories and add their amounts together, but when I upload a group of books, I would sure like to make sure that all went thru. Thanks, Lalla Quote Link to comment Share on other sites More sharing options...
bowerybay Posted January 5, 2005 Share Posted January 5, 2005 I'd also like something like that, to display something like "There are X number of products available now" Quote Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2005 Share Posted January 5, 2005 Hi, this should do the job, just add this wherever: There are currently <?php $sql = "SELECT COUNT(*) AS Total FROM products"; $query = mysql_query($sql); $data=mysql_fetch_array($query); echo $data['Total']; ?> products available in <?php $sql = "SELECT COUNT(*) AS Total FROM categories"; $query = mysql_query($sql); $data=mysql_fetch_array($query); echo $data['Total']; ?> categories. It should return someting like: There are currently 194 products available in 17 categories. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 5, 2005 Share Posted January 5, 2005 Is there a contribution that will show a total of inventory in your store. I know that I can click on the different categories and add their amounts together, but when I upload a group of books, I would sure like to make sure that all went thru. Thanks, Lalla <{POST_SNAPBACK}> Hi Lalla - long time since I've seen you on here. :) Here is a contribution I just uploaded to do this. It only displays it in admin. If the option is needed to display it in the catalog section is needed, let me know as it will be an easy change. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
bowerybay Posted January 6, 2005 Share Posted January 6, 2005 Both solutions work well. Thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.