[general38]

Hi everyone, my first post so please forgive me if this is covered elsewhere.

I am customizing XCART to sell courses. However I need to add extra fields to the products table and these fields need to show up in the add product/modify and product details pages. Also i need to be able to search on these fields.

So far i have added a single field in the table back end using mysqlphp admin. I also have had success in adding the field label in the languages table. Also by manually entering the data through the mysqlphp admin i was able to display the information in the modified template.

I also was able to include the field in the product add page and manged to modify the related php script to allow for data addition into the mysql database.

I cannot however find the script that loads the data initially into the provider product details form. The extra field displays, it allows entry, it updates the database and displays on the modified customer product details page.

Could anyone please point me to the script that fills the fields upon initial page loading for the provider product details page? Also I am only using a basic editor so what debugging and editing tools do you recommend as I am only beginning to get my head around xcart.

Lastly I need to include this field as search criteria. Any pointers to help with the above would be greatly appreciated.