01
Step 1
Collect order lines with product identifiers, quantities, gross amounts, discount allocations and refunds for the comparison period, and record the merchant's chosen basis for discounts plus the rule for bundle lines.
Back to topic
Spark playbook scenarios · Spark: AI Store Assistant
Measure each product's contribution to revenue
Gross sales say nothing about what a product kept, because discounts and refunds are settled elsewhere in the books. In this case, the immediate task is to measure each product's contribution to revenue. The workflow should produce a contribution breakdown by product whose parts reconcile with the totals the merchant supplies.
Topic
Product Performance Analytics
Target keyword
shopify revenue by product
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 measure each product's contribution to revenue.
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: [order lines with product identifiers, quantities, gross amounts, discount allocations, refunds, the comparison period, and the stated bundle allocation rule]. Attribute net revenue to each product after discounts and refunds under that basis, applying the bundle rule uniformly to every bundle line, then rank each product's contribution against total store revenue.
Return a contribution breakdown by product with the parts reconciled to the supplied totals 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.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.
02
Step 2
Attribute net revenue to each product after discounts and refunds under that basis, applying the bundle rule uniformly to every bundle line, then rank each product's contribution against total store revenue.
03
Step 3
Deliver the contribution breakdown by product with the basis stated, then verify the parts sum to the merchant's supplied total revenue and list any residual difference with its cause, such as unallocated shipping or gift card sales.
FAQ
Common questions when running this scenario
Cover decision rules, frequent misunderstandings, and required inputs so the team aligns on prerequisites before execution.
Should revenue be measured before or after discounts?
State the chosen basis and keep it consistent, because discounts and refunds change which products lead the ranking. Gross figures suit demand questions; net figures answer what each product actually kept.
How should bundles be treated in a contribution report?
Decide once whether bundle revenue is allocated to components or kept with the bundle parent, then apply that rule to every order line. Mixing both treatments double counts revenue and breaks the sum check against the supplied totals.
Does the small long tail matter in this analysis?
Track the combined remainder as one line so attention stays on the products carrying most of the revenue, while keeping the full per-product detail available. The tail becomes decisive when the analysis feeds assortment or discontinuation decisions.
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.