Total amount of products on site

[Lalla]

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

[bowerybay]

I'd also like something like that, to display something like "There are X number of products available now"

[Guest]

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.

[Jack_mcs]

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

[bowerybay]

Both solutions work well. Thanks!