Product description

[shahin]

Hi,

 

I would like to show product description at product listing page. But I don't want to modify my database structure.

 

I have seen some contributions at Oscommerce contribution section. But all of those contributions involved some kind of modifycation of database structure.

 

Could anybody suggest me how can I add a description at product listing page without modifying the database structure.

 

Thanks in advance.

 

Kind Regards,

Shahin

[dave111]

Whats the problem with modifying the database?

 

But anyways, I dont think i've ever found a working contribution that does this 100%.

If you didnt mind adding to the DB you could add another product field, which would allow you specify the short description which would appear in the product listing.

 

But maybe someone else has found a work contribution for it.

[shahin]

Whats the problem with modifying the database?

 

But anyways, I dont think i've ever found a working contribution that does this 100%.

If you didnt mind adding to the DB you could add another product field, which would allow you specify the short description which would appear in the product listing.

 

But maybe someone else has found a work contribution for it.

<{POST_SNAPBACK}>

 

 

Hi,

 

Thank you very much for your reply.

 

Description of my products is very short >> That's why I am not thinking any shorter description.

 

I am sure that somebody from this great forum can assist me to add the description of products at product listing page .

[sarah1980]

Hi,

 

Thank you very much for your reply.

 

Description of my products is very short >> That's why I am not thinking any shorter description.

 

I am sure that somebody from this great forum can assist me to add the description of products  at product listing page .

<{POST_SNAPBACK}>

There is a contribution called "Short description" which will do what you want.

 

Sarah

[dahui]

There is a contribution called "Short description" which will do what you want.

 

Sarah

<{POST_SNAPBACK}>

 

you could build an array like in products_new.php e.g.

 

  $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, pd.products_description, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name";

 

and place it where you like

 

if the desription is too long truncate it by characters

 

dahui

[Wendy James]

One of the short description contributions pulls your information directly from the database for the description you have already done and it allows you to choose how many letters you want to use. You could set it for a high number so your whole description shows up. Just have to do a search to find the right one.

[shahin]

One of the short description contributions pulls your information directly from the database for the description you have already done and it allows you to choose how many letters you want to use. You could set it for a high number so your whole description shows up. Just have to do a search to find the right one.

<{POST_SNAPBACK}>

 

 

Dear Wendy,

 

Thank you very much for your suggestion.

Could you please tell me the specific name of the contribution !!

 

Kind Regards,

Shahin