How-To: Add new Properties to your Products

**webego** · 30 Mar 2009, 04:04 PM

I have posted a mix of the OP solution on this thread and the one by zskiman (mid thread) plus my own additions which allows the creation of new product fields, held in a separate table and declared so they can be inserted into the page in the same manner as existing fields.

http://www.zen-cart.com/forum/showthread.php?t=120523

Hopefully of use to someone.

G

**miriam_t** · 6 May 2009, 09:11 PM

Does anybody know how to add an additional IMAGE field to the product table?

I need this to display a special image at a place other than main image or additional images.

I managed to add various fields which all show up fine both in admin and catalog but the newly created image field isn't shown nor is the file-name in the database as it should be. I simply copied some parts from the main image for this new image field. It is displayed on the preview_info.php but gets lost on its way to be stored.

Can someone give a hint on this issue? Thanks in advance!

**gamesmart** · 3 Aug 2009, 05:50 PM

I've added without problems many new fileds in my products page like this:

hhttp://www.dvdmart.it/shop/007-il-m...a-p-91410.html

now i'm trying to add many of these fiels in products_all listing, featured, new etc.

my work:

includes/modules/product_listing.php

near line 30:

case 'PRODUCT_LIST_NAME':
$lc_text = TABLE_HEADING_PRODUCTS;
$lc_align = '';
$zc_col_count_description++;
break;

case 'PRODUCT_LIST_MYFIELD':
$lc_text = TABLE_HEADING_MYFIELD;
$lc_align = '';
$zc_col_count_description++;
break;

near line 100:

case 'PRODUCT_LIST_MODEL':
$lc_align = '';
$lc_text = $listing->fields['products_model'];
break;

case 'PRODUCT_LIST_MYFIELD':
$lc_align = '';
$lc_text = $listing->fields['products_myfieldsqlname'];
break;

includes/modules/pages/index/main_template_vars.php

near line 136:

// create column list
$define_list = array(
'PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
'PRODUCT_LIST_MYFIELD' => PRODUCT_LIST_MYFIELD,

near line 163:

switch ($column_list[$i])
{
case 'PRODUCT_LIST_MODEL':
$select_column_list .= 'p.products_model, ';
break;
case 'PRODUCT_LIST_MYFIELD':
$select_column_list .= 'products_myfieldsqlname, ';
break;

includes/index_filters/default_filter.php

near line 28, 43, 58, 73:

$listing_sql = "select " . $select_column_list . " p.products_id, p.products_myfieldsqlname,

near line 117:

case 'PRODUCT_LIST_NAME':
$listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : '');
break;
case 'PRODUCT_LIST_MANUFACTURER':
$listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
break;
case 'PRODUCT_LIST_MYFIELD':
$listing_sql .= "p.products_myfieldsqlname" . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
break;

near line 122:

case 'PRODUCT_LIST_MANUFACTURER':
$listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
break;
case 'PRODUCT_LIST_MYFIELD':
$listing_sql .= "p.products_myfieldsqlname" . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
break;

includes/modules/template/MYTEMPLATE/template/tpl_modules_products_all_listing.php

near line 42:

if (PRODUCT_ALL_LIST_MODEL != '0' and zen_get_show_product_switch($products_all->fields['products_id'], 'model')) {
$display_products_model = '' . TEXT_PRODUCTS_MODEL . '' . $products_all->fields['products_model'] . str_repeat(' ', substr(PRODUCT_ALL_LIST_MODEL, 3, 1));
} else {
$display_products_model = '';
}
if (PRODUCT_ALL_LIST_MYFIELD != '0' and zen_get_show_product_switch($products_all->fields['products_myfieldsqlname'], 'myfield')) {
$display_products_myfield = '' . TEXT_PRODUCTS_MYFIELD . '' . $products_all->fields['products_myfieldsqlname'] . str_repeat(' ', substr(PRODUCT_ALL_MYFIELD, 3, 1));
} else {
$display_products_myfield = '';
}

near line 141:

if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_MYFIELD') {
echo $display_products_model;
}
if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_MYFIELD') {
echo $display_products_myfield;
}
near line 177:

