woocommerce - WooCommerce 产品提要 Google 商家中心

Question

我一直在尝试提取有用的产品提要，但提要“图片链接”中仍然缺少一个属性有人可以建议我在以下查询中进行调整以使其完美吗？

SELECT
    `product`.`ID` AS `product_id`,
    `product`.`post_title` AS `Title`,
    `product`.`post_title` AS `Description`,
    `product_price`.`meta_value` AS `Price`,
    'no' AS `Identifier_exists`,
    'Free' AS `Shipping`,
    'in stock' AS `Availability`,
    'new' AS `Condition`,
    `product`.`guid` AS `Link`
FROM
    (
        (
            (
                `wp_posts` `product`
            LEFT JOIN `wp_postmeta` `product_sku`
            ON
                (
                    (
                        `product`.`ID` = `product_sku`.`post_id`
                    )
                )
            )
        LEFT JOIN `wp_postmeta` `product_price`
        ON
            (
                (
                    `product`.`ID` = `product_price`.`post_id`
                )
            )
        )
    LEFT JOIN `wp_postmeta` `product_weight`
    ON
        (
            (
                `product`.`ID` = `product_weight`.`post_id`
            )
        )
    )
WHERE
    (
        (
            (`product`.`post_type` = 'product') 
          OR(`product`.`post_type` = 'product_variation')

        ) AND(`product_sku`.`meta_key` = '_sku') AND(
            `product_price`.`meta_key` = '_price'
        ) AND(
            `product_weight`.`meta_key` = '_weight'
        )
    )
ORDER BY
    `product_id`

标签： woocommercefeed