Skip to content

Instantly share code, notes, and snippets.

@falexandrou

falexandrou/stock_sales.sql

Created September 22, 2017 07:48
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 falexandrou/280080112f7a6b65d30e38d8b919b0fa to your computer and use it in GitHub Desktop.
Save falexandrou/280080112f7a6b65d30e38d8b919b0fa to your computer and use it in GitHub Desktop.
Download ZIP
[WooCommerce] Get current values for a product's sales and stock quantity
Raw
stock_sales.sql
SELECT
p.post_title AS "Product title",
t1.meta_value AS "Items Sold",
t2.meta_value AS "Current Stock Quantity",
NOW() AS "Current Date"
FROM
wp_posts p
LEFT JOIN (SELECT meta_value, post_id FROM wp_postmeta WHERE meta_key='total_sales') t1 ON t1.post_id=p.ID
LEFT JOIN (SELECT meta_value, post_id FROM wp_postmeta WHERE meta_key='_stock') t2 ON t2.post_id=p.ID
WHERE p.ID=102176;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment