mass quanity change

Hi,
Is there a way to change all the Items in my cart Quanity from 0 tp 100 in one operation. I have tried it exproting the database and making the changes but when imported it creates duplicate entries. The cart was a showcase so quanity did not matter and was not kept, but now its a store and we only want Sold out on items that are. :smile:
Peace

Is there a way to change all the Items in my cart Quanity from 0 tp 100 in one operation
Use phpmyadmin or the admin sql function

BACKUP YOUR DATABASE FIRST!
BACKUP YOUR DATABASE FIRST!
BACKUP YOUR DATABASE FIRST!

Run this sql statement

UPDATE products SET products_quantity = 100

Hi,
Thank you so much I tried a couple of queries but was not getting the syntax right so then I started second guessing my self on being able to do it this way. :smile:
PEACE