Adding Extra Fields to Product Table

[jsteele12]

Hello everyone,

 

I've seen the contribution to add extra fields to an "additional" table, but I'd like to put them into the products table directly.

 

As I'm sure I'm not the first to go through this, I was wondering if anyone has a steps needed write-up anywhere. I've looked at the knowledge base, but no luck there.

 

I have about 14 new SELECT fields that I need to add to the admin side (admin/categories.php?), that I will probably store these option values in another table, like the following:

 

class = 'Albas', 'Bourbons', 'Chinas', ...

avail = 'In Stock', 'Out of Stock', 'Jan', 'Feb', ...

bloom_size = '.5', '1', '1.5', '2', ...

color = 'Apricot', 'Blush', 'Gold', ...

growth = 'Arching', 'Spreading', 'Upright', ...

 

And of course I need to display the added fields values in the cart display (product_info.php?)

 

Any pointers to generalizing this type of a solution would be great. I'd probably like to eventually make this a contribution with a tie into Easy Populate.

 

Thanks in advance,

John