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 a spreadsheet. 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 sheet 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:
Register shipping packages in BaseLinker for each row in this sheet: column A = order ID, column B = courier code, column C = tracking number. Process all 200 rows and 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. You do not need to log into BaseLinker or touch a single order manually.
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 sheet 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 sheet 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, with 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. You do not want to register the same tracking number twice.
Deduplicate this sheet 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 creating duplicates.
For each row in this sheet, 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 with the courier code from column B and tracking number from column C, then write "registered" into column D.
When you need to pull the untracked orders, match them to the courier sheet, register packages, and log results in one pass
You do not have a clean list of what needs to be registered. You want SheetXAI to figure it out.
Fetch all BaseLinker orders in status 5678 (Shipped) that have no package registered yet. Write their order IDs into column A of this sheet. 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 in the Courier Export tab, register the package in BaseLinker and write "registered" in column D. For any order ID not found in the Courier Export tab, write "no tracking data" in column D.
The pattern: instead of managing two lists and a registration step separately, you ask SheetXAI to reconcile and register in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your tracking number export sheet, 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 Google Sheets overview.