The Scenario
You are a logistics manager. It is Sunday at 11 AM. A severe weather alert went out this morning. The company has decided to cancel tomorrow's delivery run. 80 orders are already loaded into OptimoRoute for Monday and will be picked up by the optimization engine during its overnight run if they are not cleared first.
The order numbers are in your Excel workbook — column A, 80 rows. You need them gone before the planning window opens.
The bad version:
- You log into OptimoRoute, search for the first order number, and click delete. OptimoRoute asks you to confirm. You click confirm.
- 79 more times.
- Around order 40, you accidentally delete an order not on your list — similar order number, different job. You realize 10 rows later and have to re-create it manually.
- It is 1:30 PM. Your Sunday is gone.
The cancellation decision took five minutes. Executing it took two and a half hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the order numbers in column A and deletes them from OptimoRoute in a bulk operation — writing the result back for each row.
Open the SheetXAI sidebar and ask:
Delete all OptimoRoute orders whose order numbers appear in column A of this worksheet — write "deleted" or "not found" into column B for each row.
What You Get
- All 80 order numbers are submitted for deletion in a single batch operation.
- Column B is written with "deleted" for each successful deletion, or "not found" if the order was not present.
- Orders in a completed state return their status in column B rather than failing silently.
- The batch completes in well under a minute. Monday's planning run starts clean.
What If the Data Is Not Quite Ready
The order numbers are in a worksheet named "Cancelled Orders"
Bulk-delete the order numbers listed in the 'Cancelled Orders' worksheet from OptimoRoute — up to 500 at once — and write the result for each row into column B, then write a summary into cell D1 showing how many were deleted, how many were not found, and how many failed.
Some rows should be skipped based on a status flag
Delete all OptimoRoute orders whose numbers appear in column A, but only process rows where column C says "confirmed cancel" — write the deletion result into column D and skip any row where column C is blank or says "pending."
The cancellation list is spread across multiple worksheets by date
Process each worksheet in this workbook — 'Monday,' 'Tuesday,' 'Wednesday' — delete all order numbers in column A from OptimoRoute, and write the result into column B of each respective worksheet.
Cancel orders, verify no priority jobs were caught in the batch, and summarize for the re-plan
Delete all order numbers in column A from OptimoRoute and write the result into column B — then write a summary into cell D1 showing total deleted, not found, and failed — and flag any row in column C where the order number matches a "high priority" tag in the 'Priority List' worksheet so those can be reviewed before re-planning.
Deletion, summary, and priority flag in one prompt. The re-planning conversation starts with the right information.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your cancelled order numbers are listed, then ask it to clear them from OptimoRoute and write the result back for each row. Also see how to bulk-upload replacement orders once conditions clear, and how to trigger route optimization after the new orders are in place.