[Plugin] – WooCommerce – Duplicate SKUs

  • iMisterK

    (@imisterk)


    9 years, 10 months ago

    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.