I really don't know SQL so I would appreciate it if someone can confirm whether the following is the correct SQL statement (not sure if that's what you call it) to set a product to 'call for price'
UPDATE products SET product_is_call = 1 WHERE products_model = 'XXXXX' LIMIT 1;
I have run a test and it seems to work, but I would like someone to confirm that I'm not doing anything wrong.
I have a couple hundred products that I need to set to 'call for price' and it would be a lot easier to run the statements rather than updating each product manually one by one.
Bookmarks