如果您有权访问数据库,只需执行并导出以下查询的结果:
SELECT sku.meta_value AS sku,
pr.post_title AS title,
pr.post_content AS description,
term.name AS category,
pr.guid AS link,
img.guid AS image_link
FROM wp_posts pr
INNER JOIN wp_postmeta pm ON pr.ID = pm.post_id
AND pm.meta_key = \'_thumbnail_id\'
INNER JOIN wp_postmeta sku ON pr.ID = sku.post_id
AND sku.meta_key = \'_sku\'
INNER JOIN wp_posts img ON pm.meta_value = img.ID
INNER JOIN wp_term_relationships temr ON pr.ID = temr.object_id
INNER JOIN wp_term_taxonomy temt ON temr.term_taxonomy_id = temt.term_taxonomy_id
AND temt.taxonomy = \'product_cat\'
INNER JOIN wp_terms term ON temt.term_id = term.term_id
WHERE pr.post_type = \'product\';