Skip to content

Instantly share code, notes, and snippets.

@Acephalia

Acephalia/wrgi.sql

Created March 9, 2024 03:17
Show Gist options
  • Save Acephalia/9260cb83b0e906132fbbfed9d87edc26 to your computer and use it in GitHub Desktop.
Save Acephalia/9260cb83b0e906132fbbfed9d87edc26 to your computer and use it in GitHub Desktop.
Download ZIP
Woocommerce Remove Gallery Images
Raw
wrgi.sql
This SQL query wll remove all gallery images from all Woo products but leave the Product Image in tact. It will not delete the images from the media gallery. Just detach them from the gallery.
DELETE pm
FROM pwj_postmeta pm
INNER JOIN pwj_posts p ON pm.post_id = p.ID
WHERE p.post_type = 'product'
AND pm.meta_key = '_product_image_gallery';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment