How to set qty – 50 for all products
-
How to set Qty = 50 for all simple and variation products in the website ?
we have thousands of products. please give me some automated solution or any code or sql query ?
Hello,
To bulk-set stock quantity to 50 in WooCommerce:
1. Go to WooCommerce > Products.
2. Filter products if needed.
3. Select all products and choose Edit from Bulk Actions.
4. In the Manage Stock? set qty 50 in Stock Qty.
5. Click Update.
Best Regards
will it work for the variant/variation/configurable products also ? T shirt size size : L & M
so both will update to 50 ?
Please check my above comment , also : “Select all products” will select all 1000’s of products in website or it willl select only that particular page products ? is there any options to select all 1000s of products ? or shall i run below query in phpmyadmin ?
UPDATE wp_postmeta
SET meta_value = ’50’
WHERE meta_key = ‘_stock’;
Hello,
Yes, the process will work for variations as well. When using bulk edit, the “Select all products” option typically applies only to the products listed on the current page of the admin panel. To apply changes to all products across the website, you will need to adjust the pagination settings or perform the updates in batches.
Best Regards
.
