29 Apr 2008, 9:16 AM
Totally Zenned
- Join Date:
- Feb 2007
- Posts:
- 1,724
- Plugin Contributions:
- 0
mass weight change??
im wanting to mass weight change my products from certain catogaories ie.
all the products in this section http://www.rubberduckbathrooms.co.uk/store/index.php?main_page=index&cPath=31 want there wirhgt setting to 2
where items in this section http://www.rubberduckbathrooms.co.uk/store/index.php?main_page=index&cPath=18_20 want a weight of 80
ive done a mass change of pricing using this SQL
update products set products_price = products_price * 1.05 where manufacturers_id = 8;
to update item by 5% but how can i do it for weight???