Title: [Plugin] – WooCommerce – Duplicate SKUs
Last modified: September 1, 2016

---

# [Plugin] – WooCommerce – Duplicate SKUs

 *  [iMisterK](https://wordpress.org/support/users/imisterk/)
 * (@imisterk)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-woocommerce-duplicate-skus/)
 * 0
    down vote favorite
 * I am pretty new to modifying databases (running phpmyadmin for WooCommerce) and
   I am currently stuck at a problem.
 * Basically I have around 400 items which have random SKUs (example)
 * JCB-5018057409641_888 OX TOOLS-5060242330476_870 REFINA-281314_856
 * I need to mass remove for everything going from the underscore and the 3 numbers.
 * I think I could possibly use Sublime or Notepad++ to achieve this but looking
   through many queries I can’t seem to do it right :/
 * Any ideas? Many Thanks, K

The topic ‘[Plugin] – WooCommerce – Duplicate SKUs’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [sku](https://wordpress.org/support/topic-tag/sku/)

 * 0 replies
 * 1 participant
 * Last reply from: [iMisterK](https://wordpress.org/support/users/imisterk/)
 * Last activity: [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-woocommerce-duplicate-skus/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics