News:

Support the VirtueMart project and become a member

Main Menu

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

Started by websmith, April 02, 2016, 02:41:55 AM

Previous topic - Next topic

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

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

jenkinhill

eg:
UPDATE ###_virtuemart_products
SET product_in_stock=100

(where ### is your table prefix)

BUT as always, test on a site backup first......
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

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)