Number of Sales in Database

[Zerocool12]

Hello

i want to know how to get the number of sales in the Database . in which table is that data ?

[Involic]

If you want to get number of orders in your PrestaShop store you can try to run following query:

 

SELECT count(*) FROM ps_orders;

 

And also you can extend this query with more information.

For example get count of valid orders in current year.

 

SELECT count(*) FROM ps_orders WHERE valid = 1 AND date_add >= '2013-01-01 0:0:0'

[vekia]

by sales you mean orders or product in sales?

if second, ps_product table, "on_sale" column