Add Field to Product Record

[jonsweaver]

My client would like 3 custom fields added to the Product Record of his Vitamin Supplements. Manufacturer, Size, Strength.

I know how to add to the mysql table in phpmyadmin.
I have changed product_thumbnail.tpl.php & product_detail.tpl.php.

But I can't find how to change the Control Panel Product Record.

Also, will these db, form, template customizations be wiped away by upgrades?
Or cause conflicts with upgrades?

I'd also like to say that v3.1.3 is well done. I just upgraded from a highly customized v1.4.0 and I appreciate how well-organized & standards-based the new version is. Thank you.

[Jamie]

My client would like 3 custom fields added to the Product Record of his Vitamin Supplements. Manufacturer, Size, Strength.

I know how to add to the mysql table in phpmyadmin.
I have changed product_thumbnail.tpl.php & product_detail.tpl.php.

But I can't find how to change the Control Panel Product Record.

We don't provide support or have a feature to alter the control panel. You can do this, but you may have mixed results.

To add 3 fields to the "Details" section of the product record form, you'd need to run a query like this:

INSERT INTO `REL_Field__Field_Set` (`record_number` ,`Table_Name` ,`Field_Set_rn` ,`Field_Name` ,`Position`) VALUES ('990000', 'Products', '22', 'Column_Name_1', '50');
INSERT INTO `REL_Field__Field_Set` (`record_number` ,`Table_Name` ,`Field_Set_rn` ,`Field_Name` ,`Position`) VALUES ('990001', 'Products', '22', 'Column_Name_2', '51');
INSERT INTO `REL_Field__Field_Set` (`record_number` ,`Table_Name` ,`Field_Set_rn` ,`Field_Name` ,`Position`) VALUES ('990002', 'Products', '22', 'Column_Name_3', '52');

Also, will these db, form, template customizations be wiped away by upgrades? Or cause conflicts with upgrades?

Possibly. Any change like this is unsupported and consequently could cause problems.

I'd also like to say that v3.1.3 is well done. I just upgraded from a highly customized v1.4.0 and I appreciate how well-organized & standards-based the new version is. Thank you.

Thanks! Glad you like it.

[jonsweaver]

Good to know, I will figure out a work around that the system supports.
Thank you.
Best JON