Merge multiple PrestaShop attribute duplicates

Display and select attributes to merge

1. Connect the Merlin module to your database, no need to select categories or even display products or declinations, go directly to the "Declinations and images" tab, then the "Attributes" sub-tab.
2. Click on the "View" button at the bottom of the tab for Merlin to display the list of attribute groups present in the tables as a base.
3. Select one or more groups in the left-hand table, which displays the list of attributes for these groups in the center.
4. Selecting the attributes to be merged can be done either manually with a left click (beginning of a list).
5. A shift+left-click to indicate the end of the list.
6. A crtl+left-click to add a delete the selection of one line at a time. In this example, an attribute from another attribute group is added to the list.

Even more efficient, you can use the "Find and select" tool, which works in all tables, as for example here with features:

1. Right-click in the column on which to filter, if possible in the row of the value to be searched.
2. From the menu, choose "Search and select" from the pop-up menu.
3. Parameterize your search filter with your criteria, with contains, equals, begins with etc.
4. Validate.

Great, even values that are differentiated by capital letters are found and selected automatically:

Merlin Backoffice avoids the purchase of a PrestaShop Duplicate Merge Module

1. Click on the button to group lines.
2. Type or modify the name given to the retained attribute (the first selected) in the cell.
3. You can check this box to tell Merlin to stop offering to modify the attribute name. It will then always take the value of the first line selected.
4. Validate.

What exactly does this PrestaShop module for replacing and then deleting duplicate attributes do?

• Only one attribute is retained (a single value identifier), the first in the selection.
• Its name is replaced by the new value entered.
• The identifiers of the other values, if they belonged to declinations, are replaced in these declinations by the identifier of the one retained.
• These other attributes are then permanently deleted from the database.

Can attributes belonging to different families be merged?

Yes, the method is exactly the same, it's just a matter of the initial selection including these attributes, so having first selected the different attribute groups with crtl + click for example. This is what we've done in step 6 of the example shown above.

The declinations that contained attributes deleted in group B are of course retained, but the attributes in these declinations are replaced by their duplicates retained in group A, for example.
Take care, therefore, to only merge values of the same type. For example, if you have two attribute groups, "Chrome finish" and "Metallic paint", both containing the attributes "Yes" and "No", merging them would undoubtedly be a mistake.

Moving attributes into another group without breaking the variations of products using them?

This module also features a function for copying attribute values from one (or more) group(s) to another (or others).

To move attributes, without breaking the base structure and declinations, you therefore need to duplicate them in the group to be retained with the copy function, then merge them with the values to be retained to remove duplicates, and finally delete the empty group(s).

The step-by-step method is the same as that described in the article on moving feature values. Thank you for watching this other tutorial.

Delete empty categories from shop

After grouping attributes from different groups, some groups may be empty and of no use. You might as well delete them to lighten the base a little more. :

1. Select the attribute groups to be deleted.
2. Check that the attrbituts table is empty .
3. Then click on the delete button on the left and validate.

ATTENTION:

• If you delete an attribute, without having merged it, declinations containing this property will lose it and it will then be impossible to find them again to add another one in its place.
• If you delete an attribute group containing attributes used in declinations, these attributes will also be deleted, along with their presence in all declinations of all products, with no way of going back. So remember to merge or move them first.