Accepting credit cards, warehouses, and shipping and fulfilling orders
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.
I just spoke with Shopify support, and they figured out a way to get the info:
1. go to Settings > Billing
2. Choose the bill you need
3. Click Shipping - It should show a number of "items", which are the shipping charges.
4. You can export each month as a CSV.
Not as neat and tidy as a single report, but not crazy either.
Hope that helps.
I love this workaround.
Are there any other dropshippers out there using their supplier's carrier accounts like us?
In this case, our supplier emails us with an invoice for each order with total charged including the shipping price charged. In this case, what we are actually looking for is a way to tracking shipping charges per order. Our current process includes adding a comment on the order of the shipping price charged for our monthly P&L, but this is becoming more of an accounting burden and not scalable as we grow to a few hundred orders per month.
If I am alone in this fulfillment challenge that I will accept my fate and look for custom solutions, but hoping that is not the case!
Thanks, stay safe everyone.
I'm right there with you @alexstonehouse1. It's a workaround for something that I thought would be a standard part of the reports Shopify creates. But it's definitely not scaleable. And don't even get me started on the adjusted shipping charges. I'm sure there's a way to report it all simply and accurately. I'll post an update here if I find it. Best of luck to you.
Seems that the shipping and payout are in the order information, why don't they appear in the export of the orders. I do fulfillment for myself and others and need costs allocated by order. This in addition to obvious need for allocating fees and shipping for tax accounting purposes. This seems worse than paypal, I thought that was impossible.
this report doesn't show the order number so you can't even do a vlookup to update your shipping costs per order.
Hi @ThankedRapier4 (and everybody else who has taken part in this thread!),
The BeProfit - Profit Tracker app could be exactly what you're looking for.
You'll get a dashboard that lets you track and analyze your profits and expenses including shipping costs, marketing, production, and more (you can manually enter expenses as well).
The app automatically pulls Shopify shipping profiles and even lets you create new shipping profiles and shipping zones for full customizability. You'll also get a full breakdown of how much you paid for shipping and how much the customer paid for shipping for every order. You can watch a short explainer video of how BeProfit tracks shipping costs, here.
While it's extremely useful for tracking shipping costs, BeProfit offers many more advanced features to help make sense of all your shop's data to accurately calculate your bottom line.
You can use BeProfit to:
Try BeProfit and let us know if you find it helpful. Plus, if you have any suggestions on how we can improve the app, we're always happy to get feedback!
How is this not a report included with Shopify. @Shopify, please step your game up to allow us to run our business like a business without having to give data to 3rd parties.
@Shopify This is a basic report needed by all. please provide a response as to when you will include this... is it part of shopify 2.0?
This is a basic report needed by all. please provide a response as to when you will include this... is it part of shopify 2.0?
Easy Reports now supports exporting this data now as well.
The devs have been supportive in helping to solve the issue created by the data not being presented by Shopify.
Just had to troubleshoot this for my taxes. Easiest way that I did it is to go to:
> Select the billing statement/cycle that applies to your search. (For me, I selected each month of the year I wanted to run a report on so I could get a whole year snapshot.)
> Export CSV File (top right)
From there you will sort by "Shipping" and then just do a simple excel equation to add up everything you spent on shipping.
Obviously not as simple as having Shopify pull this report automatically but this whole process only took me a few minutes and does not require any third parties.
I am pretty tech inept LoL but in my fumbling around I discovered an easy way to generate the report.
- View all billing history
- In the upper right click on Export CSV
- You then have the option of choosing dates. Chose Jan 1 - Dec 31.
- You will then have to sum the shipping expenses column,
The report also includes fees for apps used for shipping like Boxify and Amazon Integration Plus.
Hope this helps. Amazon support had no idea.
@Shopify has this been resolved yet? Still need this built into reports so that I can properly (and easily) review true profit margins per order.
Under the Admin homepage: go to Finances > Billing.
Under Recent Bills, click "View all Billing History"
Now the key is to Export to CSV File at the top.
Click Bill by Date > Export Bills.
Once you have the Excel file open, it will break down all charges by Shipping, Apps, etc. and you can view the report as needed for Accounting.
Thanks to all who participated in our AMA with 2H Media on planning your 2023 marketing bu...By Jacqui Mar 30, 2023
Thanks to all Community members that participated in our inaugural 2 week AMA on the new E...By Jacqui Mar 10, 2023
Upskill and stand out with the new Shopify Foundations Certification programBy SarahF_Shopify Mar 6, 2023