Skip to main content
3 of 3
edited body
Marius
  • 198.5k
  • 55
  • 424
  • 833

The quick and dirty way would be just to run this sql query on your database.

UPDATE catalog_product_entity
SET sku = CONCAT(LEFT(sku, CHAR_LENGTH(sku) -2), '')
WHERE sku LIKE '%_1';

You can add a where condition if you need it for a certain group of products.

Backup first.

Marius
  • 198.5k
  • 55
  • 424
  • 833