A merchant knows which items sell fastest but not how long the remaining stock will last against that demand. In this case, the immediate task is to check stock coverage for best-selling products. The workflow should produce a coverage reading per best seller, ranked by which one runs out first given the lead times on record.
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.
Act as a Shopify operations specialist.
Help me check stock coverage for 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: [units sold per product over an explicitly stated period, current sellable quantities, replenishment lead times on record, and inbound quantities with expected dates]. Compute each product's coverage by dividing sellable quantity by the demand rate observed over the stated period, rank the products by the date each would run out with any inbound receipt counted, and flag as needing action now any product whose run-out date falls before its replenishment lead time elapses.
Return a coverage check for best sellers with priority ranks 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.Split the work into input, judgment, and deliverable phases. Verify each step's output before moving to the next.
Identify the fastest-selling products from the sales records for a period stated explicitly, with the units sold and the sellable quantity now on hand, the replenishment lead time on record per product and any inbound quantity with its expected date.
Compute each product's coverage by dividing sellable quantity by the demand rate observed over the stated period, rank the products by the date each would run out with any inbound receipt counted, and flag as needing action now any product whose run-out date falls before its replenishment lead time elapses.
Deliver a coverage check per best seller showing units sold, quantity on hand, demand rate, coverage days, run-out date and priority rank, note which products were ranked on a period containing a promotion or a stockout that distorts the rate, and reconcile the products ranked against the sales export for the stated period.
Cover decision rules, frequent misunderstandings, and required inputs so the team aligns on prerequisites before execution.
One the merchant states explicitly, with the start and end written on the report so the ranking can be reproduced later. Changing the period silently changes which products appear, and a period containing a promotion or a stockout distorts the rate.
Keep them separate, because the question for a fast seller is whether coverage outlasts the lead time while a slow mover's risk is obsolescence rather than run-out. Mixing them buries the products that would actually stop revenue.
A run-out date earlier than its replenishment lead time, using the figures in the records rather than an impression of speed. Where an inbound receipt lands before that date the exposure disappears, so receipts are counted before the flag is raised.
Start with scenarios under the same topic, then expand into cross-topic matches suggested by similarity.
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.