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

Track prices for comparable competitor products

Price comparisons drawn from unlike pack sizes and specifications mislead more than they inform. In this case, the immediate task is to track prices for comparable competitor products. The output should record each observed price with its date, currency and the shipping or promotion conditions shown beside it.

Topic
Competitor Research and Monitoring
Target keyword
shopify competitor price tracking
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 prices for comparable competitor 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: [merchant SKUs paired with competitor offers on size, pack and specification, each offer's listed price, currency, tax-inclusive flag, shipping terms, promotional conditions and observation date, plus the offers left unmatched]. Log a price change only where both rows are the same pairing and the currency and shipping terms are unchanged, setting aside offers whose promotion or bundle conditions moved so an altered total is not read as a change in the listed price.
Return a competitor change log and specific opportunities to investigate dropping offers that are not truly comparable 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

Pair each merchant SKU with a competitor offer on size, pack and specification, recording every offer left unmatched, then capture each offer's listed price, currency, whether tax is included, its shipping terms, promotional conditions and the date observed.

02

Step 2

Log a price change only where both rows are the same pairing and the currency and shipping terms are unchanged, setting aside offers whose promotion or bundle conditions moved so an altered total is not read as a change in the listed price.

03

Step 3

Deliver a dated price log carrying the effective total beside the listed price with unmatched offers listed by reason, verify that every tracked SKU has a row for each observation pass, and restate comparisons drawn from partly matched pairs as indicative rather than like-for-like.

FAQ

Common questions when running this scenario

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

Why pair variants before recording any price?

Offers differing in size, pack or specification are not the same product, so a gap between them reflects the variant rather than a real move. Pairing on those attributes first means every logged change compares two genuinely equivalent rows.

Are promotional prices worth recording?

Yes, with the conditions displayed beside them and the regular price alongside whenever it is visible. Comparing a promotional total against another seller's standard price produces a gap that vanishes the moment the promotion ends, misleading anyone acting on it.

How do shipping terms enter the comparison?

As part of the effective total rather than as a footnote. Listed price, shipping charge and any free-shipping threshold together decide what the shopper pays, and that total can move while the listed price stays exactly where it was.

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.