The Scenario
You run e-commerce operations across three marketplace storefronts. Every morning at 7 AM, before the warehouse opens, your team needs a pick list: every unprocessed order from the overnight shift, with product SKUs, quantities, and shipping addresses, in one place.
BaseLinker has all of it. But getting it into an Excel workbook requires logging in, configuring an order filter, exporting a CSV, opening the file in Excel, adjusting the column headers, and sharing the file with the warehouse team. On a slow morning that takes twenty-five minutes. On a morning with 200 overnight orders, it takes longer.
The bad version:
- Log into BaseLinker, navigate to orders, configure the filter for unconfirmed orders
- Export the CSV, wait for it to download
- Open the file in Excel, fix the column headers to match what the warehouse expects
- Remove columns the warehouse does not need
- Save the file to SharePoint and share the link
- The warehouse starts fifteen minutes late and the first courier pickup is tight.
The fast version is one prompt while the coffee is still brewing.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads BaseLinker directly, so you do not have to touch the BaseLinker UI to get your morning pick list.
Open the SheetXAI sidebar and type:
Fetch all unconfirmed BaseLinker orders from the last 7 days and write order ID, customer name, email, product SKUs, quantities, and shipping address into this workbook starting at row 2. One row per order, sorted by order date ascending.
SheetXAI calls the BaseLinker orders API, paginates through all results, and fills the workbook. The warehouse team opens the same shared Excel file they always open. The data is already there.
What You Get
A clean pick list with every unconfirmed order, ready for the warehouse:
- Order ID — linked to the BaseLinker order record
- Customer name and email — for any shipping queries
- Product SKUs and quantities — what to pull from the shelves
- Shipping address — where it is going
- Order date — sorted ascending so the oldest orders are fulfilled first
The workbook is your authoritative morning handoff document. The warehouse team does not need BaseLinker access. They work from the Excel file, mark orders as picked, and the coordinator updates BaseLinker at the end of the shift.
What If the Data Is Not Quite Ready
Real order data is rarely as clean as a single-filter export. SheetXAI handles the edge cases in the same prompt.
When orders come from multiple status IDs
Your unconfirmed orders span three different BaseLinker status IDs depending on the marketplace.
Fetch BaseLinker orders with status IDs 1001, 1002, and 1003 from the last 7 days. Combine them into one list and write order ID, marketplace name, customer name, SKUs, quantities, and shipping address into this workbook starting at row 2.
When the warehouse wants products as separate rows, not comma-separated
The warehouse uses a scanner system that needs one SKU per row.
Fetch all unconfirmed BaseLinker orders from the last 24 hours. For each order, create one row per product line: column A = order ID, column B = customer name, column C = SKU, column D = quantity, column E = shipping address.
When you want to exclude orders already assigned to a courier
You only want orders that have not been assigned to a courier yet.
Fetch all unconfirmed BaseLinker orders from the last 7 days where no package has been created yet. Write order ID, customer name, SKUs, quantities, and shipping address into this workbook starting at row 2.
When you need the full picture: pull orders, flag problems, and create the pick list in one go
Some orders are missing a shipping address. Some have a product quantity of zero. You want to flag those instead of sending the warehouse a broken list.
Fetch all unconfirmed BaseLinker orders from the last 24 hours. Write order ID, customer name, SKUs, quantities, and shipping address into this workbook starting at row 2. In column F, write "OK" if the row is complete and ready to pick, or a short note describing the problem if something is wrong. Sort so the OK rows come first.
The pattern: instead of exporting and then manually reviewing for problems, you ask SheetXAI to pull the data and flag issues in the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, then ask it to fetch your open BaseLinker orders and write them in. The BaseLinker integration is included in every SheetXAI plan. For a related workflow, see how to batch-update order statuses from a workbook or the BaseLinker in Excel overview.