shipping cost report

[natureniche]

Is there a way to export, or even an app that can export your shipping data? I'd like to export the size of box I used, the actual weight, and the price I actually paid. 

[ThankedRapier4]

I'm wondering the same thing. I have an issue where I offer a free shipping discount for orders over a certain revenue threshold, but because the customer pays $0.00 for shipping, this is reflecting as a $0 shipping cost to me in the app I use to track profits.

My customers pay dynamic prices pulled directly from USPS and UPS based on their location, so I don't have a flat shipping rate to apply to all orders as an additional expense in my reporting. I need a way to easily export my actual incurred shipping costs for a given order (not just the aggregate shipping invoice).

[bbaum2]

We'd also love to have the shipping cost data exportable.. 

[alexstonehouse1]

Yes, why are there no reports on shipping costs? I want to be able to pull a report on what I'm spending on shipping, as well as my average package cost. I also offer free shipping over a certain amount but that doesn't mean MY shipping is free. Need to be able to keep tabs on my profitability.

[APGarcia]

I'm adding my agreement on needing this report in a much more detailed and concise way for accounting purposes.  You can't even pull it in the upgraded version with custom reports.

[alexstonehouse1]

The only real work-around I've found (after working closely with a Shopify rep for other solutions for a few weeks, looking at paid apps, etc) is to download all my bills for the period and enter the shipping costs into an excel spreadsheet, and generate totals and averages that way. Cumbersome but at least we can track it. Seems crazy though and a waste of my time since obviously the numbers are there, we just need a report.

[ThankedRapier4]

I don't really use this any more since I've moved to having Amazon fulfill
my orders, so the shipping costs are all reflected in Amazon's dashboard
now rather than Shopify, but when I was using Shopify Shipping, I would
just look at my finance report for the month. It contains the total amount
spent on shipping costs, and I'd just plug that number into my profit
tracking app as a one-time cost at the end of each month.

It screws with your 30 day view a bit since it takes another whole month
for the massive "cost" to trail off rather than being evenly spread over
each day, but it was at least enough to give me a sort of end of month
snapshot of my actual profit.

Given that you can actually see what you paid on each order, I have no idea
why it should be so difficult for Shopify to pull information from that
field or why anyone thought it was a good idea to pull from the field that
shows what you charge the customer.

[alexstonehouse1]

FYI I learned this yesterday from a long chat exchange with a Shopify rep:

From your owner account, you can go to Settings --> Billing --> View Finance Overview (at bottom) to get a generalized shipping cost total for whatever time period you'd like. Ok good.

BUT I also learned  - and feel this is potentially a HUGE issue with transparency on Shopify's part - that any additional/secondary shipping charges (such as dimensional weight adjustments, returned packages fees, and address adjustment/change fees) also just get lumped into this one "Shipping Fees" category and there is no other way to find or view those additional charges except by looking back into past individual orders to check their Timeline feeds. How can anyone be expected to do that? How do I know I'm being charged appropriately and where I need to make adjustments to my own shipping process in the future?

That is totally unacceptable and I encourage others to contact Shopify and make some noise about this.

A simple fix, if Shopify is not willing or able to provide comprehensive bills, is that the carriers can send me bills directly for any additional charges so I can evaluate and pay them. We would just pay the initial label cost through Shopify.

[Layali]

Thank you for bringing this up! 

I was just checking my billing info and can't believe that I can't see details on voided labels and other adjustments!

I am truly concerned now about the voided labels whether I am getting a refund for them as the billing is not showing any of that, just billing twice for the same order.

I hope Shopify would fix this soon.

[alexstonehouse1]

Thanks Layali - Right?! Please reach out to Shopify via support chat or
email and submit your feedback, they only change things when they hear
enough noise about it! Thanks.

[SansTentacles]

Adding my support to this as well -- it'd really help me out to be able to pull the actual shipping cost I paid for "free shipping" orders. I can't get an accurate profit without that number, unless I go order by order which. . .I'm not going to do.

Please please add this!

[Ckinne]

I agree with the others and frustrated to learn this is data is not easily accessible. i just started using the shopify shipping and this is a very disappointing frustration. I change my process over to Shopping Shipping to make things easier - now I will have to do more back-end work to make sure my accounting/bookkeeping is correct. Please add this report!

