How-To: Add new Properties to your Products

I've been following this thread in hopes that the question was answered on how to show the new product field on the product listing page. I have successfully gotten it to show up in the admin on the product page and on the site on the individual product pages but would like to also see it when you click on a category and it lists all of the products at once.
I'm using the product listing column mod so I'm not sure if that is why I can't get the extra fields to show up on that page.
Heres the website I'm working on:
http://www.tilvee.com
If anyone has figured this out, please let me know.
Just to further clarify, when your on this page of the website:
http://www.tilvee.com/index.php?main_page=index&cPath=65
I would like to be able to see my newly added field underneath the product name.

Thanks!

Hi,

I have successfully installed this mode and love it. It was just what I was looking for.

I would like to point out something that may help someone else that is having a problem with getting the information to show up on the catalog side.

I installed all the code exactly where everything was said to go. I did not get it to show up on my product page the first time. So, I got looking at all my files and recalled I am not using the default template I use cherry zen. Looking in the includes/templates/cherry_zen/templates/ there was the same file that was in the templates default folder called ** tpl_product info_display.php**!
I made the changes to this file and it worked.

So, if you don't use the the main template that comes with zencart or overrides this may be your problem too.

As for adding it to the other product pages..slow down and look. It's easier than you think.

I am still new to php and learning every day..

Thanks for this great mode!!!!!:D

Mack32

can somebody please tell me how to do step 2? the DB manipulation?

i use hostgator so i loged into the admin cp, my sql, myphpadmin

found the table products, and i cant seem to figure out how to add a column to the table.

i need to add a column that will be called "car make" which will allow people to not only browse by categories and manufacturer, but also by their car make (its a car parts store)

any input will be appreciated as i am new to this.
thanks!

credenscel,

To add this field to the database without going through your phpmyadmin copy and paste the following into your admin section in your zencart. Click on tools and scroll down to install sql patches and click on that.

Read all below before you do anything.

copy and paste the correct code

If you did not add a prefix to your database when you installed zencart then you would use this code

ALTER TABLE products ADD products_car_make VARCHAR( 32 ) NOT NULL;

If you did use a prefix when you installed zencart change the word zencart below to the prefix you used.

ALTER TABLE **zencart**_products ADD products_car_make VARCHAR( 32 ) NOT NULL;

example if you used cattail for your prefix than this is what it would look like.

ALTER TABLE cattail_products ADD products_car_make VARCHAR( 32 ) NOT NULL;

Now copy and paste the code into you install sql patches area and click send.

Hope this helps

Mack32

thank you very much for the input!! it worked!!!! :clap:

Glad I could help. :smile:

Mack32

Alright, I've followed this step by step, with an additional step to define the text before the output.

My question is this:

I am using this as a rating/ranking area that will display a value between 1 and 5, right now it display the number just fine, but I need it to display an image.

So if I enter 1 in the ranking box in the admin, it will display image1.gif in the product info, if I enter 4 into the ranking box in the admin it will display image4.gif into the product info etc....

How do I get it to do this ???

Awesome thread and kudos for this, it is really helping me a lot.

Alright..... I managed to figure it out !!!!

Here's the result

<!--bof Product Historical Rating --> <?php if (!empty($product_info->fields['products_historic'])) echo TEXT_HISTORICAL . zen_image(DIR_WS_TEMPLATE_IMAGES . $product_info->fields['products_historic'] . '.gif'); ?> <!--eof Product Historical Rating -->

What this will do is take the number you input into the admin field, and turn it into an image that is called from the templates image folder.... so if you input 4 into the admin field for the historical ranking, then it will display 4.gif

Now it's time for another redbull and some advil.....

Thanks for this post, this makes it easy to add new properties to a product. I am having an issue though about being able to search from the Catalog\Categories/Products page of the admin site.

