Hello.
I am required to keep an offline record of all the orders / shipping method / tracking numbers.
It would make sense to download a report daily (CSV or PDF)
Is there a way to do this within Shopify admin without using an app?
I have tried exporting orders by day and it does not have tracking.
I have also tried reports but I can’t find any report with tracking numbers.
Help would be appreciated.
Hi @Coffeemallow Not without apps, the native order export isn’t configurable.
A possible workaround may be with shopify-flow(free app made by shopify) to bake the tracking number into an order tag.
Keeping in mind tag limits, MAX 40?? characters on orders sigh. And consider any security/privacy concerns of that info being in the order api through tags(e.g. downstream providers see tags and thus get customers tracking number).
Alternative use shopify-flow app to populate rows in a google-sheet.
Shopify-flow can’t generate pdfs, though it can send staff emails so if you have a way to turn an email into a pdf then that’s the path.
Otherwise apps are needed, for merchants needing pdfs I built that with mechanic as it can generate pdfs AND email them in more dynamic ways than flow can.
Reach out if you need it built.
Paul is spot on with the Shopify Flow to Google Sheets suggestion.
You just create a workflow in the free Flow app:
Trigger = “Fulfillment created” (since that’s when the tracking number actually exists).
Action = “Add row to spreadsheet” (Google Sheets).
You can map the exact variables you want into the columns: Order number, shipping method, and tracking number. It updates automatically in real-time, so you don’t even need to remember to download a daily CSV. You can just export the Google Sheet to CSV/PDF whenever you need the hard offline copy.
Hi there @Coffeemallow
Totally get why you’d want a clean daily export for compliance.
In Shopify admin (built-in), there isn’t a standard report/export that reliably includes tracking numbers. The Orders CSV export doesn’t include fulfillment tracking, and the built-in Analytics/Reports generally don’t expose tracking fields either (tracking lives on the fulfillment record, not the order summary).
If you need a daily CSV/PDF with order # + shipping method + tracking, you’ll typically need either:
If you tell me what plan you’re on (Basic/Shopify/Advanced) and which carrier/app adds the tracking, I can suggest the simplest workflow for your setup.
Hey @Coffeemallow ,
Just in case the proposed solutions without using an app is not sufficient and you also need to export the tracking numbers of old orders, our EZ Exporter app can export them as well.
You can export the tracking numbers both at the order level and line item level (i.e. if an order has multiple shipments, so you know which line items are associated with which tracking numbers).
In the app, we have a pre-built template called “Order Tracking Numbers (Last 30 Days)” which already includes the fields related to tracking and can be customized further.
Shopify’s native Staff Notifications (Settings → Staff notifications) can send daily order summaries by email, but it doesn’t include tracking numbers or a CSV attachment. For offline recordkeeping with tracking data you’ll need an app that pulls directly from the Shopify API there are a few on the app store that do this, Order Digest being one of them.