Hello,
We're in Canada and shipping costs can vary wildly depending on whether we are shipping to a large city VS a more rural area.
Due to a postal strike in our country, we're using UPS as our carrier, which means that shipping costs skyrocket if we are delivering to certain remote regions.
Basically we're trying to figure out which cities/towns of our previous shipped orders had the worst shipping costs.
What we'd like is to have a report that shows shipping costs in a column and destination city in another column.
Two ideas on how to implement this:
1) Add a "destination city" column to the "Shipping Cost" report (under Insights -> Reports -> Shipments)
2) Add a "shipping costs" column to "Order Detail" report (under Insights -> Reports -> Orders)
I'd say Idea #1 is probably better because each order is represented on 1 row each, so it's more straightforward.