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

Assess whether sourcing and delivery constraints support a product

A product looks attractive on cost until freight, lead time and packaging are tested against the destination. In this case, the immediate task is to assess whether sourcing and delivery constraints support a product. The workflow should produce a sourcing feasibility matrix and follow-up questions, isolating the constraints that make the product impractical.

Topic
International Product Sourcing
Target keyword
product sourcing logistics 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 whether sourcing and delivery constraints support a product.
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: [quoted freight options with their transit legs and handling path, the supplier's stated production lead time, packed dimensions and protection requirements, and the delivery promise made to shoppers in that destination]. Add production lead time, every transit leg and the customs or transfer handling on each option's path into one door-to-door timeline, compare that timeline against the stated delivery promise, and mark as impractical any option whose packed volume, weight class or protection requirement the quoted service cannot carry instead of comparing freight rates alone.
Return a sourcing feasibility matrix and follow-up questions 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

Collect the freight options quoted for the destination, each option's transit legs and handling path, the supplier's stated production lead time, the packaging dimensions and protection requirements as packed, and the delivery promise the merchant makes to shoppers in that destination.

02

Step 2

Add production lead time, every transit leg and the customs or transfer handling on each option's path into one door-to-door timeline, compare that timeline against the stated delivery promise, and mark as impractical any option whose packed volume, weight class or protection requirement the quoted service cannot carry instead of comparing freight rates alone.

03

Step 3

Deliver a sourcing feasibility matrix ranking the options by whether the timeline meets the promise and by landed cost per sellable unit, name the single constraint that makes the product impractical where no option qualifies, and reconcile every quoted rate and transit figure with the supplied quote 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.

What belongs in a door-to-door lead time?

Production time at the supplier, every transit leg, and the customs or transfer handling on the chosen path, all added together. Quoting only the longest leg understates elapsed time, and the merchant's promise is measured against the total, so the option that looks fastest in transit can still miss the date.

Why compare landed cost per sellable unit?

Because freight is charged on chargeable weight or volume, not on units sold, so a carton that ships partly empty raises the real cost of every unit inside it. Dividing landed cost by the units that arrive sellable keeps packaging and damage allowance inside the same comparison as the freight rate.

When is a route impractical rather than just expensive?

When its total timeline cannot meet the stated delivery promise, or when the service will not carry the packed dimensions, weight class or protection requirement at all. Cost then stops mattering, and the constraint is named in the matrix so the merchant can change the packaging, the destination or the product instead.

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.