Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Adding a custom field as a column in product listing


free hugs

Recommended Posts

Here is my problem...

 

We sell power supplies that require fields like "output voltage, input voltage, wattage" to be shown in the product listing. I modified our products table to include the fields products_vout, products_vin, and products_wattage. I can display this on our product details page very easily...but I need to add these items as columns in the product listing (next to the model name, image, buy now, etc.). I've been working on this for 2 days now without much progress. I added the fields to the mysql queries (/catalog/index.php) and added the new field in the arrays (catalog/index.php, catalog/includes/modules/product_listing.php) and defined the TABLE_HEADER_VOUT information (/includes/languages/english/index.php).

 

Unfortunately, the changes I've made were somewhat stabs in the dark. I have a better understanding than when I began...but I don't understand where it is defined whether or not a column is to be included in the product listing.

 

If anyone has ANY insight into what I am doing wrong / a better approach, please help me.

 

Thank you,

 

free hugs

Link to comment
Share on other sites

I found what I was missing...just one little step

 

In the "configuration" table in the database, there has to be a row that corresponds to each product_listing column.

 

It now displays, and can also be sorted by that field :-)

Link to comment
Share on other sites

  • 1 month later...
I found what I was missing...just one little step

 

In the "configuration" table in the database, there has to be a row that corresponds to each product_listing column.

 

It now displays, and can also be sorted by that field :-)

 

I also need to add custom fields to my product(s). I was wondering if you could give me a few hints on how to do this or let me know where you found how to do this.

 

Thanks.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...