Obtain Number of Products in Catalog

[Andrew Mellor]

We want to display on our front page the number of products that we are offering on our website - eg. Currently 567 books available to buy...

Is there a simple way to get the total number of products that we have in Catalog without manually counting them... We do not use components etc. Also we assume that all products are 'live' and not 'hidden' from display.

We currently use Catalog v4 but are due to upgrade to v6 soon.

Thanks in advance for any help,

Andrew Mellor
Collectors Supplies www.csbooks.co.uk 01633 615601
Unit 16, Pontymister Industrial Estate, Risca, Gwent, NP11 6NP
==============================================================

[NormanRouxel]

If you have Microsoft Access you could have an Access query that looks in the Product table, counts all active products and writes that number to to a file. You can then include that file on Act_Primary.html via a

Currently
NETQUOTEVAR:INCLUDE <filename>
books available to buy...

And it will be displayed on all pages.

Run the query before you do a site update.

I've also a trick that would prevent all pages from needing uploaded (as they would all appear to have changed whenever the number changes). Ask me if you decide to go this way.

Look at www.edge2edge.co.uk/acatalog/ where you'll see the date and time the site was last updated being inserted this way.

Norman

Note to Actinic. Good wish list to automatically generate a few NETQUOTEVAR's containing things like Update Date, Time, # Sections, # Products, etc.