Question MYSQL bulk update of items

[jl255]

I have more than 200 items that I need to update since upgrading vbshop. I can't possibly go into everyone of them to edit, which i already did when i first moved over to vbshop.

I need to make the following mass edits:

giftable: YES
PM on gift: YES
Unique: NO
Item Price: 1
Stock: -1

Are you able to give me the mysql statements to run to make these mass edits of all items? Tks.

 

[Fillip H.]

UPDATE dbtech_vbshop_item SET giftable = '1', giftpm = '1', uniqueitem = '0'

UPDATE dbtech_vbshop_shopinventory SET price = 1, stock = '-1', maxstock = '-1'

Afterwards, click the Repair Cache link to update the cache