logan1ro Posted March 30, 2016 Share Posted March 30, 2016 Hello, I try to find a way to calculate the total shipping costs in BO for a certain period. If there are 3-4 orders each day, it's simple to calculate. When orders rise, it's a killer job. Does Prestashop have the option to calculate orders total shipping cost for a given period? Thank you. Link to comment Share on other sites More sharing options...
shokinro Posted March 31, 2016 Share Posted March 31, 2016 I am not aware of any option in prestasp back office that allow you do this. if you know how to write SQL statement, you can easily to do that via database tool such as PhpMySql You can try to use following SQL - just replace the date range you want. SELECT sum(`total_shipping_tax_excl`) As shipping_total_tax_excl, sum(`total_shipping_tax_incl`) AS total_shipping_tax_incl FROM `ps_order_invoice` WHERE `date_add` >= '2016-03-01' AND `date_add` <= '2016-03-31' 1 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