Average Shipping Cost by Product ID
I would like the Shipping Cost report in Insights > Reports > Shipping Cost to have an additional filter field "Product ID" so I can calculate average shipping costs for each product. Currently that report does not specify the product ID at all.
This will help sellers set prices on listings which are advertised as Free Shipping to the buyer.
We are currently reviewing feedback around improving insights and reporting in multiple ways. We will keep this idea in consideration as we plan our improvements in this area.
PiggyBank Bargains PiggyBank Bargains commented
I agree this would be super useful
Dean Roberts Greenleaf Dollhouses commented
It's shocking that this report isn't currently available or at least an ability to export the data to calculate this ourselves. Free shipping isn't free to us and we need to know what the costs are at an SKU level so that we can adjust our pricing accordingly.
Currently, I search shipped orders for a certain SKU, then copy and paste the results into excel.
Then I have to sort by units shipped to weed out multiples and then again by weight. Still, the data is limited by the search results and not always accurate. There is a wealth of information that if made available, would be a tremendous help, especially for those of us who's shipping costs can represent near 30% of the product costs.
A simple report that returns the cost for single item shipments filtered by SKU that includes the carrier and zone would be enlightening or perhaps frightening. Please consider either a report or a way to export the data so we can analyze it ourselves.
If there is currently a way to get this information, please add a comment explaining the process.
This really needs to happen! The analytics are the key to businesses these days and I've been searching this myself. It's so hard nit-picking through a complete excel sheet of thousands of products to get avg cost of shipping for each product.
Agreed. Because shipping prices all over the country vary, I want to be able to get an average shipping cost on individual items.