Inventory
đź’Ž Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
catalog
taxonomy
Normalize Vendor Field Across the Catalog
Clean up inconsistent Vendor field values (spelling variants, casing, blank entries) so vendor-based reporting and filtering are reliable.
đź“‹ Prompt
Audit the Vendor field across [SCOPE, e.g. “the entire catalog”] and find inconsistencies: spelling/casing variants of the same vendor ([EXAMPLE_1, e.g. “Acme Co” vs “ACME Co.” vs “acme”]), and products with the field blank or set to my own store name where a real supplier should be listed. Use this canonical vendor list as the source of truth: [VENDOR_LIST]. For each product with a mismatched or blank vendor value: Show current value and proposed canonical value. If a blank vendor can’t be confidently matched to a canonical vendor (e.g. from tags, product type, or description), flag it for manual entry instead of guessing. Show me the full mapping table before applying anything. Apply only after approval, then report how many products were corrected, how many were already correct, and how many are flagged for manual vendor assignment.
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions