Every Shopify catalog has gaps. Products with no type. Variants with no barcode. Specs that exist only in a paragraph of description, or only in a supplier PDF nobody has opened since launch. Filling them in is dull work, which is why it never gets done.
AI is well suited to most of it. But product data is the one place where AI's habit of producing something plausible is actively dangerous. A made-up barcode or an invented material isn't a typo. It's a false claim about a product you're selling.
So this guide is half how-to and half guardrail. Here's what AI should do, what it must not, and a workflow that gets the benefit without the risk.
The rule: AI moves facts, it doesn't make them
Split the work into three kinds.
Finding gaps. Which products have no product type? Which variants have no weight? AI is excellent at this. It's counting.
Moving information you already have. The dimensions are in the description, but not in a structured field. The material is in the supplier sheet, but not in the store. AI reads the source and puts the value in the right place. This is the real time saver.
Inventing information you don't have. There's no barcode anywhere, so the AI supplies one. There's no weight, so it estimates. Never allow this. The output looks exactly like real data, and that's the problem.
Keep AI on the first two and you're fine.
Fields AI can draft, and fields it must not guess
| AI can draft, from facts you give it | AI must never guess |
|---|---|
| Descriptions | GTIN, UPC, EAN, barcode |
| Product type, from the product itself | SKU and MPN |
| Tags | Weight and dimensions |
| Alt text, from the image and product name | Materials and ingredients |
| SEO title and meta description | Country of origin |
| A structured spec list, from specs you supply | Certifications and safety claims |
| Compatibility ("fits model X") |
For the right-hand column, the source is the manufacturer, the packaging, or your own measurements. On identifiers specifically, see GTINs and product identifiers for AI shopping.
Step 1: Find the gaps
Start by getting a picture of what's missing. The dependable way is an export.
- In your Shopify admin, export your products to CSV.
- Give the file to your AI assistant with a prompt like:
In this Shopify product export, count how many products are missing each of these: product type, vendor, product category, description, variant barcode, variant weight, image alt text. Then list the 20 products with the most missing fields.
You get a gap report in a minute, and a priority list. Start with your best sellers, not with the alphabet.
If you've connected Claude or ChatGPT to your store, you can also ask about individual products directly ("Using Shopify, show me everything about [product]"). For a whole-catalog audit, the export is the better tool, because the connector looks products up one at a time.
Step 2: Gather the source material
This is the step people skip, and it's the one that decides whether the result is trustworthy. For the products you're fixing, collect what you actually know:
- Supplier or manufacturer spec sheets
- Your own product photos showing labels and packaging
- The existing descriptions, which often contain specs in prose
- Your purchase orders or inventory system, for barcodes and weights
Give these to the assistant along with the export. Now it has facts to move.
Step 3: Fill, with a source for every value
Ask for the work in a way that makes invention visible:
Using only the attached spec sheets and the existing descriptions, fill in the missing product type, weight, and material for these products. Add a column called Source that says where each value came from. If a value isn't in the sources, leave the field empty and write "not found." Do not estimate.
That last line matters. "Leave it empty" gives the assistant a legitimate way out other than guessing. And the Source column turns a review of 200 rows into a quick scan: anything without a clear source gets checked first.
Step 4: Check a sample
Before anything goes back into your store:
- Spot-check ten rows against the original source, across different products.
- Check every identifier. Barcodes should match the packaging digit for digit. Don't sample these.
- Look at the "not found" rows. These are your real gaps. They need a human, a supplier email, or a tape measure.
- Scan for values that are suspiciously tidy. A column where every weight is a round number wasn't measured.
Step 5: Put it back
For more than a handful of products, import the CSV. Shopify shows a preview before it applies changes. Keep your original export so you can restore from it.
For a few products, a connected assistant can update them directly. Per Shopify's connector documentation, the dedicated update action covers a product's title, description, status, images, variant prices, and SKUs. Other data, including metafields, goes through the Admin API with your confirmation first. Shopify notes that results vary more on that route, so check the product in your admin afterward.
Where structured specs should live
A spec that sits only in the description is readable by people and awkward for machines. The durable home for product facts is structured fields:
- Product category and its attributes, using Shopify's standard taxonomy. See why product taxonomy matters for AI ranking.
- Metafields, for facts specific to your products. See metafields vs metaobjects.
- A spec table built from those fields. See building a product spec table with metaobjects.
AI is a good helper for the conversion: "Read this description and list every factual spec in it as attribute and value pairs. Don't add anything that isn't stated." You review the list, then enter it once in the structured field.
Why this is worth an afternoon
Filling gaps makes your admin tidier, but that's the smaller payoff.
When a shopper asks an AI assistant for "a waterproof jacket under 200 dollars in a women's medium," the assistant matches on structured facts: product type, attributes, size, price, availability. A product with those fields filled in can be matched with confidence. A product where "waterproof" appears once in the fourth paragraph may be passed over for one that states it plainly.
It works the same way with your own AI tools. Ask Sidekick or a connected Claude about a product with thin data, and you get a thin answer.
That's also why invented data is so costly. If an assistant tells a shopper your product is made of a material it isn't, you've got a return, a bad review, and a model that has learned something false about you. We cover that failure in why AI describes my products inaccurately.
To see which fields carry the most weight, read the Shopify product fields that affect AI shopping rank. To see what AI assistants can read from your store today, run the free AI readiness checker.
The short version
- Export your products and have AI report the gaps.
- Collect real sources: spec sheets, packaging, your records.
- Have AI fill fields from those sources only, with a Source column and "not found" for anything missing.
- Check a sample, and check every identifier.
- Import, keeping the original export as your backup.
For the editing mechanics at scale, see bulk editing Shopify products with AI.


Comments
Every comment here comes from a verified email. Write yours, confirm from your inbox, and it's live.
Loading comments…