Skip to content

Instantly share code, notes, and snippets.

@paulotruta

paulotruta/woocommerce-products.sql

Forked from mglaman/woocommerce-products.sql
Created June 13, 2019 10:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save paulotruta/a53a65ee4a456f7f0705dea4d5d71982 to your computer and use it in GitHub Desktop.
Save paulotruta/a53a65ee4a456f7f0705dea4d5d71982 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL query for wooCommerce to export products.
Raw
woocommerce-products.sql
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