Change the jos_ prefix to the prefix you are using.
-- zero all of the stock (products)
UPDATE jos_phocacart_products SET stock = '0';
Change the jos_ prefix to the prefix you are using.
-- zero all of the stock (products)
UPDATE jos_phocacart_products SET stock = '0';