Is there a way to set all products to a set number for inventory

[websmith]

VM 3.0.12 and joomla 3.4.8

I have a couple hundred products in my store and now need to set the inventory to a specific number. Is there a way to do this globally? Set all products to display say 100 for inventory qty? Or does this have to be done manually product by product? Thanks in advance

[GJC Web Design]

easiest is just do a general update directly in the DB

[jenkinhill]

eg:
UPDATE ###_virtuemart_products
SET product_in_stock=100

(where ### is your table prefix)

BUT as always, test on a site backup first......

[Studio 42]

You can buy my product http://shop.st42.fr/en/products/vm-be-pro-batch-product-edit.htm
The component can quick bulk update many fields and have advanced filter to find the right products.
This can import too from multiple XLS or ODS sheets in the new release coming soon(i provide it but it's on beta stage)