Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: websmith on April 02, 2016, 02:41:55 AM

Title: Is there a way to set all products to a set number for inventory
Post by: websmith on April 02, 2016, 02:41:55 AM
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
Title: Re: Is there a way to set all products to a set number for inventory
Post by: GJC Web Design on April 02, 2016, 11:17:53 AM
easiest is just do a general update directly in the DB
Title: Re: Is there a way to set all products to a set number for inventory
Post by: jenkinhill on April 02, 2016, 11:54:31 AM
eg:
UPDATE ###_virtuemart_products
SET product_in_stock=100

(where ### is your table prefix)

BUT as always, test on a site backup first......
Title: Re: Is there a way to set all products to a set number for inventory
Post by: Studio 42 on April 03, 2016, 00:07:53 AM
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)
Text only | Text with Images