Extra Fields oin category listing page?

[jagall]

The 3 I changed were

/includes/languages/english/YOUR_TEMPLATE/index.php
/includes/modules/pages/index/main_template_vars.php
/includes/modules/YOUR_TEMPLATE/product_listing.php

The only difference I see is that you did not use an override file for your product_listing.php.

thank you for this, I entered it manually and it shows in admin but still not on the product listing ahhhh

index.php

define('TABLE_HEADING_COUNT', 'Product Count');

main_template_vars

// create column list
$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
'PRODUCT_LIST_COUNT' => PRODUCT_LIST_COUNT,
'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE);

case 'PRODUCT_LIST_COUNT':
$select_column_list .= 'p.products_count, ';
break;

Product listing code:

case 'PRODUCT_LIST_COUNT':
$lc_text = TABLE_HEADING_COUNT;
$lc_align = 'left';
$zc_col_count_description++;
break;

case 'PRODUCT_LIST_COUNT':
$lc_align = 'left';
$lc_text = '  '.$listing->fields['products_count'];
break;

Am I missing something here, beginning to think it is the way my fields are set up? any ideas appreciated v much.

[idc1]

thank you for this, I entered it manually and it shows in admin but still not on the product listing ahhhh

Am I missing something here, beginning to think it is the way my fields are set up? any ideas appreciated v much.

Do you see the column header or anything? What table did you put your "COUNT" data in?

I've tried to change the settings in the admin>config but that does not solve my problem. Evidently there is a bit of code that has to be included in one of the files so that the additional fields can be sorted.

When I first visit one of my product listing pages, items are sorted by Item Name. If I then try to sort by my new field (in ascending or descending order), it does not sort by that column. Rather it sorts ascending by model.

Any idea what is missing?

Anyone with some insight to my dilemma quoted above?

[jagall]

well the extra field is in the products table i.e.products_count.
In the product listing, it asks Do you want to display product listing? but nothing is showing up at all!!!

[jagall]

Hi just noticed that when i added a new product via the admin the extra field shows up the product details e.g.
Product Code: NERL3026
Manufactured by: Nestle
Count:36
Quantity Per Box: 36
R.R.P.: 0.65

I already have this displaying as quantity per box. also it doesn't not show the tabbed product interface either.

[jagall]

Hi just noticed that when i added a new product via the admin the extra field shows up the product details e.g.
Product Code: NERL3026
Manufactured by: Nestle
Count:36
Quantity Per Box: 36
R.R.P.: 0.65

I already have this displaying as quantity per box. also it doesn't not show the tabbed product interface either.

Got rid of the extra count field but have given up on getting it to display at this stage, may come back to this later tho. thanks

[stsung]

idc1: well, I actually created a search by keyword to sort by my extra fields. but I encountered a problem as the javascript removing the initial keyword does not remove it ... and thus the search does not find anything. (it's a filter actually)

for that both headers need to be edited.

[idc1]

idc1: well, I actually created a search by keyword to sort by my extra fields. but I encountered a problem as the javascript removing the initial keyword does not remove it ... and thus the search does not find anything. (it's a filter actually)

for that both headers need to be edited.

That sounds more complicated than it seems like it should be. It may be my ignorance to php right now but I don't see why it doesn't just function like Product_List_Name, Product_List_Model, Product_List_Manufacturer, Product_List_Price. I may not be choosing the correct terms but is the additional field just not being captured in an array that allows it to be sorted like the rest?

For example in the product_listing.php there is this snippit of code:
if ( ($column_list[$col] != 'PRODUCT_LIST_IMAGE') ) {
$lc_text = zen_create_sort_heading($_GET['sort'], $col+1, $lc_text);
}


$list_box_contents[0][$col] = array('align' => $lc_align,
'params' => 'class="productListing-heading"',
'text' => $lc_text );

Is the additonal field not captured in the above snippit?

[idc1]

Stsung, to do it your way are you say header.php files need to be updated? Could you clarify which ones if this is the case. There are so many it's confusing. Or do you just mean the header portion of code in the product_listing.php

Thanks

[games4gamers]

2. in /main_template_vars.php find the part that adds a column and add it

  'TABLE_HEADING_EDITION' => TABLE_HEADING_EDITION, 

Confused about this part. Where is this file located? \includes\modules\pages\index? \includes\modules\pages\product_info?

Neither have any other references to table headings which your comment seems to imply that there should be others in the file.

Some clarification about more specifically where this goes would be appreciated. Thanks.

[idc1]

Confused about this part. Where is this file located? \includes\modules\pages\index? \includes\modules\pages\product_info?

Neither have any other references to table headings which your comment seems to imply that there should be others in the file.

Some clarification about more specifically where this goes would be appreciated. Thanks.

I believe the below may answer your question. See the second location that is listed

The 3 I changed were

/includes/languages/english/YOUR_TEMPLATE/index.php
/includes/modules/pages/index/main_template_vars.php
/includes/modules/YOUR_TEMPLATE/product_listing.php

The only difference I see is that you did not use an override file for your product_listing.php.