Ciwi
Back to topic
Spark playbook scenarios · Spark: AI Store Assistant

Track changes among publicly visible best-selling products

Public rankings are captured sporadically, so a snapshot says nothing about how long a product has held its position. In this case, the immediate task is to track changes among publicly visible best-selling products. The workflow should produce a movement log with dates attached, noting entries where the supplied data is incomplete.

Topic
Product Research and Market Opportunities
Target keyword
track best selling products
Copyable AI prompt

A prompt you can drop directly into Spark

First replace every [bracketed] placeholder with real store scope and constraints, then add any actual records or data you have, and paste it into your preferred AI assistant or Spark agent. Spark will follow this page's workflow to produce structured output and verification steps.

ai-prompt.txt
Act as a Shopify operations specialist.
Help me track changes among publicly visible best-selling products.
My store context is [describe the business, products and target audience].

My scope is [specify the affected products, pages, customers or reporting period]. Use these inputs: [dated best-seller list snapshots, the tracked category scope, capture schedule notes, and per-capture product positions].

Compare product positions across capture dates to log which entries hold rank, which rise and which fade, treating visible rank as an indicator rather than confirmed sales and flagging products that appear in some captures but not others.
Return a movement log with dates attached and a note on entries where the supplied data is incomplete for the specified task.
Show the relevant evidence or before-and-after examples and explain how I can verify the result.
If essential data is missing, ask for it and mark unsupported conclusions as unknown.
Do not invent metrics, product claims or customer facts.
For any publication, message, account or store change, use only connected tools within my explicitly authorized scope and report success only after verification; otherwise provide the draft or proposed steps.
Use in Spark
How to solve

A recommended resolution workflow

Split the work into input, judgment, and deliverable phases. Verify each step's output before moving to the next.

01

Step 1

Collect the public best-seller list snapshots with each capture's date, the categories tracked, and the store's product scope, noting any capture dates that are missing or unevenly spaced in the supplied data.

02

Step 2

Compare product positions across capture dates to log which entries hold rank, which rise and which fade, treating visible rank as an indicator rather than confirmed sales and flagging products that appear in some captures but not others.

03

Step 3

Deliver a dated movement log per tracked product with its position at each capture, its direction of movement and the gaps in the capture schedule, then verify every logged position against the original snapshots before drawing any conclusion.

FAQ

Common questions when running this scenario

Cover decision rules, frequent misunderstandings, and required inputs so the team aligns on prerequisites before execution.

What does a best-seller rank actually indicate?

Visible rank on the platform, not confirmed unit sales, so it serves as a comparative indicator between products on the same list; it is never converted into a sales figure, and each logged position keeps its capture date attached.

Why compare captures instead of saving the current top list?

Because movement shows which products are gaining or fading while a single snapshot freezes one moment; the log answers how long a product has held its position, which is the question a sporadic capture cannot.

How are gaps in the capture schedule handled?

Gaps between snapshots are recorded alongside the movements, so a jump in rank is never read as gradual change, and products missing from some captures are flagged rather than treated as newly debuted; conclusions spanning a gap carry a note naming it.

Related scenarios

Continue with adjacent or same-topic scenarios

Start with scenarios under the same topic, then expand into cross-topic matches suggested by similarity.

Next step

Want these AI scenarios embedded directly into daily operations?

Ciwi Spark builds Shopify-native AI tools and agents around the workflows merchants actually run: research, ads, translation, and customer support. Stop rewriting the same prompts by hand.

Open Spark product pageBack to Spark scenario library