/
/
Find BigCommerce orders that nobody has a Todoist task for
For operations teams who want to see which orders in a status have no follow-up by asking their AI assistant to compare BigCommerce with Todoist.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Nobody knows which orders have no owner
Orders stuck in a status are compared against the task list by hand. The untracked ones are only found when a customer complains.
Without PopdockAI
- List orders in a status in BigCommerce
- Search Todoist for each order number
- Rule out partial matches by eye
- Note which orders have no task
With PopdockAI
- Orders in your status and window are listed
- Todoist is searched for each order id
- A task counts only on a whole-number match
- An empty Todoist read is flagged as suspect
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find BigCommerce orders with status `{order-status}` (default "Awaiting Fulfillment") created in the last `{lookback-days}` days (default 14) that no Todoist task refers to.
**Step 1: List the orders (BigCommerce server)**
Call `bigcommerce-get-order` with `status` set to `{order-status}` and `date-created.from` set to today minus `{lookback-days}` days. Keep `id`, `date-created`, `total-including-tax`, `currency-code`, `payment-status`, `billing-last-name` and `billing-email`. If none come back, report that and stop.
**Step 2: Read the tasks (Todoist server)**
Call `todoist-get-tasks` for open tasks (`is-completed` false), with `content.contains` set to each order `id`. When there are more than 30 orders, instead read all open tasks once with a large `max-records` and search their `content` and `description` text yourself. Count a task only when the order id appears as a whole number.
**Step 3: Report**
Table of orders with no task: `id`, date, total, payment status, billing last name. Then a second table of orders that do have tasks: `id` and the `task-id` values. End with the counts.
**Rules & Guidelines:**
* `bigcommerce-get-order` is on the BigCommerce server. `todoist-get-tasks` is on the Todoist server.
* Report only; do not offer to create tasks in this run.
* Do not call any Todoist action tool (`todoist-add-task`, `todoist-update-task`, `todoist-close-task`, `todoist-reopen-task`, `todoist-delete-task`, `todoist-add-task-comment`, `todoist-add-project`, `todoist-add-section` or any other add, update, close, archive or delete tool) and do not call any BigCommerce add, update or delete tool. This prompt only reads.
**Validation:**
* If the status text matches no orders, say which status values you saw in a quick `bigcommerce-get-order` read and stop.
* If Todoist returns no tasks at all, report every order as untracked and note that the Todoist read may have failed.
Who it's for
One answer, three teams that use it
Operations managers
See which orders have no owner
Get the orders in a status that no task refers to, with the total and payment status to help you prioritise.
Which BigCommerce orders in Awaiting Fulfillment have no Todoist task? Look at the last 14 days.
Support team leads
Check that follow-up has not been missed
Compare a status against Todoist so customers are contacted before they write in.
List BigCommerce orders in Awaiting Payment from the past week that no Todoist task mentions.
E-commerce managers
Audit your order handling
Run it once a week to see how many orders in a status are tracked and how many are not.
How many Awaiting Shipment orders in BigCommerce from the last 30 days have a task in Todoist?
How it works
What PopdockAI does when you ask
You pick the status and window. Your AI assistant reads BigCommerce and Todoist and reports the gap. It does not create or change anything.
Ask
You give the order status and how many days back to look.
Read
It lists the matching BigCommerce orders and searches open Todoist tasks for each order id.
Report
It shows the orders with no task, then those with tasks, and the counts.
What PopdockAI provides
The tools behind the answer
Ready made tools for BigCommerce and one secure connection to your AI tool. No code, no exports.
bigcommerce-get-order
todoist-get-tasks
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Spot the untracked orders at a glance
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
