mgamer20o0 Posted November 17, 2011 Share Posted November 17, 2011 the end of the year is coming up and taxes have been on my mind. is there a easy way to find the total amount of taxes i collected though prestashop? i only collect taxes in 1 state here in the USA. Link to comment Share on other sites More sharing options...
mgamer20o0 Posted December 8, 2011 Author Share Posted December 8, 2011 any idea? Link to comment Share on other sites More sharing options...
bellini13 Posted December 8, 2011 Share Posted December 8, 2011 you can run the following 2 queries using phpmyadmin, then subtract the 2 to arrive at total tax paid. Total Revenue SELECT sum( total_products ) FROM `ps_orders` Total Revenue with Tax SELECT sum( total_products_wt ) FROM `ps_orders` Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
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