X-Cart forums

[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.

[cflsystems]

Why not just use the extra fields that come by default with xcart?

[general38]

I cant use the default extra fields because they only are applicable to each individual provider ( i have the pro version). I require the field changes to be permanent and global for all providers. If there was a way to make some of the default extra fields global to all providers I would be a very happy chappy.

[general38]

Okay, i found that extra fields are common to all root providers so all I have to do is make providers members of root and they all have access to extra fields. I apologize for my stupidity. I did not realize this was possible. However some of these fields i wish to contain date information and i would like to attach a date picker to the extra fields. I will raise this in a different thread however. Thanks anyway.