HelenI Posted May 14, 2016 Share Posted May 14, 2016 So I have been using Advanced stock management on my website, but due to that all the statistics on STATS tab are incorrect. I need to generate some stats so I would like to use SQL Query for that. My problem is that I do not know which tables to use! Is there a description somewhere in the documentation to find out? For example, I would like to make a query for stock value of product sold last moth for accounting purposes. Does anyone know where to start? Link to comment Share on other sites More sharing options...
tuk66 Posted May 17, 2016 Share Posted May 17, 2016 The ps_order_detail table provides information about products sold and several ps_stock* tables about actual stock. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now