Get the WooCommerce _product_attributes ``` SELECT m.post_id ,m.meta_key ,m.meta_value FROM wp9735postmeta as m LEFT JOIN wp9735posts AS p ON m.post_id = p.ID WHERE p.post_type = 'product' AND m.meta_key = '_product_attributes'; ``` ``` SELECT m.post_id ,m.meta_key ,m.meta_value FROM wp_postmeta as m LEFT JOIN wp_posts AS p ON m.post_id = p.ID WHERE p.post_type = 'product' AND m.meta_key = '_product_attributes'; ``` 01.06.25 how to set _product_attribute value via mysql ``` UPDATE wp_postmeta as m LEFT JOIN wp_posts AS p ON m.post_id = p.ID SET m.meta_value = REPLACE(m.meta_value,'pa_size\";s:5:\"value\";s:0','pa_size\";s:5:\"value\";s:1') WHERE p.post_type = 'product' AND m.meta_key = '_product_attributes' and m.meta_value like '%pa_size\";s:5:\"value\";s:0%'; ``` 01.06.25 ## delete with left join ``` delete m FROM wp_postmeta as m LEFT JOIN wp_posts AS p ON m.post_id = p.ID WHERE p.post_type = 'product' AND m.meta_key = '_product_attributes' ``` 01.06.25 # copy description from other database ``` CREATE TEMPORARY TABLE Tax( id INT NOT NULL, description longtext ) SELECT x.term_taxonomy_id as id ,xx.description as description FROM wp_term_taxonomy as x LEFT JOIN wp_terms AS t ON x.term_id = t.term_id LEFT JOIN wp9735terms AS tt ON t.slug = tt.slug right JOIN wp9735term_taxonomy AS xx ON tt.term_id = xx.term_id AND xx.taxonomy = 'product_cat' LEFT JOIN wp9735terms AS ttt ON xx.parent = ttt.term_id WHERE x.taxonomy LIKE 'product_cat' and xx.description is not null and xx.description != '' order by x.term_taxonomy_id; /*SELECT xx.description */ UPDATE wp_term_taxonomy AS x LEFT JOIN Tax AS xx ON x.term_taxonomy_id = xx.id SET x.description = xx.description WHERE xx.description is not null ``` 01.06.25

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2025