This article explains how to add tracking information to many orders at once using a CSV import. This is useful when your fulfillment house sends a shipment export or manifest, because you can copy that data into the import file instead of entering tracking numbers one order at a time.
Build the Import File
Required Fields
Your import file needs six columns in the order below.
Column A – id: The Offset order number. Use the number exactly as it appears in Offset, without any prefixes or suffixes your fulfillment house adds (for example, -1 or -2).
Column B – TrackingNumber: The shipment tracking number.
Column C – DateShipped: The ship date, formatted as YYYY-MM-DD (for example, 2026-10-09).
Column D – ShipToName: The recipient’s first and last name.
Column E – Carrier: The full carrier name, matching the options shown when you add a tracking number manually (for example, UPS, FedEx, or GLS). Abbreviations such as FEX will not import.
Column F – ShipMethod: The shipping service (for example, Ground, Overnight, Priority Overnight, or 2Day Air).
IMPORTANT: Column headers are case-sensitive and must match exactly. The id header must be all lowercase, and the remaining headers must keep their capital letters. If any header doesn’t match, the upload will fail.
NOTE: Every column is required for each row. Add one row per tracking number.
Save the File as a CSV
The import only accepts comma-separated (.csv) files. In Excel, select File > Save As and choose CSV (MS-DOS). Files in other formats, such as .xlsx or Apple Numbers, will not import.
Fix Tracking Numbers That Display as Exponents
Excel sometimes converts long tracking numbers, especially FedEx numbers, into scientific notation (for example, 4.3563E+11). If you upload them this way, the tracking links on your orders won’t work.
Select the TrackingNumber column
Right-click and select Format Cells
Choose Number and set decimal places to 0
Widen the column and confirm the full tracking numbers display
Save the file and keep it open while you upload
IMPORTANT: CSV files don’t save formatting. If you close and reopen the file before uploading, Excel converts the tracking numbers back to exponents. Keep the file open on your screen during the upload.
In the example below, the top entry was uploaded after the file was closed. The second entry shows the correct result, uploaded while the file was still open.
Upload Tracking Numbers
Run a Test Upload
IMPORTANT: Before uploading a full file, run a test with 2–3 rows and confirm the tracking information appears correctly on those orders. If a full upload contains errors, the tracking information has to be removed from each order individually on its order details page.
Import the File
In Offset, go to the Orders page
Select the Actions dropdown in the upper right
Select Import Tracking Numbers
Upload your CSV file
Open a few of the updated orders to confirm the tracking information populated
Please note that the Import Tracking Numbers is for CSV uploads. If your fulfillment house sends tracking information to ShipCompliant, use Import ShipCompliant Tracking action instead.
Reuse Your Template
Save a blank copy of your file as a template. For each new round of shipments, paste in the new data and save it as a new file with the date in the name, so you have a record of each upload.