Total orders shipping costs BO

[logan1ro]

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.

[shokinro]

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'