if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_MODEL') {
echo $display_products_model;
}
if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_MYFIELD') {
echo $display_products_myfield;
}

includes/languages/MYTEMPLATE/english etc

define('TEXT_PRODUCTS_MYFIELD', 'My extra products field');

in my database i've added:

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (1200, 'Show my myfield', 'PRODUCT_ALL_LIST_MYFIELD', '2506', 'bla bla bla', 21, 13, NULL, '2006-07-05 13:59:40', NULL, NULL);

Nothing appear here:

http://www.dvdmart.it/shop/products_all.html

whats wrong?
Thanks!

**gamesmart** · 3 Aug 2009, 06:17 PM

i can't modify my last post, on

near line 141:

if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_MYFIELD') {
echo $display_products_model;
}
if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_MYFIELD') {
echo $display_products_myfield;
}

right is

near line 141:

if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_MODEL') {
echo $display_products_model;
}
if ($disp_sort_order->fields['configuration_key'] == 'PRODUCT_ALL_LIST_MYFIELD') {
echo $display_products_myfield;
}

thanks!

**gamesmart** · 10 Aug 2009, 02:49 PM

Resolved, ALONE.

**shen** · 10 Sep 2009, 11:35 AM

I tried using this but didn't get the desired results. On further delving I believe the original how-to is mistaken, and I'm not sure why it works for so many others.

I'm not a professional coder but I was able to fix it by replicating the way products_weight is handled. (I am adding height, length and width properties.)

I'm not sure if all the following additions are necessary, but they worked for me. The main problem is that copy_to_confirm.php was not modified in this how-to. All additions based on a property product_height.

1) update_product.php (in /admin/includes/modules/)
a) around line 30, ADD:

Code:

    $tmp_value = zen_db_prepare_input($_POST['products_height']);
    $products_height = (!zen_not_null($tmp_value) || $tmp_value=='' || $tmp_value == 0) ? 0 : $tmp_value;

b) around line 40 ($sql_data_array = ....), ADD:

Code:

'products_height' => $products_height,

2) copy_to_confirm.php (in /admin/includes/modules/)
a) around line 37 ($product = $db->Execute...) ADD:

Code:

, products_height

b) around line 52 ADD:

Code:

            $tmp_value = zen_db_input($product->fields['products_height']);
            $products_height = (!zen_not_null($tmp_value) || $tmp_value=='' || $tmp_value == 0) ? 0 : $tmp_value;

c) around line 62 ($db->Execute("insert into " . TABLE_PRODUCTS . "....) ADD:

Code:

, products_height

d) around line 79 (continuation of last statement) ADD

Code:

                                  '" . $products_height . "',

I'm pretty sure these last two need to have the fields in the correct order that they appear in the table.

OK! Now I can enter the new properties and they actually get entered into the database!!!

**webego** · 10 Sep 2009, 01:02 PM

Hi shen,

I have made a modified version of the steps from this thread here which has worked for many. Note I have also added a bit here to ensure the extra product data is deleted when deleting a product.

G

**KismetDesign** · 30 Sep 2009, 03:52 AM

I installed a new text field and got it right the first time. Woo Hoo!

One trivial question... on the admin side, when I fill out the information, my new text field shows up at the bottom of my product listing page. Where do I need to go to move it up, right under my title?

I already moved it up on my product info page that people can see, but on the admin side it would be nice to have the subtitle field I just created go directly under the title field.

Thanks!

KD

**janekbar5** · 30 Sep 2009, 10:37 AM

Hi
Look at the 1 page of this post it will be in
edit 'collect_info.php' (in /admin/includes/modules/product/),
edit 'preview_info.php' (in /admin/includes/modules/product/) or
edit 'update_product.php' (in /admin/includes/modules/)
don't remember now.

**KismetDesign** · 6 Oct 2009, 08:22 PM

It doesn't say specifically which file controls where the text field appears on the admin side when filling out product details. With 3 different files and 5-6 different edits, I don't want to mess this up before I start. Anyone else have an idea of which file it would be, and where I would look to re-order the fields?

Thanks,

KD