Skip to content

Instantly share code, notes, and snippets.

@pejantantangguh
Forked from mglaman/woocommerce-products.sql
Created December 19, 2018 05:15
Show Gist options
  • Save pejantantangguh/e3c025492fb1de3aa42ddcbc91cfd7ae to your computer and use it in GitHub Desktop.
Save pejantantangguh/e3c025492fb1de3aa42ddcbc91cfd7ae to your computer and use it in GitHub Desktop.
MySQL query for wooCommerce to export products.
SELECT product.ID as product_id, product.post_title as product_name, replace(product.post_content, '"', "'") as product_content, product_sku.meta_value as product_sku, product_price.meta_value as product_price, product_weight.meta_value as product_weight
FROM wp_posts as product
LEFT JOIN wp_postmeta as product_sku ON product.ID = product_sku.post_ID
LEFT JOIN wp_postmeta as product_price ON product.ID = product_price.post_ID
LEFT JOIN wp_postmeta as 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 ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment