Jump to content

Number of Sales in Database


Recommended Posts

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'

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...