Ho do I report on JUST shipping
1 year 5 months ago #367226
by grayt7
Ho do I report on JUST shipping was created by grayt7
Hi,
How can I get the total sales of shipping during a given period please?
Many thanks.
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.
1 year 5 months ago #367228
by nicolas
Replied by nicolas on topic Ho do I report on JUST shipping
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
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.091 seconds