Print Page - zero all stock

Title: zero all stock
Post by: Topknotch on November 20, 2018, 16:11:08 PM

Hi,

I need to set all stock and booked to zero , but keeping the products.
Any ideas please?
Many thanks
VirtueMart 3.4.2 joomla 3.9.0

Title: Re: zero all stock
Post by: AH on November 20, 2018, 16:38:33 PM

If you have access to mysql it is a simple update to the product tab

Title: Re: zero all stock
Post by: Topknotch on November 20, 2018, 16:58:05 PM

yes I do, could you explain more please?
Many thanks

Title: Re: zero all stock
Post by: GJC Web Design on November 20, 2018, 17:06:53 PM

UPDATE `#__virtuemart_products` SET `product_in_stock`= 0,`product_ordered`= 0

Title: Re: zero all stock
Post by: Topknotch on November 20, 2018, 17:36:22 PM

thanks guys, all done :D

VirtueMart Forum