Duplicate attributes in PrestaShop: how to simplify values and tidy up your store filters
Do your filters show “Red” and “red”, three different size groups or forty shades of blue with one product each? Here are the most common situations in which a PrestaShop catalogue fills up with duplicate attributes, why they hurt your sales and how to tidy it up step by step without losing combinations or stock.
Do you recognise any of these situations?
No catalogue starts out messy. Duplicates creep in with every import, every new supplier and every person who adds products. These are the situations we see again and again in PrestaShop stores:
1. You imported catalogues and now have repeated attributes
You loaded a supplier CSV, migrated from another platform or sync a marketplace. Each source brings its own names, and PrestaShop creates whatever it doesn’t find spelled exactly the same: the “Color” group lives next to “Colour” and “Shoe colour”, and the values “Red”, “RED” and “Red ” (with a trailing space) are three different values.
How you notice: near-twin groups in the back office, and the same colour shown two or three times in the store filter.
2. Your attributes are fragmented across too many groups
Each category or each person created their own group for the same concept: “Size”, “T-shirt size”, “Trouser size”, “Sizes”. Or a “Material” feature next to a “Materials” one. They all mean the same thing, but for PrestaShop they are different groups.
How you notice: a customer looking for size M has to tick it in several filter blocks, or doesn’t find products you actually have.
3. Your filters are huge and badly sized
The colour block has eighty options: “Blue”, “Navy blue”, “Navy”, “Dark blue”… The size block mixes “XL”, “Xl”, “Extra large” and “42”. Customers have to scroll inside the filter, get lost and end up using the search box or leaving.
How you notice: filters with dozens of almost identical options and slow, unhelpful faceted navigation.
4. You have many attributes with few products each
Forty colour values, half of them used by one or two products. Every stray value is one more filter option that returns a single result, one more combination to maintain and often a facet page with next to no content.
How you notice: ticking a filter value shows a single product, and many values are variants of a more common one.
5. Brands and features are duplicated too
“Nike”, “NIKE” and “Nike Inc.” as three brands, or a feature with repeated values. The brand filter doubles up and manufacturer reports come out split.
Why it is worth tidying up
- Filters that help you sell. One value per option and one group per concept: customers filter once and see everything you have.
- Less noise for search engines and marketplaces. Feeds and filter pages get consistent values instead of variants of the same name.
- A catalogue you can maintain. Fewer groups and values mean fewer combinations to check and fewer mistakes with every import.
How to tidy it up step by step
1. Back up your database
Merging attributes rewrites combinations. Before touching anything, make a full backup.
2. Take stock
List your attribute groups, features and brands, and note the ones that mean the same. Look out too for values used by only one or two products.
3. Decide what stays
For each concept, choose one final group and name (“Color”, “Size”). Decide which values to join: identical ones spelled differently, and also those worth grouping into a broader one, such as “Navy” into “Navy blue”.
4. Move the combinations and resolve conflicts
When values are joined, a product can end up with two identical combinations: for example “Red – M” and “red – M”. You have to decide whether to merge them adding up their stock or to review them by hand. Doing it product by product from the product page is slow and error-prone.
5. Rebuild the filter index and check the store
After a large clean-up, rebuild the faceted search module index and check the filters and a few product pages in the store.
6. Set a rule for the future
Fix the group names and the values you use, and check new imports so variants don’t slip back in.
How Attribute Fusion helps
Attribute Fusion is our module for PrestaShop 1.6.1 to 9.2.1 (PHP 7.1 to 8.5) that does steps 3 and 4 for you, with a preview of every change:
| Situation | What the module does |
|---|---|
| Imports with different names | Detects groups with the same or a similar name (“Color” and “Shoe colour”) and repeated values regardless of case, accents and spaces. |
| Fragmented attributes | Merges several groups into one: you choose the one that stays and duplicate values arrive already paired. |
| Huge filters | Joins the repeated values of a group and lets you pair any value with another by hand, to cut the filter down to the options that really help. |
| Values with few products | Moves their combinations to a broader value; if two combinations of a product end up identical, you merge them adding up the stock or leave them for review. |
| Brands and features | Merges brands spelled in different ways and features with their values; products move to the one that stays. |
| Safety | Preview of every group, value, combination and product that changes; backup confirmation, one transaction per merge and a history. Orders keep their names. |
Install it and the dashboard instantly shows the possible duplicates in your store. What is merged and what stays is up to you.