╔══════════════════════════════════════════════════════════════╗
║     Magento 2 — Fix Duplicate Swatch Attribute Options       ║
╚══════════════════════════════════════════════════════════════╝

🔴 LIVE MODE — Changes WILL be written. Ctrl+C to abort (3 sec)...

✅  Connected to database: dbfadeluxit

Found 4 swatch attribute(s) to inspect:
   • [93] color (input: select)
   • [138] misura (input: select)
   • [154] p_33327927n0_color (input: select)
   • [155] p_33327927n0_size (input: select)

Using Default Store View ID : 1 for label comparison.

Schema detected : PK=value_id, entity col=entity_id, no row_id (CE/standard)

─────────────────────────────────────────────────────────────
Processing: [93] color
   ✅ No duplicates found.
─────────────────────────────────────────────────────────────
Processing: [138] misura
   ✅ No duplicates found.
─────────────────────────────────────────────────────────────
Processing: [154] p_33327927n0_color
   ⚠️  Found 2 duplicate group(s):

   Default Store View Label : "Nero"
   Normalised compare key   : "nero"
   Canonical option_id : 45
   Duplicate option_ids: 1345
   ✅  Merged 1 duplicate(s) for "nero" → canonical option_id=45

   Default Store View Label : "Sabbia"
   Normalised compare key   : "sabbia"
   Canonical option_id : 852
   Duplicate option_ids: 1346
   ✅  Merged 1 duplicate(s) for "sabbia" → canonical option_id=852

─────────────────────────────────────────────────────────────
Processing: [155] p_33327927n0_size
   ✅ No duplicates found.

╔══════════════════════════════════════════════════════════════╗
║                         SUMMARY                             ║
╠══════════════════════════════════════════════════════════════╣
║  Attributes checked:                                       4 ║
║  Attributes with duplicates:                               1 ║
║  Duplicate groups found:                                   2 ║
║  Duplicate options merged:                                 1 ║
║  Duplicate options deleted:                                2 ║
║  Simple product rows updated:                              3 ║
║  Configurable child rows updated:                          0 ║
║  Super attr pricing rows updated:                          0 ║
╠══════════════════════════════════════════════════════════════╣
║  ✅  Changes written successfully.                           ║
╚══════════════════════════════════════════════════════════════╝

POST-RUN STEPS (run these after verifying the results):
  1. php bin/magento indexer:reindex catalog_product_attribute
  2. php bin/magento indexer:reindex catalog_product_price
  3. php bin/magento indexer:reindex catalogsearch_fulltext
  4. php bin/magento cache:flush
  5. Verify swatch options and configurable dropdowns on frontend.