operazione fondamentale, vengono eliminati tutti i record orfani
-- Identificare i valori orfani
SELECT *
FROM wp_termmeta
WHERE term_id NOT IN (SELECT term_id FROM wp_terms);
-- Eliminare i valori orfani
DELETE FROM wp_termmeta
WHERE term_id NOT IN (SELECT term_id FROM wp_terms);
Andiamo a trovare le corrispondenze tra ID categoria Magento e ID categoria WooCommerce
SELECT t.term_id AS category_id, t.name AS category_name, meta.meta_value AS magento_category_id
FROM wpcv_terms t
INNER JOIN wpcv_term_taxonomy tt ON t.term_id = tt.term_id
LEFT JOIN wpcv_termmeta meta ON t.term_id = meta.term_id AND meta.meta_key = '_id_categoria_magento'
WHERE tt.taxonomy = 'product_cat';