Skip to content

Instantly share code, notes, and snippets.

@rootindex

rootindex/[TESTING] put all simple products in stock

Created February 25, 2016 09:31
Show Gist options
  • Save rootindex/e2ac15da751534461cbb to your computer and use it in GitHub Desktop.
Save rootindex/e2ac15da751534461cbb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
[TESTING] put all simple products in stock
UPDATE cataloginventory_stock_item AS s
INNER JOIN catalog_product_entity AS p ON s.product_id = p.entity_id
SET s.qty = '9999.0000', s.is_in_stock='1'
WHERE p.type_id = 'simple'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment