Step 1
Collect the selected product identifiers, the vendor value currently stored on each row, the rewrite rule with its source spellings and single target spelling, the exclusion list, and the original export those values came from.
Vendor values on the selected products were captured inconsistently, so one supplier appears under several spellings while every other field must stay unchanged. In this case, the immediate task is to prepare vendor-field updates across selected products. The output should be a row-level preview of old and new values plus the records held back.
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 prepare vendor-field updates across selected 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: [selected product identifiers, the vendor value currently stored on each row, the rewrite rule with its source spellings and target spelling, the exclusion list, and the original export]. Rewrite only rows whose current value matches a listed source spelling, hold any row whose vendor field is empty, already carries the target spelling or contains content the rule never anticipated, and record the reason for each hold.
Return a bulk change preview and exception report retaining original values for every affected product 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 the selected product identifiers, the vendor value currently stored on each row, the rewrite rule with its source spellings and single target spelling, the exclusion list, and the original export those values came from.
Rewrite only rows whose current value matches a listed source spelling, hold any row whose vendor field is empty, already carries the target spelling or contains content the rule never anticipated, and record the reason for each hold.
Deliver the row-level preview with old and new vendor values plus the held rows and their reasons, verify the preview row count equals the selected products in the export, and keep the original values so the change can be reversed.
Cover decision rules, frequent misunderstandings, and required inputs so the team aligns on prerequisites before execution.
Each source spelling is listed against the single target spelling before the run, so the rule rewrites only values that appear on that list and leaves an undocumented spelling for review rather than guessing at it.
Rows with an empty vendor field, rows already carrying the target spelling, rows on the exclusion list, and rows holding a value the rule never anticipated, each one with its reason recorded.
Its row count is compared with the selected products in the export, every changed row is compared back to the original value, and the held rows are reviewed before the update is committed.
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.