Top 10 Product Name Cleaning Best Practices
| No. | Best Practice | Description | Example |
|---|---|---|---|
| 1 | Standardize Capitalization | Use a consistent title case or sentence case format across all product names. | apple iphone 15 pro → Apple iPhone 15 Pro |
| 2 | Remove Extra Spaces | Trim leading, trailing, and duplicate internal spaces. | Samsung Galaxy S24 → Samsung Galaxy S24 |
| 3 | Normalize Abbreviations | Use one approved form for common abbreviations (e.g., GB, TB, oz). | 128gb → 128 GB |
| 4 | Correct Spelling Errors | Fix common typos in brand and model names. | Samsng → Samsung |
| 5 | Standardize Units and Symbols | Ensure units appear in a uniform format. | 1L, 1 ltr, 1000 ml → 1 L |
| 6 | Remove Unnecessary Special Characters | Delete decorative punctuation while keeping meaningful characters. | Nike-Air-Max!!! → Nike Air Max |
| 7 | Use a Consistent Attribute Order | Arrange brand, model, size, and color in the same sequence. | Red 256 GB Apple iPhone 15 → Apple iPhone 15 256 GB Red |
| 8 | Eliminate Duplicate Information | Remove repeated words or attributes. | Dell Dell Inspiron Laptop → Dell Inspiron Laptop |
| 9 | Map Synonyms to Canonical Terms | Convert equivalent terms to one standard label. | Gray and Grey → Gray |
| 10 | Validate Against Master Data | Compare cleaned names to an approved catalog or taxonomy. | Match to an internal SKU reference table |
