Lalla Posted December 31, 2004 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
bowerybay Posted January 5, 2005 Posted January 5, 2005 I'd also like something like that, to display something like "There are X number of products available now" Quote
Guest Posted January 5, 2005 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
Jack_mcs Posted January 5, 2005 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. All of My Addons Get the latest versions of my addons Recommended SEO Addons
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.
Note: Your post will require moderator approval before it will be visible.