01
Step 1
Collect current stock per SKU, the demand recorded over the comparison period, the units already on order or committed, supplier lead times, and the merchant's stated margin floor, storage limit and vendor return terms.
Back to topic
Spark playbook scenarios · Spark: AI Store Assistant
Assess excess inventory and possible actions
Surplus stock is known to exist, but no option has been weighed against margin, storage space and vendor terms. In this case, the immediate task is to assess excess inventory and possible actions. The workflow should produce an inventory health analysis and prioritized actions, quantifying the surplus against expected demand before recommending one.
Topic
Inventory Analysis and Turnover
Target keyword
shopify excess inventory analysis
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 assess excess inventory and possible actions.
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: [current stock per SKU, demand recorded over the comparison period, committed inbound units, supplier lead times, and the merchant's stated margin floor, storage limit and vendor return terms]. Quantify surplus as stock on hand plus committed inbound units minus the demand expected over the coverage period the merchant names, then test each disposal option against the margin floor, the storage limit and the vendor terms, rejecting any option that would push a SKU below the floor or breach those terms.
Return an inventory health analysis and prioritized actions 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
Quantify surplus as stock on hand plus committed inbound units minus the demand expected over the coverage period the merchant names, then test each disposal option against the margin floor, the storage limit and the vendor terms, rejecting any option that would push a SKU below the floor or breach those terms.
03
Step 3
Deliver an inventory health analysis with one recommended action per surplus SKU together with the surplus quantity and the constraint that ruled out each rejected option, rank the actions by capital released, and reconcile surplus quantities with the inventory export and open purchase orders before publishing.
FAQ
Common questions when running this scenario
Cover decision rules, frequent misunderstandings, and required inputs so the team aligns on prerequisites before execution.
How is the surplus quantity defined?
Stock on hand plus units already committed inbound, less the demand expected over the coverage period the merchant sets. Counting only stock on hand understates surplus while a purchase order is still arriving, so the coverage period is stated on every row and the figure can be recomputed later.
Does cancelling the next order clear the excess?
No, because inbound commitments and stock already held are separate decisions: cancelling a future order stops the problem growing but leaves the existing units untouched. The report gives the existing surplus its own action and treats order reduction as a separate recommendation.
Why not simply discount every surplus SKU?
Because the margin floor, the storage limit and the vendor terms each rule options out. Where terms allow, bundling, deferred reordering or a supplier return may release the same capital without cutting price, and every rejected option is recorded with the constraint that killed 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.