Can I add a line of text to all products at once?

[jcrewe]

Hi there!

Just wondering if anyone knows if I can add a line of text in the product description of all of my products at once and, if so, how do I accomplish this? I have over 300 products so if I was to have to add the new text to each product individually it will take me forever.

Thanks in advance

Jennifer

[RodG]

Hi there!

Just wondering if anyone knows if I can add a line of text in the product description of all of my products at once and, if so, how do I accomplish this? I have over 300 products so if I was to have to add the new text to each product individually it will take me forever.

Thanks in advance

Jennifer

This is 'off the top of my head' so the syntax may not be 100% correct.

UPDATE `products_description` SET `products_description`= CONCAT(`products_description`, " New Text") WHERE 1 ;

To use this code you'll need to be using a tool such as phpmyadmin. First select your zencart products_description database table, then click the 'SQL' button and paste the code.
Change " New Text" to whatever you desire, then click the 'Go' button.

WARNING: There is no going back after pressing 'Go'. You'll either be greeted with some kind of error, or the upgrade will be almost instant. Like all database upgrades it will be prudent to make a copy of the database table *before* invoking this code.

Cheers
Rod

[Digiwinkel]

Open includes/templates/YOUR_TEMPLATE/templates and find product_info_display.php

You can add HTML nearly anywhere before the <!--bof--> en after the <!--eof--> lines:

Example:

Your HTML

<!--bof Category Icon -->
<?php if ($module_show_categories != 0) {?>
<?php
/**
* display the category icons
*/
require($template->get_template_dir('/tpl_modules_category_icon_display.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_category_icon_display.php'); ?>
<?php } ?>
<!--eof Category Icon -->

More HTML etc. etc...

[jcrewe]

Thank you RodG and Digiwinkel for your replies. RodG, I havent tried your suggestion yet because I am more comfortable working with HTML than I am with editing my database.

Digiwinkel, I tried your suggestion and it worked great! I am wondering, though, if I am able to delete this from a handful of products that it doesnt apply to? I know my original post stated that I wanted to apply it to all of the products but I was thinking that there would be a way to actually add to the product description in bulk and then just remove the newly added text individually from the few products it doesnt apply to as removing the newly added text from the few products it doesnt apply to would be a lot quicker than adding to all the products it does apply to.

I hope that makes sense

[Digiwinkel]

Editing Product_info_display will show your changes on any product in your cart :-)

If you want to add bulk HTML to more or most products Try Easypopulate CSV.

That way you can use Excel to add the HTML to the various product descriptions to selected products in Excel (product)rows.

Remember to Back-up your Dbase before making changes to it whatsoever!

[RodG]

I know my original post stated that I wanted to apply it to all of the products but I was thinking that there would be a way to actually add to the product description in bulk and then just remove the newly added text individually from the few products it doesnt apply to as removing the newly added text from the few products it doesnt apply to would be a lot quicker than adding to all the products it does apply to.

I hope that makes sense

Question. Exactly is it what you want to change? If it is the products *pages* then Digiwinkels solution is what you need.

If you wish to change the products *descriptions* then you'll need the SQL solution to change the descriptions in the database.

Cheers
Rod

[Kim]

Maybe check the Free Addons for the Boilerplate mod. I haven't used it but it might do what you want.

[gjh42]

Actually, there is not a boilerplate mod in Free Addons yet. You can use swguy's boilerplate tips given on his website, or the Extra Boilerplate mod currently posted in How to Add Content Below category listings?

These do require there to be an HTML comment in the description as a hook to replace or key in the new text.

[maria82g]

If you wish to change the products *descriptions* then you'll need the SQL solution to change the descriptions in the database.

Cheers
Rod

THE SQL says

SELECT * FROM `products_description` WHERE 1

so if I want to remove a few lines from the description what do I change and where?