A simple query to set the first combination of products as default.
The query will only work for products that do not have any the combination set as the default.
SET `default_on` = 1
WHERE `id_product_attribute` IN (
WHERE `id_product` IN (
FROM `ps_product_attribute` pa
WHERE 0 = (
WHERE `default_on` = 1 AND `id_product` = pa.`id_product`
GROUP BY pa.`id_product`
GROUP BY `id_product`
Module allows to automatically update product status and visibility based on stock available with multistore and attribute combinations support included.
- You will save a lot of time. Products will be automatically turned on and off when manually updating product quantities and sales
- The module automatically turns on or off newly imported or updated products
- Multistore support. You can configure the module individually for each store
- Product attribute combinations support
- Since version 1.1 you can choose what you want to do:
- change product visibility (show/hide)
- change product status (enable/disable)
For More details and download go to: