Revisions to change sku for all products

edited body

Source Link

edited Mar 13, 2017 at 10:19

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

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

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

Backup first.

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

UPDATE catalog_entity_product
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.

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.

added 26 characters in body

Source Link

edited Mar 13, 2017 at 10:09

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

UPDATE catalog_entity_product
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.

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

UPDATE catalog_entity_product
SET sku = CONCAT(LEFT(sku, CHAR_LENGTH(sku) -2), '');

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

Backup first.

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

UPDATE catalog_entity_product
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.

Source Link

created Mar 13, 2017 at 10:05

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

UPDATE catalog_entity_product
SET sku = CONCAT(LEFT(sku, CHAR_LENGTH(sku) -2), '');

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

Backup first.

Return to Answer