The Scenario
You are a logistics coordinator at a retailer that uses a courier aggregator that does not integrate directly with BaseLinker. Your courier system generates tracking numbers for each shipment and exports them to an Excel workbook. You have 200 rows: column A is the order ID, column B is the courier code, column C is the tracking number.
Every one of those tracking numbers needs to be registered in BaseLinker as a package entry, so that the order record is complete, customer-facing tracking links work, and the marketplace can confirm dispatch.
The bad version:
- Open BaseLinker, find the first order by order ID
- Navigate to the packages section
- Select the courier from the dropdown
- Paste the tracking number
- Save, go back, find the next order
- After ninety minutes you have done 60 orders. The 140 remaining orders are sitting with no tracking number in BaseLinker. The marketplace flags late dispatch confirmations.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the tracking workbook and registers every package in BaseLinker in one batch, so you do not have to navigate the order UI at all.
Open the SheetXAI sidebar and type:
For every row in this workbook, create a manual package entry in BaseLinker with order ID from column A, courier name from column B, and tracking number from column C. Write "registered" or the error message into column D for each row.
SheetXAI reads every row, calls BaseLinker's package creation API, and writes the result back to column D. All 200 tracking numbers registered while you handle something else.
What You Get
200 BaseLinker package entries, registered in one prompt:
- Order ID — each package linked to the correct order
- Courier code — mapped from your courier system's format
- Tracking number — registered and live in BaseLinker
- Result column D — "registered" for successes, error details for failures
BaseLinker now shows tracking information on every order. Customers get tracking links. Marketplaces see the dispatch confirmation.
What If the Data Is Not Quite Ready
Tracking exports from courier aggregators are rarely clean. SheetXAI handles the mapping and the registration in the same prompt.
When the courier codes in your workbook do not match BaseLinker's courier codes
Your system exports courier names like "DHL Express" but BaseLinker expects a short code like "dhl_express."
Map the courier names in column B of this workbook to BaseLinker courier codes: "DHL Express" → "dhl_express", "UPS Standard" → "ups_standard", "FedEx Priority" → "fedex_priority". Then register packages in BaseLinker using the mapped codes, order IDs from column A, and tracking numbers from column C. Write "registered" or the error into column D.
When some rows have duplicate tracking numbers
The courier system occasionally duplicates a row.
Deduplicate this workbook by tracking number (column C), keeping the first occurrence of each. Then register BaseLinker packages for all remaining rows: column A = order ID, column B = courier code, column C = tracking number. Write the result into column D.
When some order IDs have already had a package registered
You want to skip orders that already have a package in BaseLinker to avoid duplicates.
For each row in this workbook, check whether a package already exists in BaseLinker for the order ID in column A. If one already exists, write "already registered" into column D and skip. If not, register the package and write "registered" into column D.
When you need to pull untracked orders, match them to the courier workbook, register packages, and log results in one pass
You do not have a clean list of what needs to be registered.
Fetch all BaseLinker orders in status 5678 (Shipped) that have no package registered yet. Write their order IDs into column A of this workbook. Then look up each order ID in the Courier Export tab (column A = order ID, column B = courier code, column C = tracking number). For any order ID found there, register the package in BaseLinker and write "registered" in column D. For any not found, write "no tracking data" in column D.
The pattern: reconcile and register in one prompt, not in separate steps.
Try It
Get the 7-day free trial of SheetXAI and open your tracking number export workbook, then ask it to register the packages in BaseLinker. The BaseLinker integration is included in every SheetXAI plan. For related workflows, see how to batch-update order statuses or the BaseLinker in Excel overview.