Turnover was calculated differently in the last two reviews, so the results cannot be compared across periods. In this case, the immediate task is to analyze inventory turnover using a consistent basis. The workflow should produce an inventory health analysis and prioritized actions, applying one documented formula to every SKU and holding the basis steady.
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 analyze inventory turnover using a consistent basis.
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: [cost of goods sold per SKU at the merchant's cost basis, opening and closing stock values on the same basis, the period length, and the merchant's documented turnover formula]. Compute turnover as cost of goods sold for the period divided by average stock value, taking average stock as the mean of opening and closing values, apply that one formula to every SKU without switching basis part way down the list, and mark SKUs with no stock value at either boundary as not comparable rather than giving them a rate.
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.Split the work into input, judgment, and deliverable phases. Verify each step's output before moving to the next.
Collect, per SKU and for one agreed period, cost of goods sold at the merchant's cost basis, the opening and closing stock values measured on that same basis, the number of periods the figure covers, and the turnover formula the merchant has documented.
Compute turnover as cost of goods sold for the period divided by average stock value, taking average stock as the mean of opening and closing values, apply that one formula to every SKU without switching basis part way down the list, and mark SKUs with no stock value at either boundary as not comparable rather than giving them a rate.
Deliver an inventory health analysis showing the rate with its numerator and denominator on every row so the basis stays visible, add prioritized actions, reconcile total cost of goods sold with the merchant's sales and cost records, and note any SKU measured on a basis that differs from the earlier review.
Cover decision rules, frequent misunderstandings, and required inputs so the team aligns on prerequisites before execution.
As the mean of the opening and closing stock values for the period, both taken at the same cost basis. A closing-only figure penalises a SKU that was building stock up, and mixing bases between the two boundaries moves the rate without any real change in what is held.
Because the report exists for comparison: if some SKUs are cost-based and others unit-based, the ranking measures the choice of formula rather than the stock. The documented formula is applied unchanged to every row and any deviation is listed as a caveat beside the rate.
When the SKU has no stock value at either boundary, when the period's movements are mostly adjustments rather than sales, or when an earlier review used a different basis. Such SKUs are listed with their raw values and the reason, not ranked against SKUs measured on the full basis.
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.