For my sins I've taken over a M2 website, not had the pleasure of using it since M1.9 4 years ago... it's changed a bit :-)
This store uses Grouped products, with one Item Default Quantity 1 and the rest are Default Quantity 0
Is the a bulk action to default all grouped product to 0 where Default Quantity = 1
or any clue as to which table in the database it is stored, so I can change it via a SQL command?
Hello @mallongstoe6b2
UPDATE catalog_product_link SET qty = 0 WHERE link_type_id = 3 AND product_id IN ( SELECT product_id FROM catalog_product_entity_int WHERE attribute_id = [attribute_id] AND value = 1 )
Replace [attribute_id] with the "attribute_id" value you copied in step 3.
This command updates the "qty" value to 0 for all grouped product links where the product has a default quantity attribute of 1.
Make sure you take database backup first.
Hi @theMageComp
Step two
Find the table "catalog_product_link_attribute_decimal" and locate the row with the attribute code "qty".
I have the following 4 columns in the catalog_product_link_attribute_decimal table
value_id
product_link_attribute_id
link_id
value
How do I find the row with the attribute code "qty" ?
Cheers
Mal