Support » Plugin: WooCommerce » Delete all Product Attributes

Delete all Product Attributes

  • Resolved Topknotch

    (@topknotch)


    1 year, 2 months ago

    Hi,

    We transferred a site from Shopify to Woo commerce.
    Problem is that it created a load of product attributes and will take hours to delete them all manually.
    Is there a way to delete them all so we can re build them ?
    We have tried –
    PHP MY Admin with –
    `DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE ‘pa_%’);
    DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE ‘pa_%’;
    DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);

    But that just threw up some errors within sql

    Any ideas much appreciated
    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support gabrielfuentes

    (@gabrielfuentes)

    1 year, 2 months ago

    Hi there! 👋

    This is a fairly complex development topic. I’m going to leave it open for a bit to see if anyone is able to chime in to help you out.
    
    I can also recommend the WooCommerce Developer Resources Portal for resources on developing for WooCommerce.
    
    You can also visit the WooCommerce Facebook group or the #developers channel of the WooCommerce Community Slack. We’re lucky to have a great community of open-source developers for WooCommerce, and many of our developers hang out there, as well.

    I hope this helps 🙂

    Plugin Support Siobhan

    (@siobhyb)

    1 year, 2 months ago

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Delete all Product Attributes’ is closed to new replies.

Topic Tags

Views