Jump to content

SQL Query for PrestaShop 1.7? -


Recommended Posts

Hi all, I require a bit of help making an SQL query for PrestaShop 1.7.

 

I need to find out the total value of order sales I have shipped, to a range of countries. (E.G. USA, Australia, Canada) combined, where the order is marked as 'Shipped', within a certain date/timeframe.

 

I am sure this is pretty simple for those who specialise in PrestaShop. If anyone has a spare minute or two, would anyone be able to provide an example SQL query to achieve this? It would be highly appreciated!

 

Please and thank you! :)

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...