Data Management
Create a product catalogue cleanup plan
Organise titles, attributes, variants and source ownership before making bulk catalogue changes.
IGS Editorial · 3 min read · Updated 17 November 2026

A product catalogue supports search, purchasing and fulfilment. Inconsistent attributes can make customers compare unlike items or choose the wrong variant. Cleanup should therefore focus on the decisions the catalogue enables, not only on making descriptions look uniform.
Begin with a defined subset of products and an inventory of fields. Identify the authoritative source for specifications, pricing and availability. Different fields may have different owners, and no single spreadsheet should be assumed to control everything.
Agree product and variant structure
Define the difference between a product family and a sellable item. Colour, size, pack quantity or configuration may create separate variants. The structure should reflect how the business sells and fulfils the item.
Preserve stable identifiers. Renaming a title should not break links between the catalogue, inventory and order history. If identifiers must change, plan the mapping and downstream impact explicitly.
Standardise attributes with context
Choose consistent units, formats and controlled values for comparable fields. State whether dimensions refer to the product, packaging or assembled form. A number without that context can be misleading even when its unit is correct.
Do not infer missing specifications from a similar item. Route uncertain values to the product owner or approved source. An empty field marked for review is safer than a plausible but unsupported technical claim.
Write titles for identification
Use a consistent order for the attributes customers need to recognise the item. Avoid stuffing titles with repeated promotional terms. Keep important variant information visible where users make a selection.
Review descriptions separately from factual specifications. Claims about performance, compatibility or certification require an approved basis. Catalogue cleanup is not permission to invent benefits or copy unverified competitor information.
Plan bulk changes safely
Preserve the original export, record transformation rules and test a sample import. Check how the platform handles blank values, special characters and deleted options. A blank cell may clear an existing value rather than leave it unchanged.
Validate rendered pages as well as source files. A correct import can still produce a confusing display if units, line breaks or variant selectors are handled unexpectedly. Confirm that search and filtering use the revised attributes as intended.
Maintain quality after cleanup
Add intake rules for new products and define who approves exceptions. Monitor recurring issues such as missing images, inconsistent units or unsupported claims. Assign corrections to the source owner where possible so the same error does not return in the next import.
Measure progress through useful outcomes: fewer ambiguous items, more complete required attributes and reduced correction work. Row counts alone do not establish a better catalogue. The end state should make products easier to identify accurately while preserving reliable links to operational systems.
Validate one catalogue family end to end
Select a product family with several sizes or configurations. Compare the source specifications, catalogue structure, customer-facing selectors and fulfilment identifiers. Check that a shopper can distinguish the variants and that the selected item maps to the correct operational record.
Look for unit ambiguity. A pack quantity may be confused with an individual item quantity, or package dimensions may appear as product dimensions. These issues can survive a technically successful import because every field contains a plausible value.
Have the product owner approve unresolved factual questions. After correction, test search filters and any downstream feed that uses the same attributes. Keep a change record so later imports do not restore the old values. Use this family as a reference example for future intake. The exercise demonstrates that catalogue quality is a connected property of source information, structure and presentation. Consistency is useful only when it preserves the distinctions customers and fulfilment teams need to make.
