Connectors

/

BigCommerce

/

BigCommerce customer brief with open Todoist tasks
Report
Cross-Connector

Brief yourself on a customer from BigCommerce and Todoist

For sales and account teams who want orders and open internal work on one customer before a call, by asking their AI assistant.

Try PopdockAI free
Get a live demo
BigCommerce customer brief with open Todoist tasks
Brief me on Dana Whitfield, dana@northwindtraders.com, before my call. Check her orders in BigCommerce and any open Todoist tasks about her.
Dana Whitfield of Northwind Traders has 4 orders in the last 90 days and 2 open Todoist tasks. - Orders: 3 paid and shipped, 1 with a partial refund of 45.00 - Task 1: Follow up on refund for order 10482, matched on order number - Task 2: Send Dana the renewal quote, name match only, so it may be someone else - Flag: the refunded order has an open task, but Task 2 is past due Want the full order table?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-customer
bigcommerce-get-order
todoist-get-tasks

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

BigCommerce

BigCommerce
Run it on your own BigCommerce data.

Connect BigCommerce, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Customer data and customer tasks never line up

The customer and their orders are in BigCommerce, and the related tasks are in Todoist, which has no customer field. You search by name and order number and still cannot tell whether a task is about the right person.

Without PopdockAI

  • Look the customer up in BigCommerce by email
  • Read through their recent orders
  • Search Todoist by name, company and order number
  • Judge by eye whether each task is the right customer

With PopdockAI

  • The customer is found by email, and ambiguous matches stop the run
  • Recent orders are listed with status, payment and refunds
  • Todoist is searched by name, company and order number
  • Every task shows how it matched, with weak matches labeled

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Build a brief on the customer with email `{customer-email}`: who they are and what they bought in BigCommerce, and what work is open about them in Todoist, looking back `{lookback-days}` days for orders (default 90).

**Step 1: Find the customer (BigCommerce server)**

Call `bigcommerce-get-customer` with `email` set to `{customer-email}`. If nothing matches, report that and stop. If more than one customer matches, list them and stop. Keep `id`, `name`, `company`, `customer-group-id`, `date-created` and `notes`.

**Step 2: Read their orders (BigCommerce server)**

Call `bigcommerce-get-order` with `customer-id` set to the customer `id` and `date-created.from` set to today minus `{lookback-days}` days. Note `id`, `status`, `payment-status`, `total-including-tax`, `refunded-amount` and `date-created` for each.

**Step 3: Find Todoist work about them (Todoist server)**

Todoist has no customer field, so search text. Call `todoist-get-tasks` with `content.contains` set to the customer `name`, again with the `company` value if there is one, and again with each order `id` from step 2 (limit this to the 5 most recent orders). Merge the results by `task-id`. Keep only tasks where `is-completed` is false. When a name search is the only reason a task matched, mark it "name match only" because it may be about a different person.

**Step 4: Report**

Give: the customer line, a table of orders, a table of open tasks (`task-id`, `content`, `due-date`, `priority`, how it matched), and two flags: orders with `payment-status` not paid or with a non-zero `refunded-amount` that have no open task, and open tasks that are past `due-date`.

**Rules & Guidelines:**

* `bigcommerce-get-customer` and `bigcommerce-get-order` are on the BigCommerce server. `todoist-get-tasks` is on the Todoist server.
* 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 customer has no orders in the window, say so and still search Todoist by name.
* Do not guess a match between systems. Report the match basis for every task.

Who it's for

One answer, three teams that use it

Sales reps

Prepare for the call in one step

See what the customer bought and what is open about them internally, so you do not discover a pending refund mid call.

Brief me on tom.reyes@fabrikam.com before our 2pm call: BigCommerce orders for 60 days and any open Todoist tasks.

Customer success managers

Spot orders nobody is following up

Find unpaid or refunded orders with no open task and tasks already past due, so loose ends are caught early.

For priya@contoso.com, list recent BigCommerce orders and flag any problem orders that have no Todoist task.

Support leads

Check what the team has already logged

See the open Todoist tasks tied to a customer's orders before you start something new, so work is not duplicated.

Is there open Todoist work about customer sam@northwindtraders.com or their latest orders in BigCommerce?

How it works

What PopdockAI does when you ask

You give an email and your AI assistant reads from BigCommerce first, then searches Todoist. It never writes to either system, so the brief is safe to run before any call.

Ask

You give the customer's email and, optionally, how far back to look.

Your AI tool

Find

It finds the customer and their recent orders in BigCommerce.

bigcommerce-get-customer
bigcommerce-get-order
todoist-get-tasks

Search

It looks in Todoist for open tasks naming the customer, company or recent orders.

No items found.

Report

You get the orders, the open tasks with how each matched, and two flags.

Your AI tool

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.

get-data

bigcommerce-get-customer

Returns customers from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
get-data

bigcommerce-get-order

Returns orders from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
get-data

todoist-get-tasks

Returns tasks from Todoist.
Read only.Nothing in BigCommerce Changes

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.

How Popdock AI secures your data

The outcome

One brief instead of two searches

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation