How to Bulk Export Tracking Numbers from Fulfilled Orders?

[King4]

Hi, I'm trying to export the tracking numbers from all of my fulfilled orders and I can't find a way to do it in bulk. Or maybe I haven't searched enough so I want to ask here, is anyone how to do it?

Thank you,

[Anders3]

Hi, there!
 
Anders from the Shopify Social Care team here. Thanks for reaching out today!

If you're looking to bulk export information from your orders, like tracking numbers, the easiest way to do this would be by using the Order Printer app and a customized template to include an order's tracking number.

Essentially, the app allows you to bulk print order details into invoices or packing slips. However, the template for these invoices can be modified to include order information like tracking numbers. Potentially, you can either create a new template to only pull the tracking number, or you can customize one of the existing templates (invoice or packing slips) to also include the tracking number information. While HTML or Liquid knowledge will be required to customize a template, if you're not sure how to make these changes, feel free to follow back up and I can put in a request to our Theme Support on your behalf.

Cheers!

[Jonathan-HA]

Hi King,

Our app, EZ Exporter, can bulk export the tracking numbers for you as well.  You can export them both on the order level and the line item level (in case there are multiple fulfillments, you can see which tracking numbers are associated with each line item).

Please feel free to reach out if you have any questions!

[King4]

Thank you for your reply, it would be nice if you can give me a detail instruction on how to customize the existing template to add tracking number in bulk, I'd really appreciate it!

[danielpretorius]

Hi @King4 

Sync your Orders to an Airtable base, and make sure to specify one of the columns to include the tracking number. Then you'll have all the orders with their tracking numbers all in one easy-to-use spreadsheet interface. Take a look at our guide on how to bulk update your Shopify data .

[PluginHive]

Instead of generating shipping label externally and importing the tracking numbers in bulk using CSV, I recommend you to check out the Shopify Multi Carrier Shipping Label app, which will help you to integrate directly with carrier account to generate the shipping label and send the live tracking to customers.

You can easily handle 100s of orders everyday using the app. With just a single click, you can generate shipping labels for all your orders and the tracking number for these orders will be sent to the Shopify order details, which is then sent to the customers via email.

[StevenBRichards]

Our seller just need this feature like  EZ Exporter.

Pls help to add tracking No. & Carrier column in export order CVS feature. All problem will be solved.

Pls help to feedback to your IT and solve it ASAP. Thanks ahead.

@Anders3 

[woodwitch]

I definitely need help with customizing my template!  I downloaded the app not realizing I'd have to have knowledge of liquid to get to a report that included tracking numbers.

[BetterReports-K]

Hi @King4 ,

Keanna here from Better Reports.

I believe our app Better Reports can help with this request. Better Reports is able to report the tracking numbers for all your fulfilled orders and you can easily export this to Excel, CSV or PDF.

Better Reports can filter to only show orders that have been fulfilled and list the tracking number, shipping company and/or shipping details for each order. You could even filter the report on the fulfillment or order date if you just wanted to see orders for a specific date range.

Some of our customers even use a custom field to see the number of days to fulfillment which allows them to monitor orders which took more than x days to fulfill.

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to direct you to these reports.

Let me know how you go, and feel free to reach out if you have any further questions.

Disclaimer: I am part of the Better Reports support team.

[JuanQuijano · Accepted solution]

It sucks how everytime someone comes seeking for help, all the developers come to sell apps. You cant actually know whos trying to genuinely help or just here to sell.

You can create a new template in the FREE order printer app with:

<p>
Order {{ order_name }}
</p>
<p>
Tracking Number {{ XXX }}
</p>

You will have to try different values for XXX, as it may depend on the template you have: fulfillment.tracking_number or fulfillment.tracking_numbers.first or  line.fulfillment.tracking_number.

Hope it helps.

[Layali]

Your app (EZ exporter) is not working !

I am trying to export the file and it just stops in the beginning of loading.

[Jonathan-HA]

Hi @Layali ,

I'm sorry to hear you're running into an issue with our app.  We're seeing exports running fine on our side.

I ran a quick test on our test stores and everything looks normal as well.

If you can contact us at support@highviewapps.com and provide the name of your Shopify store, I can take a closer look at your account to check what's going on.

[Jonathan-HA]

Hi @Layali,

Thanks for contacting us.  I've already replied to your email.

Your email address and Shopify store actually isn't showing up in our system so I believe you have a different app installed.  The description of the issue also doesn't match our UI.

I know there are other apps out there with the word "Exporter" in the app name.  There's one newer app in particular that has almost the exact same name as ours (they used "AZ" instead of "EZ").

You can view our app icon and screenshots here: https://apps.shopify.com/ez-exporter

Just wanted to mention it here so readers are aware of this as I can definitely see the confusion considering how close the names are.

[greensunstaff01]

Hi there,

I created a new template with your code to pull only the tracking number. However, it's not working and I'm reaching out to ask if there's any problem and what I should do to make it work. I tried with all three values of XXX: fulfillment.tracking_number or fulfillment.tracking_numbers.first and line.fulfillment.tracking_number.

I attached some photos, please have a check! Btw, is there any way to export the tracking number as one csv? As I'm finding the solution to keep track of all orders' delivery status and then estimate the average delivery time.

Thank you so much in advance! Looking forward to hearing from you soon!

Best regards,

Vicky

[davehorn]

I have selected the following variables to print on the new template. 

{{ fulfillment.tracking_company }}
{{ fulfillment.date }}
{{ fulfillment.tracking_number }}
{{ subtotal_price | money }}

Only the {{ subtotal_price | money }} prints on the new report.  All have UPS, a date, and a tracking number.  Without you seeing the orders, is there any way to know if I've picked the wrong variables?  None of the first three populate in and around the text on the form.  Thanks!  Dave

[davehorn]

What are other values for tracking number?  None of those seem to work.  I will have my developer check to see what the template uses.  Thanks!  Dave