Ho do I report on JUST shipping

  • Posts: 367
  • Thank you received: 7
  • Hikashop Business
1 week 3 days ago #367226

Hi,

How can I get the total sales of shipping during a given period please?

Many thanks.

Please Log in or Create an account to join the conversation.

  • Posts: 83904
  • Thank you received: 13581
  • MODERATOR
1 week 3 days ago #367228

Hi,

There is no mechanism to do that just in HikaShop.
What you can do is this:
- use the order status filter and the start and end date filters on the orders listing in the backend, so that you only see the orders you want to be taken into account for that total.
- click on the "export" button. That will give you a CSV file with all the data of all the orders based on the selected filters.
- open that CSV file with Excel or LibreOffice Calc.
- search for the "order_shipping_price" column which contains the shipping fee for each order
- use the "sum" function on the column to get the total at the bottom:
support.microsoft.com/en-us/office/sum-f...80-8f32-07b23e057f89

Please Log in or Create an account to join the conversation.

Time to create page: 0.063 seconds
Powered by Kunena Forum