X-Cart forums

[leon]

The title says it all, just a simple query for all pages in the cart outputing the total number of customers since the shop opened.

This is also a sales pitch, cause people are confident when they see that others have ordered from the site, thus incrementing substantially day by day.

[shan]

ok if you have 100000 customers but as bad as hit counters when your site is new or dosnt have many visitors.

[leon]

That is correct, but you could also have this as an option in admin (turn on, turn off) where admin will always know how many customers have been served.

When admin considers he has a vast ammount he would obviously want to show off with his visitors.

[gamenebula.com]

Sounds like a good idea

[B00MER]

SELECT COUNT( xcart_customers.login ) AS total_customers
FROM xcart_customers 

[jeremye]

Or you can count "customers served" by the number of orders placed:

SELECT COUNT(xcart_orders.orderid) AS total_orders
FROM xcart_orders

[gamenebula.com]

Where would these nifty lines of code go? I don't actally see the text "Customers Served" in the cole.

[B00MER]

You could add it to customer/home.php after the require "./featured_products.php"; line.

$total_customers_sql = "SELECT COUNT(xcart_orders.orderid) AS total_orders FROM xcart_orders";
$total_customers = func_query($total_customers_sql);
$smarty->assign("total_customers",$total_customers[0][total_orders]);

Then anywhere in your skin1/*.tpl you can use:

{if $total_customers}{$total_customers} Customers Served.{/if} 

to get the number for results

[jeremye]

Nicely put Boomer.

[lyncca]

Hmm, neato

We may have to do this on our site, our site only has a few hundred sells under its belt so far (for xcart) so not sure its enough yet.