We are using ML 8.0.1.2
1. We want to use this plugin from ecommerce cart mods to increase the prices in-bulk, a couple of our categories: http://www.ecommercecartmods.com/p-4...torefront.aspx
2. But the plugin changes price based on the manufacturer (not the category), and we don't currently use the Manufacturer field
3. Can anyone provide a simple script for SQL Server 2005 that says, for all categories = 'necklaces', change manufacturer to 'Smith'
4. Then we can use this same script to change all the other categories to their appropriate manufacturers as well.
5. Any help would be greatly appreciated.