• Resolved Topknotch

    (@topknotch)


    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)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Delete all Product Attributes’ is closed to new replies.