News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

zero all stock

Started by Topknotch, November 20, 2018, 16:11:08 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Topknotch

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

AH

#1
November 20, 2018, 16:38:33 PM
If you have access to mysql it is a simple update to the product tab
Regards
A

Joomla 3.10.11
php 8.0

Topknotch

#2
November 20, 2018, 16:58:05 PM
yes I do, could you explain more please?
Many thanks

GJC Web Design

#3
November 20, 2018, 17:06:53 PM
UPDATE `#__virtuemart_products` SET `product_in_stock`= 0,`product_ordered`= 0
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

Topknotch

#4
November 20, 2018, 17:36:22 PM
thanks guys, all done  :D
Print
Go Up Pages1
User actions