/
/
See which BigCommerce orders have no TickTick task
For operations teams who want to reconcile BigCommerce orders against TickTick tasks, just by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Orders slip through with no follow-up task
To see which BigCommerce orders have a follow-up task, someone lists orders by status and searches TickTick for each order number. Tasks that point at orders in another status or an older window are just as easy to overlook.
Without PopdockAI
- List BigCommerce orders by status
- Search TickTick for every order number
- Keep a tally of orders with and without tasks
- Never notice tasks left for stale orders
With PopdockAI
- Orders for the status and window are read from BigCommerce
- TickTick tasks titled with an order number are paired by that number
- Orders with no task are listed oldest first
- Orphan tasks are listed too, and nothing is written
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Report which BigCommerce orders with status `{order-status}` from the last `{lookback-days}` days (default 14) have no open TickTick task, and which open TickTick tasks point at orders that no longer match. This is read-only.
**Step 1: Read 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`, `billing-email`, `total-including-tax`, `date-created`. If nothing comes back, say so and stop.
**Step 2: Read the tasks (ticktick server)**
Call `ticktick-get-tasks` with `title.contains` set to `Order #`, restricted to `project-name` `{project-name}` when that value is given. Parse the order id from each title that contains `Order #<id>`.
**Step 3: Match**
Match an order to a task when the order id equals the id parsed from the title. Produce three groups: orders with a task, orders with no task, and tasks whose order id is not in the Step 1 list (they may be older, or in another status).
**Step 4: Report**
Give counts for each group, then a table of orders with no task (order id, email, total, date created) sorted oldest first, and a table of orphan tasks (task id, title, project-name, due-date).
**Rules & Guidelines:**
* Tools prefixed bigcommerce- belong to the bigcommerce MCP server. Tools prefixed ticktick- belong to the TickTick MCP server. Both must be connected.
* Do not call any write tool on either server, including `ticktick-add-task`, `ticktick-update-task`, `ticktick-complete-task`, `ticktick-delete-task`, `bigcommerce-customer-update` or `bigcommerce-product-update`.
**Validation:**
* A task title without an `Order #` id cannot be matched; list it under orphan tasks only if it contains the text.
* If the task search returns nothing, report every order as having no task.Who it's for
One answer, three teams that use it
Fulfilment leads
Make sure every open order has an owner
Orders with no task are listed oldest first, so nothing waits without someone on it.
Which BigCommerce orders awaiting shipment from the last 7 days have no TickTick task?
Operations managers
Clean up tasks for orders that moved on
Orphan tasks that point at orders outside the status or window show what can be closed.
Show TickTick tasks for BigCommerce orders that are no longer awaiting fulfillment.
Customer service leads
Check follow-ups on problem orders
Run it for a status like on hold to see which orders nobody is chasing.
Which BigCommerce orders on hold in the last 30 days have no task in the Order Issues project?
How it works
What PopdockAI does when you ask
You give an order status and a lookback window, and your AI assistant pairs BigCommerce orders with TickTick tasks by order number. It only reports.
01
Ask
You give an order status, a lookback window and optionally a TickTick project.
02
Read
It reads the BigCommerce orders and the TickTick tasks titled with an order number.
03
Match
It pairs each order to a task by order number.
04
Report
You get counts and tables of orders with no task and orphan tasks.
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
ticktick-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
Every order without a follow-up, found in one report
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)
