Order matching tutorial
All guides

Extract tracking numbers and order numbers from shipping labels

Upload label PDFs, detect tracking numbers, mark the order number field, save the layout as a template, and export a clean file for Shopify, ERP, WMS, Amazon, TikTok Shop, Temu, or SHEIN.

A label PDF may already contain both the carrier tracking number and the marketplace or store order number, but they are trapped inside printable pages.

When tracking numbers need to be uploaded back to Shopify, ERP, WMS, Amazon, TikTok Shop, Temu, or SHEIN, each row needs the right tracking number beside the right order number.

Copying by hand is slow and easy to mismatch. A field template makes repeated label layouts much faster to process.

Fields to capture for shipment updates

Keep the first version simple: tracking number plus order number. Add more fields only when the destination system needs them.

Tracking number

The carrier number used for shipment updates and tracking lookup.

Order number

The store, marketplace, ERP, or WMS order ID that tells you which order the tracking number belongs to.

Reference number

Helpful when labels use reference IDs instead of visible marketplace order numbers.

Service or carrier

Useful for filtering rows before importing or checking exceptions.

Steps
1
Upload the label PDF

Use labels exported from Shopify, Amazon, TikTok Shop, Temu, carrier portals, ShipStation, or other shipping platforms.

2
Detect tracking numbers

Review the detected tracking number column first, because it is the core value used for shipment updates.

3
Mark the order number

Draw a box around the printed order number or reference field on a sample label.

4
Save a template

For the same label layout, reuse the saved field position instead of marking the order number again.

5
Export CSV or Excel

Export a spreadsheet with tracking number and order number columns, then import or copy it into your fulfillment workflow.

Where this spreadsheet is useful

Shopify fulfillment

Match each order number with the right tracking number before updating fulfillment records.

ERP or WMS import

Prepare a clean CSV or Excel file for warehouse, ERP, or order management systems.

Marketplace upload

Use the file for marketplace workflows such as Amazon, TikTok Shop, Temu, or SHEIN.

Related links

FAQ
Can I extract tracking numbers and order numbers into the same row?

Yes. Detect the tracking number, mark the order number field, review the batch, and export both columns into CSV or Excel.

What if the order number is in a different place on each label?

This workflow works best when labels share a fixed layout. If the order number moves a lot, review results carefully and split files by layout when possible.

Can I use the export for Shopify, ERP, or WMS?

Yes. Export CSV or Excel, then adjust column names or file format if your destination system has a specific import template.

Do I need to mark the order number every time?

No. If the label layout is fixed, save the field position as a template and reuse it on later batches.

Start with your label files

Upload shipping label PDFs, extract tracking numbers and custom fields, then export Excel or CSV.

Open Label Data Extractor