How To Delete Promo Text For All Products All At Once?

Hi, how do i delete the promo text for all the products all at once? It's taking too long to go into each product and deleting it manually. Any tips would be helpful. Thanks

SQL query.

Log into your cPanel and use phpMyAdmin (if you have it). Choose the database for cscart v4



[sql]UPDATE cscart_product_descriptions SET promo_text= ''[/sql]



Query assumes your product_description table is named “cscart_product_descriptions” - which it would be by default.

The two single quotes set the field to an empty string.

[quote name='Magpie Don' timestamp='1414694077' post='195729']

SQL query.

Log into your cPanel and use phpMyAdmin (if you have it). Choose the database for cscart v4



[sql]UPDATE cscart_product_descriptions SET promo_text= ''[/sql]



Query assumes your product_description table is named “cscart_product_descriptions” - which it would be by default.

The two single quotes set the field to an empty string.

[/quote]



I just ran that query but the promo text is still there.

Did you get an error message?

[quote name='Magpie Don' timestamp='1414700060' post='195735']

Did you get an error message?

[/quote]



No error message. Actually no message at all. It just refreshes the page.

I'm at a total loss to assist you.

I've never run a SQL query and not gotten a response. I don't know how to fix that.

[quote name='Magpie Don' timestamp='1414704386' post='195738']

I'm at a total loss to assist you.

I've never run a SQL query and not gotten a response. I don't know how to fix that.

[/quote]



can you please tell me step by step on how to run that query? maybe i am doing something wrong.

If you use CS-Cart, not Multi-Vendor, additional query is required:



UPDATE `cscart_ult_product_descriptions` SET `promo_text`= ''




Please try

[quote name='eComLabs' timestamp='1414756450' post='195815']

If you use CS-Cart, not Multi-Vendor, additional query is required:



UPDATE `cscart_ult_product_descriptions` SET `promo_text`= ''




Please try

[/quote]



Just tried that too. Did not work. I attached a screenshot for you to see what i am doing.

Screen Shot 2014-10-31 at 8.22.06 AM.png

you have to select the table [color=#000000][size=2]cscart_product_descriptions and then run the sql :[/size][/color]



[color=#000088][size=2]UPDATE[/size][/color][color=#000000][size=2] [/size][/color][color=#666600][size=2][/size][/color][color=#000000][size=2]cscart_product_descriptions[/size][/color][color=#666600][size=2][/size][/color][color=#000000][size=2] [/size][/color][color=#000088][size=2]SET[/size][/color][color=#000000][size=2] [/size][/color][color=#666600][size=2][/size][/color][color=#000000][size=2]promo_text[/size][/color][color=#666600][size=2]=[/size][/color][color=#000000][size=2] [/size][/color][color=#008800][size=2]''[/size][/color]

go to structure,select table ,then switch to sql and apply

[quote name='demeldoo' timestamp='1414771569' post='195837']

you have to select the table [color=#000000][size=2]cscart_product_descriptions and then run the sql :[/size][/color]



[color=#000088][size=2]UPDATE[/size][/color][color=#666600][size=2][/size][/color][color=#000000][size=2]cscart_product_descriptions[/size][/color][color=#666600][size=2][/size][/color][color=#000088][size=2]SET[/size][/color][color=#666600][size=2][/size][/color][color=#000000][size=2]promo_text[/size][/color][color=#666600][size=2]=[/size][/color][color=#008800][size=2]''[/size][/color]



go to structure,select table ,then switch to sql and apply

[/quote]



Okay just tried that and this is what i get:

Screen Shot 2014-10-31 at 9.31.23 AM.png

remove everthing from sql and paste only



[color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]UPDATE[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]cscart_product_descriptions[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]SET[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]promo_text[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2]=[/size][/size][/font][/color][color=#008800][font=arial, verdana, tahoma, sans-serif][size=3][size=2]''[/size][/size][/font][/color]

[color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]UPDATE[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]cscart_product_descriptions[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]SET[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]promo_text[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2]=[/size][/size][/font][/color][color=#008800][font=arial, verdana, tahoma, sans-serif][size=3][size=2]'promo you text' herre[/size][/size][/font][/color]

[color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]UPDATE[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]cscart_product_descriptions[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]SET[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]promo_text[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2]=[/size][/size][/font][/color][color=#008800][font=arial, verdana, tahoma, sans-serif][size=3][size=2]'promo you text'[/size][/size][/font][/color]

[quote name='demeldoo' timestamp='1414773433' post='195839']

remove everthing from sql and paste only



[color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]UPDATE[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]cscart_product_descriptions[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]SET[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]promo_text[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2]=[/size][/size][/font][/color][color=#008800][font=arial, verdana, tahoma, sans-serif][size=3][size=2]''[/size][/size][/font][/color]



[color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]UPDATE[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]cscart_product_descriptions[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]SET[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]promo_text[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2]=[/size][/size][/font][/color][color=#008800][font=arial, verdana, tahoma, sans-serif][size=3][size=2]'promo you text' herre[/size][/size][/font][/color]



[color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]UPDATE[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]cscart_product_descriptions[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]SET[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]promo_text[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2]=[/size][/size][/font][/color][color=#008800][font=arial, verdana, tahoma, sans-serif][size=3][size=2]'promo you text'[/size][/size][/font][/color]

[/quote]







Okay the query below worked perfectly. Thank you so much for helping.



[color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]UPDATE[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]cscart_product_descriptions[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]SET[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]promo_text[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2]=[/size][/size][/font][/color][color=#008800][font=arial, verdana, tahoma, sans-serif][size=3][size=2]''[/size][/size][/font][/color]

[quote name='ambush510' timestamp='1414773682' post='195840']

Okay the query below worked perfectly. Thank you so much for helping.



[color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]UPDATE[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]cscart_product_descriptions[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000088][font=arial, verdana, tahoma, sans-serif][size=3][size=2]SET[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2][/size][/size][/font][/color][color=#000000][font=arial, verdana, tahoma, sans-serif][size=3][size=2]promo_text[/size][/size][/font][/color][color=#666600][font=arial, verdana, tahoma, sans-serif][size=3][size=2]=[/size][/size][/font][/color][color=#008800][font=arial, verdana, tahoma, sans-serif][size=3][size=2]''[/size][/size][/font][/color]

[/quote]



Do not forget the cscart_ult_product_descriptions table also

Is there such table?