Kevin Chauvet KevinChauvet
nfsarmento
/ export-active-woo-subscripitions.sql
Last active
August 14, 2025 10:56
Export all ACTIVE subscriptions from WooCommerce Subscriptions using a MySQL query
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| p.ID as 'Subscription ID', | |
| p.post_status as 'Subscription Status', | |
| pm1.meta_value as 'Billing First Name', | |
| pm2.meta_value as 'Billing Last Name', | |
| pm3.meta_value as 'Billing Email', | |
| oitems.order_item_name as 'Product', | |
| pm4.meta_value as 'Order Total', | |
| pm5.meta_value as 'Order Tax' | |
| FROM wp_posts p |