xertion Posted October 13, 2015 Share Posted October 13, 2015 We have free shipping for orders over a $40. All orders below $40 pay shipping. For accounting reasons, we need to know how much we earn from shippings on the website. Meaning, how many people that pay and how much the total amount is, for shipping. Currently this is not possible to see in Prestashop from what I know... This is only visible on a order-per-order basis by looking on each order's details. But we need to see it for tens of thousands of orders. If no one know how to do this in Prestashop, does anyone know it which table this data is stored so that perhaps we can do a SQL Query to find out? Link to comment Share on other sites More sharing options...
tuk66 Posted October 13, 2015 Share Posted October 13, 2015 The ps_orders table stores more total_shipping* values. A SQL query can summarize them. 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