Forums / General Questions / Is this is the correct SQL statement for setting products to 'call for price'?

Is this is the correct SQL statement for setting products to 'call for price'?

Locked

Results 1 to 3 of 3

This thread is locked. New replies are disabled.

1 Jul 2007, 4:21 AM

tj1

Totally Zenned

Join Date:: Mar 2005
Location:: California
Posts:: 628
Plugin Contributions:: 0

Is this is the correct SQL statement for setting products to 'call for price'?

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.

1 Jul 2007, 4:22 AM

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Is this is the correct SQL statement for setting products to 'call for price'?

That should do it for you ...

Be sure to backup your database first ... and periodically during your updating make additional backups in case you moof up ... :cool:

1 Jul 2007, 4:23 AM

merlinpa1969

Totally Zenned

Join Date:: Mar 2004
Posts:: 13,031
Plugin Contributions:: 4

Re: Is this is the correct SQL statement for setting products to 'call for price'?

if your doing ALL of your products then you could just use

UPDATE products SET product_is_call = 1