Export fields from brands, manufacturers - WooCommerce WordPress SQL script

Call us now! +44 (0) 2037347158

Post published:02/12/2020
Post category:Web development

WooCommerce brands export SQL script

SELECT * FROM `wp_wcm_sds_brands` brd,`wp_postmeta` pro,`wp_terms` trm  WHERE brd.meta_value=pro.post_id
and pro.meta_key='_wp_attached_file'  
and brd.term_taxonomy_id=trm.term_id

SELECT * FROM `wp_wcm_sds_brands` brd,`wp_postmeta` pro,`wp_terms` trm WHERE brd.meta_value=pro.post_id

and pro.meta_key='_wp_attached_file'

and brd.term_taxonomy_id=trm.term_id

Tags: WooCommerce, WordPress