AI development 5 min read

AI Catalogue Cleanup for Shopify: Categories, Metafields and Alt Text at Scale

Messy product data breaks filters, channel feeds and AI search. Here’s how a custom AI workflow can clean up a Shopify catalogue at scale, safely.

AI Catalogue Cleanup for Shopify – StoreFix blog cover
Share
On this page

    Most Shopify catalogues grow messy over time. Products get added by different people, imported from CSV files or pulled in from suppliers. Some have a proper category, some say “uncategorized”. Colours are spelt three different ways. Half the images have no alt text. It doesn’t look like a big problem until you try to add filters, run Google Shopping or get your products picked up by AI search. This guide shows how a custom AI workflow can clean up a Shopify catalogue at scale, and where a human still needs to check the work.

    Why catalogue data matters more now

    Your product data is used in far more places than your product page. Shopify uses the product category from its Standard Product Taxonomy for category metafields, collection conditions, product filtering, sales channel mapping (such as Google and Facebook) and tax rates with Shopify Tax.

    Category metafields (called product attributes in the taxonomy) hold details like size, fabric, colour or material. They can power storefront filters in the Search & Discovery app, and colour metafields can show as swatches on product pages. Shopify also groups filter values, so “powder blue” and “navy blue” can both sit under a single “Blue” filter.

    So clean, structured data helps three things at once:

    • Shoppers: better filters and clearer product pages.
    • Channels: fewer errors when products are mapped to Google or Meta.
    • Search and AI tools: more consistent facts for them to read about your products.

    What Shopify already does for you

    Shopify has some AI built in here. When you create a product, it uses the name, description and images to suggest a product category. You can accept it or pick another. Based on AI predictions, some category metafields are also added by default.

    That works well one product at a time. It’s harder when you have hundreds or thousands of older products, or products created by CSV import or an app, which can stay uncategorized. That’s where a custom workflow earns its keep.

    What an AI catalogue cleanup can handle

    A custom script or small app can read your products through the Shopify Admin API, ask an AI model to suggest values, and write the approved results back. Typical jobs include:

    • Assigning a Standard Product Taxonomy category to uncategorized products.
    • Filling category metafields like colour, material, size or pattern from titles, descriptions and images.
    • Normalising messy values, for example “Navy”, “navy blue” and “dk blue” into one value.
    • Writing image alt text that describes what’s actually in the photo.
    • Suggesting tags and product types that match your collection rules.
    • Flagging products with missing or contradictory information for a person to fix.

    Manual vs built-in vs custom

    Approach Best for Watch out for
    Manual editing in Shopify admin Small catalogues, one-off fixes Slow and inconsistent across team members
    Shopify’s built-in category suggestions New products as you add them Doesn’t clean up older or imported products in bulk
    Custom AI workflow via the Admin API Large or messy catalogues, ongoing imports Needs review rules and testing before it writes live data

    How the workflow works, step by step

    1. Export and audit. Pull every product, its category, metafields, tags and image alt text. Count what’s missing so you know the size of the job.
    2. Agree your rules. Decide your allowed values (for example, your colour list) and which fields matter most for filters and channels.
    3. Generate suggestions. Send each product’s title, description and images to an AI model with clear instructions and your allowed values. Ask it to return structured data, not free text.
    4. Score and review. Have the model say how sure it is. High-confidence suggestions go into a review sheet. Low-confidence ones go to a person.
    5. Write back in bulk. Shopify’s GraphQL Admin API supports bulk mutation operations. You upload a JSONL file (up to 100MB) and Shopify runs the mutation once per line, then returns a results file showing what worked.
    6. Check the storefront. Test filters, swatches and collections after the update. Then spot-check a sample of products by hand.
    7. Keep it running. Run the same checks on new products, or on each supplier import, so the catalogue doesn’t drift back.

    Guardrails worth having

    • Never let AI invent facts. It should only use what’s in your title, description, images or supplier data. If it can’t tell the material, it should leave the field blank.
    • Test on a small batch first. Run 20–50 products, review them, then scale up.
    • Keep a backup. Export the original values before any bulk write, so you can roll back.
    • Protect regulated details. Ingredients, sizing for safety items, or anything with legal weight should always be checked by a person.
    • Log every change. Keep a simple record of what changed, when, and why.

    Is it worth building?

    If you have a small catalogue that’s already tidy, Shopify’s built-in suggestions are probably enough. A custom workflow makes more sense when:

    • You have a large catalogue with lots of uncategorized products.
    • You import products regularly from suppliers or another system.
    • Your filters or channel feeds keep breaking because values don’t match.
    • You want your product data ready for AI search and shopping assistants.

    FAQ

    Can’t I just use Shopify’s own AI suggestions?

    For new products, yes. Shopify suggests a category as you create a product and adds some category metafields by default. A custom workflow is for cleaning up many existing products at once and keeping imports consistent.

    Will an AI cleanup change my live store straight away?

    It shouldn’t. A good setup writes suggestions to a review file first. Only approved changes are pushed to Shopify, and you keep a backup of the original values.

    Does this help with Google and AI search?

    Clean categories and attributes give search engines, sales channels and AI tools clearer, more consistent facts about your products. It won’t guarantee rankings, but messy data makes everything harder.

    Need a hand?

    StoreFix builds custom AI workflows for Shopify, from catalogue cleanup to supplier imports and integrations. Integrations start from $500. See our Shopify AI development service or our custom Shopify app development work, then get a free proposal and we’ll tell you what your catalogue needs.

    Found this useful? Share it.

    Written by

    Faiq AdamFounder, StoreFix.co

    Faiq founded StoreFix.co in 2015. As a Shopify Partner, he and the team have migrated 500+ stores and delivered 1,000+ Shopify projects — setups, migrations, speed, SEO and custom builds.

    Work with StoreFix.co

    Put AI to work in your store

    Chatbots, smart search and automations built for Shopify — and only where they pay off.

    Fixed prices Reply within one business day 10+ years on Shopify