01
Step 1
Start with existing SKUs, product and variant IDs, naming convention and connected-system mappings.
Back to topic
Spark playbook scenarios · Spark: AI Store Assistant
Detect duplicate SKUs and identify affected variants
A catalog manager cannot reliably match products across systems because SKUs are missing, duplicated or inconsistent. In this case, the immediate task is to detect duplicate SKUs and identify affected variants. The workflow should produce a unique SKU mapping and collision report, using the merchant's actual records and constraints.
Topic
SKU Generation and Cleanup
Target keyword
shopify duplicate sku checker
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 detect duplicate SKUs and identify affected variants.
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: [provide existing SKUs, product and variant IDs, naming convention and connected-system mappings].
Detect collisions, propose deterministic SKU rules and produce an old-to-new mapping that preserves links to each variant.
Return a unique SKU mapping and collision report 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.Scenario & problem
When does this scenario usually come up?
Start with the business context, the trigger, and the expected output before moving into the execution steps.
A catalog manager cannot reliably match products across systems because SKUs are missing, duplicated or inconsistent. In this case, the immediate task is to detect duplicate SKUs and identify affected variants. The workflow should produce a unique SKU mapping and collision report, using the merchant's actual records and constraints.
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
Detect collisions, propose deterministic SKU rules and produce an old-to-new mapping that preserves links to each variant.
03
Step 3
Deliver a unique SKU mapping and collision report; verify the result against the supplied records and identify unresolved inputs.
FAQ
Common questions when running this scenario
Cover decision rules, frequent misunderstandings, and required inputs so the team aligns on prerequisites before execution.
Is a SKU the same as a product name?
No. A SKU is an operational identifier. A readable product name alone may not distinguish every sellable variant.
Why retain the old-to-new mapping?
Warehouse, supplier and reporting records may still contain the old identifier. A mapping supports reconciliation during the change.
What information is needed to investigate this use case?
Start with existing SKUs, product and variant IDs, naming convention and connected-system mappings. These inputs establish the relevant scope and help separate an actual issue from missing information or an unsuitable comparison. Without them, the result should remain a proposed approach rather than a confirmed diagnosis.
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.
Generate unique SKUs using a documented naming rule
A catalog manager cannot reliably match products across systems because SKUs are missing, duplicated or inconsistent. In this case, the imme…
Prepare a reversible bulk SKU correction file
A catalog manager cannot reliably match products across systems because SKUs are missing, duplicated or inconsistent. In this case, the imme…
Identify duplicate variants and propose a cleanup mapping
A catalog contains incomplete, duplicated or inconsistently named option combinations. In this case, the immediate task is to identify dupli…
Add valid variants to an existing product structure
A catalog contains incomplete, duplicated or inconsistently named option combinations. In this case, the immediate task is to add valid vari…
Create missing variants from valid option combinations
A catalog contains incomplete, duplicated or inconsistently named option combinations. In this case, the immediate task is to create missing…
Prepare a variant import from CSV source records
A catalog contains incomplete, duplicated or inconsistently named option combinations. In this case, the immediate task is to prepare a vari…
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.