[Bradley_Harris]

We're going through the same laborious process right now. Ideally we could enter a shipping cost when fulfilling an order in Shopify, since rates fluctuate daily between our suppliers and we charge a flat shipping rate (based on product type) on the order. Although it all (hopefully) averages out, this is really what I would feel most comfortable with for an accurate P&L. 

[cmart720]

Here's the workaround I came up with -- and part of me dislikes how resourceful we are as entrepreneurs, because that means we will find a way when Shopify is lacking features and solutions they should really have. The reporting, for instance, is terrible!

There's an app in the Shopify app store called ReportPundit. I'm squeamish about giving my data to 3rd party apps, but Shopify is too worthless in the reporting area that I am just biting the bullet. Using the app, you can create the reports you wish Shopify offered.

I created a report with the following fields:

• Order number
• Order date
• Fulfillment date
• Shipping label amount (Created)
• Shipment Status (has it been delivered? in-transit? etc.)
• Product Title
• Quantity

The key here is the "shipping label amount (created)" field, which shows the price you paid for the shipping label.

I'm finding a lot of uses for the app.

Their support chat is also really helpful and will create reports for you if you tell them what you're looking for.

[APGarcia]

This is really helpful.  I hadn't found Report Pundit yet, but I think it does give me the report that I need.  I hate that you have to pay for the app add on, but probably worth it since Shopify won't give us the report we need. 

Thank you!  

[cmart720]

I'm not excited to rely on / pay for a 3rd party app either, especially when it seems like something Shopify should have built in. (note there is a 14 day trial)

I've justified ReportPundit because I am now using multiple really helpful reports:

• a shipping status report -- especially with massive covid USPS shipping delays, I want to know, all at a glance, which packages have been delivered / not delivered. This is why I found ReportPundit in the first place
• a sales tax report -- shows me how much sales tax collected each month (for the states I have to remit sales tax)
• UTM report -- show me which of my marketing efforts are working
• Shipping label expense report -- and yes, now, this report, for tax reasons

Chris

[alexstonehouse1]

Thanks all - It's a shame to have to pay additional for a basic (and needed
for tax purposes) report. And this still unfortunately doesn't report any
additional shipping fees (that get tacked on after purchasing/sending out a
label) like if the address needs to be corrected or if UPS makes
weight/dimension audits or packages are returned. When you work directly
with UPS and have your own account, they give you a full report and
breakdown of fees, which in Shopify just disappears into the depths of your
past order timelines. Unless you want to go back and check every single
order after it's been delivered, you'll never know the full extent of your
shipping charges. THAT is the main problem here for me.

[Project108]

As an eCommerce company, we use ShipStation for all of our shipping needs. With ShipStation we can easily supply customers with immediate shipping information and keep our ship team on track. What do we like best about ShipStation? Check them out: 

www.shipstation.com

*ShipStation ties in well with our Shopify account.

*The wide variety of shipping company’s allow us to ship internationally and within the US.

*Daily reports allow the ship team and management team to view Pending and Current Orders, Orders waiting to ship, Orders shipped, Stores from Orders shipped, and more.

*We operate our own online store as well as a store on Amazon and eBay seamlessly with ShipStation.

*ShipStation works on all platforms — PC, mobile devices, etc.

*Monitor inventory levels.

*Easily communicate with customers on their orders and shipments.

*Generate automatic communications with the Ship team and customers.

*Adding and changing products with ShipStation is not hard.

*Shipping labels print easily.

*API functions and procedures work well across operating systems and applications.

*There are all kinds of training videos for ShipStation online.

[msnicole1]

Ive reached out extensively. They don't care. They say you have to hire an expert. The fact they can't produce a viable report where they have taken your money on a daily basis is horrible business. I'm switching platforms based on this alone after almost 5 years with Shopify. 

[Craig917]

Thank you for sharing this. I'm sitting down to do taxes and have just discovered that Shopify reporting doesn't show the cost of labels printed. I'll look into the app you suggested. I will also give Shopify reps a call to make some (polite) noise.