Delete child category and move products to parent category

  • Sub_Zero

    (@sub_zero)


    9 years, 1 month ago

    Hi,
    I have 1.000 of products which are into a child category. I would now like to delete that child category and move all products to the parent category.

    Is there a way I could do this through a simple way? If I would go through each product to change its category, it would probably take months to get finished!

    https://wordpress.org/plugins/woocommerce/

Viewing 1 replies (of 1 total)
  • lorro

    (@lorro)

    9 years, 1 month ago

    Do you have access to phpMyAdmin and are you without fear? Go to the wp_terms table to find the term_ids for the old and new terms, say 10 and 20, then update the wp_term_relationships table with a mysql command:

    UPDATE wp_term_relationships SET term_taxonomy_id=’20’ WHERE term_taxonomy_id=’10’

    Note table names and field names usually need enclosing in back ticks which can’t be used in a forum post.

    The chances of this going wrong are pretty good so take a reliable database backup first and be sure you know how to restore it if necessary. Or better still, make a copy of the database to practice on first.

Viewing 1 replies (of 1 total)
  • The topic ‘Delete child category and move products to parent category’ is closed to new replies.