Skip to content

Instantly share code, notes, and snippets.

@oreales

oreales/magento_product_in_stock_by_website.sql

Created March 16, 2016 11:48
Show Gist options
  • Save oreales/d61254dcfd801a2c9616 to your computer and use it in GitHub Desktop.
Save oreales/d61254dcfd801a2c9616 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
magento_product_in_stock_by_website.sql
#SQL para obtener los productos que hay en stock en cada website:
SELECT w.name as site, count(`product_id`) as productos_en_stock FROM cataloginventory_stock_status AS s LEFT JOIN core_website as w USING(website_id) WHERE stock_status = 1 GROUP BY website_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment