codingrow.com
Order Export & Tracking Import

Export Orders & Import Tracking Numbers in Magento 2

A step-by-step native guide to exporting Magento 2 orders and adding tracking numbers to shipments, plus a faster alternative for bulk workflows.

Order Export & Tracking Import โ€” Export Orders & Import Tracking Numbers in Magento 2

Fulfilling orders through a warehouse, 3PL, or dropship supplier almost always means the same two headaches: getting order data out of Magento, and getting tracking numbers back in. This guide shows how to export orders and import tracking numbers in Magento 2 using only native admin tools, plus where those tools hit their limits.

  • Export orders from the Sales grid with the right columns for your fulfillment partner
  • Create shipments and attach tracking numbers to orders natively
  • Trigger automatic shipment confirmation emails to customers
  • Understand why bulk tracking import needs a workaround (and what that workaround looks like)

Step 1: Prepare the Orders grid for export

Before exporting, make sure the grid shows the columns your warehouse or 3PL actually needs.

`Salesโ€บOrders`
enable `Shipping Address`, `Shipping Method`, `Grand Total`, `Purchased From`

Expect the grid to refresh instantly with the extra columns visible before you filter or export anything.

Save time by creating a dedicated grid view. Some Magento versions let you save custom column layouts so you don't have to reconfigure them every time you export.

Step 2: Filter to only the orders you need

You rarely want to export every order ever placed โ€” usually just orders awaiting fulfillment.

`Salesโ€บOrders`
`Processing`
last 24-48 hours

Expect the grid row count to drop to only the orders matching your fulfillment window.

If you ship from multiple warehouses or use multiple order statuses (e.g. Processing, Payment Review), filter and export each batch separately to avoid mixing shipments.

Step 3: Export the filtered orders

With the grid filtered, use the built-in export function.

`Salesโ€บOrders`
choose `CSV` or `Excel XML`

Expect Magento to generate a file containing exactly the columns currently displayed in the grid โ€” nothing more.

The native grid export only includes visible grid columns, not full order item details, custom attributes, or complete addresses split into individual fields. For richer exports (SKUs, quantities, item-level data, B2B fields), most merchants eventually need a dedicated export tool.

Step 4: Send the file and collect tracking numbers

Once your fulfillment partner ships the orders, they typically return a spreadsheet with:

  • Order number or increment ID
  • Carrier name
  • Tracking number

Keep this file organized โ€” you'll need it for the next step, whether you enter tracking manually or via API.

Step 5: Create a shipment and add tracking manually

This is the core native workflow for importing tracking numbers into an order.

`Salesโ€บOrders`โ€บopen an orderโ€บclick `Ship`
select the shipping carrier (or `Custom Value` for a non-standard courier)
paste the tracking number from your fulfillment file

Expect a new tracking line to appear once you click Add Tracking Number; click Submit Shipment to finalize.

Enable Email Copy of Shipment (checkbox on the same screen) so the customer automatically receives their tracking number without any extra step.

Step 6: Repeat for each order โ€” or script it

Doing this one order at a time works for small volumes, but it doesn't scale.

  • For a handful of daily orders, manual entry via Salesโ€บOrders is perfectly fine.
  • For dozens or hundreds of shipments a day, manual entry becomes a bottleneck and a source of typos.
  • Magento has no native bulk import screen for shipment tracking โ€” this has to be built with the REST/SOAP API (POST /V1/order/{orderId}/ship with a tracks array) or a custom script.
This API gap is exactly why "bulk tracking import" is one of the most searched Magento fulfillment problems โ€” the shipment object supports tracking natively, but there's no admin UI to import a CSV of tracking numbers in bulk.

Step 7: Verify shipments and tracking on the storefront

After adding tracking, confirm the customer-facing experience works as expected.

Customer accountโ€บ`My Orders`โ€บopen the shipped order

Expect the tracking number and carrier link to appear under the shipment details, and the order status to update to Complete (if fully shipped) or remain Processing (if partially shipped).

Checklist

  • โ˜ Orders grid columns configured for your fulfillment needs
  • โ˜ Orders filtered by status and date before exporting
  • โ˜ Export file sent to warehouse/3PL and tracking numbers received back
  • โ˜ Shipments created with correct carrier and tracking number
  • โ˜ Email Copy of Shipment enabled so customers get notified
  • โ˜ Storefront order page checked to confirm tracking displays correctly

If you process tracking for the same carrier every day, standardize the carrier name spelling in your fulfillment file โ€” Magento's carrier dropdown expects an exact match or it falls back to Custom Value, which won't generate a trackable link for standard carriers.

Common mistakes

Exporting before filtering. Exporting the entire Orders grid and then hunting for the right rows in a spreadsheet wastes time โ€” always filter by status and date first.

Forgetting partial shipments. If an order has multiple items shipped separately, each shipment needs its own tracking number; a single tracking field won't cover split shipments.

Using Custom Value for standard carriers. This disables the clickable tracking link on the storefront. Always match the carrier dropdown to a supported carrier when possible.

Re-exporting the same orders daily. Without a status or date filter, merchants often re-export orders already fulfilled, causing confusion in the warehouse.

FAQ

Can I export orders with full item and address details natively?

Only partially. The Sales grid export is limited to visible grid columns, so full line-item data, custom attributes, and split address fields usually require a dedicated export tool or custom code.

Does Magento have a native bulk import for tracking numbers?

No. Magento supports tracking numbers at the shipment level and exposes them through the API, but there is no built-in admin screen to import a CSV of tracking numbers in bulk.

What happens if I enter the wrong carrier for a tracking number?

The tracking number will still save, but the storefront may not generate a clickable tracking link, or it may point to the wrong carrier's tracking page.

Can customers see tracking numbers before the order ships?

No. Tracking information only appears in the customer account and order emails after a shipment has been created and submitted.

Is there a way to automate this without custom development?

Yes โ€” dedicated import/export tools can map order fields on export and read tracking spreadsheets back into Magento automatically, removing the need for manual shipment creation or custom API scripts.

A faster alternative

If your order volume makes manual exports and one-by-one tracking entry unmanageable, a dedicated tool can automate both directions of this workflow. Order Export & Tracking Import lets you configure order-level and item-level field mapping for exports, then automatically create shipments with tracking numbers from a return file โ€” without writing any API scripts.

Order Export & Tracking Import admin configuration in Magento
Order Export & Tracking Import admin configuration in Magento
Order Export profile tab showing field mapping for order number, customer email, B2B fields, and per-item repeat blocks
Order Export profile tab showing field mapping for order number, customer email, B2B fields, and per-item repeat blocks
Whether you stick with native tools or move to an automated solution, keeping export filters tight and carrier names consistent will save you the most time on every fulfillment cycle.

Questions & Answers

No questions yet โ€” be the first to ask.

Ask a question

Public. Shown only after moderation. No spam.