I added a new property called products_UPC which contains a UPC code for each product. I want to be able to search for the UPC code. Currently if I put a UPC in the search box and press enter it doesn't return any results. I know the UPC wasn't mis-typed as I'm using a barcode scanner to fill in the search field. Also, I know the UPC is in the DB because it comes up on the product page. I've even tried copying/pasting from the product page with no successful searches. I've successfully made it where you can search using "Advanced Search" from the home page by UPC and that works, just can't search from the Admin page.

Can someone point me in the right direction for getting this to work from the admin page?

Thanks,
Keith

Thank you chris for your excellent instructions.

I was able to add the field in the DB and collect_info & preview_info and other files but always missed out on update_info.php. After reading through your instructions I redid everything again, and then realized that the update file was right under my nose but always missed it.

I also updated the general.php >> function >> includes >> admin since my additional field required a function.

Now its all sweet.

Just to let everyone know, if you wanna add a field something like product_description, which would need some textarea, I would suggest you to add the extra field at the end of TABLE_PRODUCTS_DESCRIPTION instead of TABLE_PRODUCTS. Also, go through each of the files listed in the instructions (post #1 of this thread) and search for the product_description field and then add your field along with the product_description.

Also, while doing this it is very important that the order of fields as in DB is followed when appending the php commands related to the new field in various sql queries in the files. for a better explaination, if say in the DB of TABLE_PRODUCTS_DESCRIPTION you have fields

product_id
language_id
product_description
product_url
product_viewed
product_XYZ <new field appended into the table>

Now when you modify sql queries, they may be already written as in any of the files mentioned by chris as in the preview_info.php near line 43

if (isset($_GET['read']) && ($_GET['read'] == 'only')) {
       
        $pInfo->products_name = zen_get_products_name($pInfo->products_id, $languages[$i]['id']);
        $pInfo->products_description = zen_get_products_description($pInfo->products_id, $languages[$i]['id']);
        $pInfo->products_url = zen_get_products_url($pInfo->products_id, $languages[$i]['id']);

         //THIS IS WHERE THE NEW FIELD WILL GO SINCE IT WILL FOLLOW THE ORDER OF FIELDS FROM THE DB TABLE
        $pInfo->products_XYZ = zen_get_products_XYZ($pInfo->products_id, $languages[$i]['id']);

} else {

        $pInfo->products_name = zen_db_prepare_input($products_name[$languages[$i]['id']]);
        $pInfo->products_description = zen_db_prepare_input($products_description[$languages[$i]['id']]);
        $pInfo->products_url = zen_db_prepare_input($products_url[$languages[$i]['id']]);

        //THIS IS WHERE THE NEW FIELD WILL GO SINCE IT WILL FOLLOW THE ORDER OF FIELDS FROM THE DB TABLE
        $pInfo->products_XYZ = zen_db_prepare_input($products_XYZ[$languages[$i]['id']]);

}

Hope this helps someone. Thanks chris.

Hi,
I've carefully read this thread - I want to tailor Zencart to fit my needs better: not just the catalog but also the Admin side of things, as more than just I will be admin-ing the store.
Early on in the thread there was a post about adding a table to the database that would contain the fields being added - this as opposed to simply adding fields to existing tables. I'm trying to determine the risks involved in these two approaches:

1. if the file structure of the database is ever updated, will new (non-standard to Zen) tables be a. erased? b. ignored? c. updated?
2. in the scenario above except instead of a new table, fields have been added to existing tables, will the new fields (non-standard to Zen) be a. erased? b. ignored? c. updated?

On the php pages side of things, I think I've finally got my head around using templates. Let's say I have a template called 'roses', for which there is a folder called roses in the
/store/includes/templates
folder. Then, if I change a file anywhere in the store, I simply add a folder called roses and place my modded file in it. For example, in the
/store/includes/languages/english/
I modified index,php. I added a folder called roses:
/store/includes/languages/english/roses/
into which I placed my modded index.php
This seems to work right the way round the shop... and from what I've read, will keep updates from overwriting your mods. My question is: will this same approach work for modded product_x.php files, i.e., pages that reference new fields and tables?

I hope that last question wasn't too obscure... can't think of a different, clearer way of asking it...

Thanks to all that reply...

Never mind, think I might have found the answers here...

Hi, I have read this thread and its great stuff.

I am choosing to create a new DB table called "product_recess_attr" it will contant products_id to link it to products

I've added into the query TABLE_PRODUCT_RECESS_ATTR(IN RED), but I get the following error:

1146 Table 'zencart.TABLE_PRODUCT_RECESS_ATTR' doesn't exist

Do I need to define this table elsewhere in zencart?

Thankyou in advance.

if (isset($_GET['pID']) && empty($_POST)) {
  $product = $db->Execute("select pd.products_name, pd.products_description, pd.products_url,
                                  p.products_id, p.products_quantity, p.products_model,
                                  p.products_image, p.products_price, p.products_virtual, p.products_weight,
                                  p.products_date_added, p.products_last_modified,
                                  date_format(p.products_date_available, '%Y-%m-%d') as
                                  products_date_available, p.products_status, p.products_tax_class_id,
                                  p.manufacturers_id,
                                  p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
                                  p.product_is_free, p.product_is_call, p.products_quantity_mixed,
                                  p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max,
                                  p.products_sort_order,
                                  p.products_discount_type, p.products_discount_type_from,
                                  p.products_price_sorter, p.master_categories_id,
								  pra.products_min_hole
                          from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCT_RECESS_ATTR . " pra
                          where p.products_id = '" . (int)$_GET['pID'] . "'
						  and  pra.products_id = '" . (int)$_GET['pID'] . "'
                          and p.products_id = pd.products_id
                          and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");

dukie6675:

Hi, I have read this thread and its great stuff.

I am choosing to create a new DB table called "product_recess_attr" it will contant products_id to link it to products

I've added into the query TABLE_PRODUCT_RECESS_ATTR(IN RED), but I get the following error:

1146 Table 'zencart.TABLE_PRODUCT_RECESS_ATTR' doesn't exist

Do I need to define this table elsewhere in zencart?

Thankyou in advance.

if (isset($_GET['pID']) && empty($_POST)) {
  $product = $db->Execute("select pd.products_name, pd.products_description, pd.products_url,
                                  p.products_id, p.products_quantity, p.products_model,
                                  p.products_image, p.products_price, p.products_virtual, p.products_weight,
                                  p.products_date_added, p.products_last_modified,
                                  date_format(p.products_date_available, '%Y-%m-%d') as
                                  products_date_available, p.products_status, p.products_tax_class_id,
                                  p.manufacturers_id,
                                  p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
                                  p.product_is_free, p.product_is_call, p.products_quantity_mixed,
                                  p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max,
                                  p.products_sort_order,
                                  p.products_discount_type, p.products_discount_type_from,
                                  p.products_price_sorter, p.master_categories_id,
  							  pra.products_min_hole
                          from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCT_RECESS_ATTR . " pra
                          where p.products_id = '" . (int)$_GET['pID'] . "'
  					  and  pra.products_id = '" . (int)$_GET['pID'] . "'
                          and p.products_id = pd.products_id
                          and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");

I figured out how to define the database table in the: database_tables.php file, now I get this error:

Warning: reset() [function.reset]: Passed variable is not an array or object in /web/zen-cart/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /web/zen-cart/admin/includes/classes/object_info.php on line 30

dukie6675:

I figured out how to define the database table in the: database_tables.php file, now I get this error:

Warning: reset() [function.reset]: Passed variable is not an array or object in /web/zen-cart/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /web/zen-cart/admin/includes/classes/object_info.php on line 30

if (isset($_GET['pID']) && empty($_POST)) {
$product = $db->Execute("select pd.products_name, pd.products_description, pd.products_url,
p.products_id, p.products_quantity, p.products_model,
p.products_image, p.products_price, p.products_virtual, p.products_weight,
p.products_date_added, p.products_last_modified,
date_format(p.products_date_available, '%Y-%m-%d') as
products_date_available, p.products_status, p.products_tax_class_id,
p.manufacturers_id,
p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
p.product_is_free, p.product_is_call, p.products_quantity_mixed,
p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max,
p.products_sort_order,
p.products_discount_type, p.products_discount_type_from,
p.products_price_sorter, p.master_categories_id,
pra.products_min_hole
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCT_RECESS_ATTR . " pra
where p.products_id = '" . (int)$_GET['pID'] . "'
and p.products_id = pd.products_id 
and p.products_id = pra.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");

it looked like you where trying to get the id twice. the only id you need to get is p.products_id and link all others.

not sure if this will even work with out allot of other files being edited.

adding your own tables is a great idea but to edit the core files dose not make it easy when they change or up date the programing you should try to place your files in an overrides folder when you can. you should link the table where needed and make all the files you edited into a override file so you can keep your changes. otherwise you should just add the fields to your products table if you not going to do this to keep your information.

poolprorich:

if (isset($_GET['pID']) && empty($_POST)) {
$product = $db->Execute("select pd.products_name, pd.products_description, pd.products_url,
p.products_id, p.products_quantity, p.products_model,
p.products_image, p.products_price, p.products_virtual, p.products_weight,
p.products_date_added, p.products_last_modified,
date_format(p.products_date_available, '%Y-%m-%d') as
products_date_available, p.products_status, p.products_tax_class_id,
p.manufacturers_id,
p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
p.product_is_free, p.product_is_call, p.products_quantity_mixed,
p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max,
p.products_sort_order,
p.products_discount_type, p.products_discount_type_from,
p.products_price_sorter, p.master_categories_id,
pra.products_min_hole
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCT_RECESS_ATTR . " pra
where p.products_id = '" . (int)$_GET['pID'] . "'
and p.products_id = pd.products_id
and p.products_id = pra.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");

> 
> it looked like you where trying to get the id twice. the only id you need to get is p.products_id and link all others.
> 
> not sure if this will even work with out allot of other files being edited.
> 
> adding your own tables is a great idea but to edit the core files dose not make it easy when they change or up date the programing you should try to place your files in an overrides folder when you can. you should link the table where needed and make all the files you edited into a override file so you can keep your changes. otherwise you should just add the fields to your products table if you not going to do this to keep your information.


Does my pra.products  need to be defined elsewhere? I get an error that it doesnt like passing a variable.

callingrohit:

Thank you chris for your excellent instructions.

I was able to add the field in the DB and collect_info & preview_info and other files but always missed out on update_info.php. After reading through your instructions I redid everything again, and then realized that the update file was right under my nose but always missed it.

I also updated the general.php >> function >> includes >> admin since my additional field required a function.

Now its all sweet.

Just to let everyone know, if you wanna add a field something like product_description, which would need some textarea, I would suggest you to add the extra field at the end of TABLE_PRODUCTS_DESCRIPTION instead of TABLE_PRODUCTS. Also, go through each of the files listed in the instructions (post #1 of this thread) and search for the product_description field and then add your field along with the product_description.

Also, while doing this it is very important that the order of fields as in DB is followed when appending the php commands related to the new field in various sql queries in the files. for a better explaination, if say in the DB of TABLE_PRODUCTS_DESCRIPTION you have fields

product_id
language_id
product_description
product_url
product_viewed
product_XYZ <new field appended into the table>

Now when you modify sql queries, they may be already written as in any of the files mentioned by chris as in the preview_info.php near line 43

if (isset($_GET['read']) && ($_GET['read'] == 'only')) {

    $pInfo->products_name = zen_get_products_name($pInfo->products_id, $languages[$i]['id']);
    $pInfo->products_description = zen_get_products_description($pInfo->products_id, $languages[$i]['id']);
    $pInfo->products_url = zen_get_products_url($pInfo->products_id, $languages[$i]['id']);

     //THIS IS WHERE THE NEW FIELD WILL GO SINCE IT WILL FOLLOW THE ORDER OF FIELDS FROM THE DB TABLE
    $pInfo->products_XYZ = zen_get_products_XYZ($pInfo->products_id, $languages[$i]['id']);

} else {

    $pInfo->products_name = zen_db_prepare_input($products_name[$languages[$i]['id']]);
    $pInfo->products_description = zen_db_prepare_input($products_description[$languages[$i]['id']]);
    $pInfo->products_url = zen_db_prepare_input($products_url[$languages[$i]['id']]);

    //THIS IS WHERE THE NEW FIELD WILL GO SINCE IT WILL FOLLOW THE ORDER OF FIELDS FROM THE DB TABLE
    $pInfo->products_XYZ = zen_db_prepare_input($products_XYZ[$languages[$i]['id']]);

}

> 
> 
> Hope this helps someone. Thanks chris.

I would also like to add to my message something i just forgot to write earlier...

it is very important to also update the file **copy_to_confirm.php** so as to transfer all the fields appropriately over to the duplicate product.

Otherwise if you don't update this file with the new fields, the data within the fields will not be carried over to the duplicate product.

have fun !!!

Great thread but wondering if this is the way to go for what I need. I sell digital books which have a book #, author, publisher and published date info. I would like the products page to show all these info and be linkable (eg. author is linked to other books of same author) and also be able to search by author and publisher.

Is it better and easier to use this mod or use attributes? If I use attributes, it may seem that I will be creating a LOT of Option Values since there are thousands of authors and publishers but at least they will be uniform - no chance of duplicate authors and pubs. Then there is the issue of zen product updates losing my data or making it not compatible using this mod - there will eventually be over 100,000 products! :wacko:

As for the book #, I can use the Products Model field. For the published date, I can just put that in the product description.

Thanks!

First off all great thread !! Helped me a lot.Managed to add new field to my product description.
Added 1 new field - "products_fit" (same as "product_description") to TABLE_PRODUCTS_DESCRIPTION ,
and 1 new field - "product_fiton" (true or false ) to TABLE_PRODUCTS_DESCRIPTION to check if to display "product_fit" to the products info display page, as i dont need this feature to all of my products.
Every thing work fine and displays OK until i want to check "products_fiton" if to display additional description on product.
This is the code that i used:

<!--eof Product description -->
<!--bof Product fit -->
<h2 id="productPrices" class="productGeneral"></h2>
<?php $products_check = $db->Execute("select * from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '$products_id'");
     if ($products_check->fields['products_fiton'] != "0") {
} else {
?>
<div id="productDescription">
<a href="javascript:animatedcollapse.toggle('jason')"><h1 id="productName" class="productGeneral">Show all vehicles which match</h1></a> 
<div id="jason" style="background: #FFFFCC; display:none">
<?php if (!empty($product_info->fields['products_fit'])) echo $product_info->fields['products_fit']; ?></div>
<?php } ?>
<!---eof Product fit -->

For the check feature display true or false i have edited only tpl_product_info_display.php
I got inspired from the Dual Pricing Addon.
this way it does not display enyting from the additional description.Maybe some one can give a hint here to look for the mistake...

Also i am preparing a post with the steps that i used to make the additional fields: they are editable over the Admin with prewiew, multilanguage suport and work with Easypopulate.

Best regards Zoli.

Hi crazy_chris, I have been able to apply this and it works. So I was able to add other properties like format, publisher, author, etc to my bookshop. However, I tried to add things like Sample page, Table of contents but it would not work because, the text boxes seem to only accept one line of text. So for any bulleted information such as Table of Contents, it would only place the first line when I try to paste copied article in it only the first line would paste. Is there a way to make it look like the product description text box so it can accept multiple lines of texts even in pasting?

Again is there a way to make it linked texts such that I can type "Table of Contents" and create a hyperlink to a place where it would show the Table of Contents in a page of its own?

I would really appreciate any support on this.

Uche (vastcollection.com)