Skip to content

Instantly share code, notes, and snippets.

@carmolim

carmolim/deleta_produtos.sql

Last active January 7, 2025 17:52
Show Gist options
  • Save carmolim/dfcef98d5542ba40524388dfa16c89f5 to your computer and use it in GitHub Desktop.
Save carmolim/dfcef98d5542ba40524388dfa16c89f5 to your computer and use it in GitHub Desktop.
Download ZIP
Deletar todos os produtos do woocommerce via SQL
Raw
deleta_produtos.sql
DELETE relations.*, taxes.*, terms.*
FROM wp_term_relationships AS relations
INNER JOIN wp_term_taxonomy AS taxes
ON relations.term_taxonomy_id=taxes.term_taxonomy_id
INNER JOIN wp_terms AS terms
ON taxes.term_id=terms.term_id
WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type='product');
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');
DELETE FROM wp_posts WHERE post_type = 'product';
@juniorinvernizzi
Copy link

Olá @carmolim você tem algum código para excluir todos os pedidos do Woocommerce pelo SQL assim como esse de excluir produtos?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment