Shopify Product Data Cleanup: Titles, Variants, Images and SEO

Shopify product data cleanup means standardising titles, variants, images, tags, SEO fields and metafields according to written rules, so that Google Shopping, the Meta catalog, your store’s search and the customer all read the product correctly. Stores that grew fast or migrated from another platform usually carry a catalog full of inconsistent titles, duplicate variants and missing images, all of which cost orders and ad budget. This guide orders the work by impact, explains the bulk tools, and shares what we learned on the BrandVIP project.

Why clean data sells more

The customer sees the product page, but ads and search see the raw data:

Field	Who reads it	What happens when it is messy
Title	Google Shopping, Meta catalog, store search, the customer	An ad titled “product 1234 new!!” that nobody clicks, and disapprovals in Merchant Center
Variants	Product page, feeds, inventory	A customer who cannot find their size although it is in stock; inventory scattered across duplicate products
Barcode	Merchant Center, supplier sync	Limited visibility in Shopping, failed matching with the supplier
Images	Ads, product page, visual search	Rejected ads, or a product with no image that nobody buys
Tags	Automated collections, filters, reports	Incomplete collections and products missing from theme filters
SEO fields	Google, Bing and answer engines	Pages with duplicate titles competing with each other
Metafields	Theme, filters, feeds	Size, material and origin missing from filtering and ads

That is why we treat cleanup as part of preparing a store for ads, and a prerequisite before any supplier inventory sync.

Step one: export the catalog and inspect it

Export all products to CSV from the Shopify admin and open it in a spreadsheet. What to look for in the first pass:

• Titles starting with numbers or symbols, or with random capitalisation.
• Duplicate products with the same name and a small spelling difference.
• Different variant options for the same idea: “Size”, “size” and “Sizes” across similar products.
• Empty barcodes, or barcodes repeated across different products.
• Empty image columns, and images uploaded with names like IMG_4521.
• SEO fields (page title and description) empty or copied verbatim from the title.
• Tags spelled differently for the same meaning.

Calculate the share of problems per column; this sets the order of work and gives you a progress measure.

Step two: one naming rule

Messy titles come from the absence of a rule, not from carelessness. Write one rule and apply it:

Brand + product name + distinguishing attribute + size/quantity

Example: “Lattafa Asad Eau de Parfum for Men 100 ml” instead of “asad lattafa perfume original men 100ml NEW”. The same rule applies to the Arabic version in bilingual stores. Remove from titles: words like “original”, “new”, “offer”, exclamation marks and prices, because they change and pollute the feeds. Move to tags or metafields: type, gender, occasion, material.

Step three: variants and barcodes

Variants are what most often break the experience. The rules:

1. One product per design, with sizes and colours as variants inside it, not separate products.
2. Option names standardised across the catalog (for example “Size” and “Colour” only).
3. Option values in one format (“S, M, L”, not “Small, M, Large”).
4. A correct barcode per variant if the supplier or brand provides one; if not, leave the field empty and never invent a number, because fake barcodes are disapproved in Merchant Center.
5. A unique SKU per variant under a fixed scheme.

Merging duplicate products into one with variants needs care: keep the oldest or most-visited URL and create 301 redirects from the deleted ones.

Step four: images and tags

For images: one main image per product on a clean background (a practical requirement for Shopping ads), then lifestyle images, in consistent size and aspect ratio, with alt text describing the product rather than the file name. Stores that pull images from suppliers usually need to recompress them to avoid slow pages.

For tags: a closed, written list of allowed tags (category, gender, occasion, condition), and removal of everything outside it. Standardised tags are what make automated collections and filters work without manual maintenance.

Step five: SEO fields and metafields

For every product: a unique page title that includes the keyword and brand, and a meta description that states the benefit and size and invites the purchase. Do not copy the title verbatim into the SEO field. Then metafields for structured information: material, country of origin, size, warranty period, fragrance concentration. These fields feed filters in modern themes and can be passed to Google feeds. The basics are in the Shopify SEO complete guide.

Tools: bulk editor, CSV or a specialist app?

Scale	Tool	Note
Dozens of products	Shopify’s bulk editor	Fast and safe for one or two fields
Hundreds to thousands	Export CSV, edit, import	Back up first; import overwrites existing fields
Thousands, specific fields	A tool like Matrixify	Updates chosen columns only without rewriting the rest
Recurring rules	Shopify Flow or a custom script	When the rule must apply to every new product automatically

Two rules we never skip: a full backup before every bulk operation, and a test on ten products before applying a change to the whole catalog. Import details are in bulk importing products into Shopify.

How to keep the mess from coming back

A one-time cleanup returns to square one within months if the entry process does not change. Create a one-page “catalog rules” document covering the naming rule, option names, allowed tags and image requirements, and give it to everyone who adds products. Then review only last month’s additions each month; that is far easier than a full cleanup every year.

From our experience

At BrandVIP, a perfume and beauty store with more than 5,000 products, we ran a complete cleanup of titles, variants, images and tags, and it was the prerequisite for building the sync engine that now matches 8,788 products automatically. At Sophie’s we entered and enriched the data and images of more than 4,000 products during the move from Odoo, so the catalog was ready for ads from day one. The lesson in both cases: profitable campaigns start from clean data, not from a clever ad. The feeds built on that data are covered in Google Shopping ads and Merchant Center.

Conclusion

Shopify product data cleanup is methodical work in a clear order: export and inspect, standardise titles under one rule, fix variants and barcodes, then images and tags, then SEO fields and metafields, with the tool that fits your catalog size and always with a backup. Then fix the rules so the mess does not return. If your catalog has thousands of products that need cleanup or sync, send us your store link on WhatsApp, or see our custom apps and integrations service.