Post by ferdi.ilkhan » Mon Mar 11, 2013 12:20 am

Hi guys,

I'm looking for a module or an extension to count my orders, all of them (not item count or visitor count I only want the checkout's count) and I want to show it on my page. Is there something already made or Can I somehow exctract this info from my database? Thanks in advance.

Newbie

Posts

Joined
Mon Mar 11, 2013 12:17 am

Post by chrisranjana.com » Wed Mar 13, 2013 2:14 pm

You could use

SELECT count( * ) AS number_of_orders FROM `order` and if you need to segregate based on multiple stores then you could the store_id column too.

Chris, Opencart Developers and Programmers,
Opencart Developers Opencart Programmers
https://www.chrisranjana.com


User avatar
Active Member

Posts

Joined
Thu Feb 26, 2009 2:23 am
Location - chennai, India
Who is online

Users browsing this forum: No registered users and 2 guests