Connectors

/

BigCommerce

/

BigCommerce customer brief with TickTick tasks
Report
Cross-Connector

Brief yourself on a BigCommerce customer before the call

For sales teams who want a customer brief from BigCommerce orders and TickTick tasks, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
BigCommerce customer brief with TickTick tasks
Give me a brief on jordan@contoso.com before my call, looking back 90 days, with their BigCommerce orders and any TickTick tasks.
Jordan Lee at Contoso has 4 orders in the last 90 days and 2 related open tasks. - Orders: 4, lifetime total 3,180.00, refunded 240.00 - Latest order: 1042, shipped, 21 Oct - Task: Order #1038 refund follow-up, due 28 Oct, matched on order number - Observation: the refunded order has a task but no recent comment Want the full order table?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-customer
bigcommerce-get-order
ticktick-get-tasks
ticktick-get-task-comments

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

Call prep means reading orders and hunting through tasks

Before a customer call you read their details and orders in BigCommerce, then search your task list for anything that mentions them. Putting the two together takes time, and a refund or an open task is easy to miss.

Without PopdockAI

  • Look up the customer and orders in BigCommerce
  • Search TickTick by name and by order number
  • Read comments to see if a task really is about them
  • Miss a refund or an open follow up

With PopdockAI

  • The customer is found in BigCommerce and it stops if the match is unclear
  • Orders over the lookback window are read and totalled
  • Only TickTick tasks that mention the email, name or an order are kept
  • Nothing is written to either system

The prompt

Use this prompt

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

Prompt
**Objective:** Produce a brief for the customer with email `{customer-email}`, combining their BigCommerce order history with the TickTick work that mentions them, looking back `{lookback-days}` days (default 90). This is read-only.

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

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

**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. Keep `id`, `status`, `payment-status`, `total-including-tax`, `refunded-amount`, `date-created`.

**Step 3: Find related TickTick work (ticktick server)**

Call `ticktick-get-tasks` with `title.contains` set to the customer's last name, then again for each order id as `Order #<id>`. Combine the results and drop duplicates by task id. For each task found, call `ticktick-get-task-comments` with `task-id` set to the task id and keep the comment text and created-time.

**Step 4: Report**

Give: customer details, an order table with totals, lifetime total and refunded total over the window, then a task table (task id, title, project-name, status, due-date) with the latest comment under each. End with up to three observations, such as a refunded order with no task.

**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-comment`, `ticktick-add-task` and `bigcommerce-customer-update`.

**Validation:**

* A last-name search can match unrelated tasks; only include a task when its title or comments also mention the email, the full name or an order id, and say which one matched.
* If the customer has no orders in the window, say so and still report the tasks.

Who it's for

One answer, three teams that use it

Account managers

Walk in knowing what is open

Recent orders and the tasks you promised appear together, so nothing outstanding catches you out.

Give me a brief on sam@fabrikam.com with their BigCommerce orders and any TickTick tasks about them.

Sales reps

Remember every follow up you owe

Tasks that mention the customer or their orders are pulled in with their comments.

What TickTick tasks do I have for dana@northwindtraders.com, and what have they ordered in the last 30 days?

Small business owners

Prepare for a customer call in one ask

One page covers who they are, what they bought and what is pending, without opening two apps.

Brief me on lee@contoso.com for the last 180 days, orders and tasks.

How it works

What PopdockAI does when you ask

You give a customer email and your AI assistant gathers their BigCommerce orders and related TickTick tasks. You get a one-page brief and nothing is changed.

01

Ask

You give a customer email and, if you like, a lookback window.

Your AI tool

02

Find

It finds the customer in BigCommerce and stops if the match is unclear.

bigcommerce-get-customer

03

Gather

It reads their orders and the TickTick tasks and comments that mention them.

bigcommerce-get-order
ticktick-get-tasks
ticktick-get-task-comments

04

Report

You get a one-page brief with totals, tasks and up to three observations.

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

ticktick-get-tasks

Returns open TickTick tasks with their project, due date, priority, status, assignee and tags. Filter by project, due date range or status.
get-data

ticktick-get-task-comments

Returns the comments on a TickTick task with author and time.
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

Orders and open tasks in one brief before the call

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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