modify edit product page extra field

I am kind of new to Zen Cart and I came up to a problem with a particular search engine I am collaborating. I searched at the plugins area but didn't find any useful for me tool.
I need to add at "edit product page" a new field probably a dropdown or a listbox from where I will determine the availability status of the product such as "in stock"/"available at 1-3 days"/"available at 4-7 days"....
Later this field will have to be shown at the main products page but that's the easy part. First of all can anyone tell me if this is possible? I would be glad if someone can walk me through it.
Actually i think it's a very good idea to be added at later versions of zencart.

You can already set ZC to show the quantity in stock or, if it's not in stock but will be later you can set a date it will be available and that shows up in the description too. You pick the date from the pull-down calendar and it says "This product will be in stock on Thursday 25 October, 2012."

joejoejoe:

You can already set ZC to show the quantity in stock or, if it's not in stock but will be later you can set a date it will be available and that shows up in the description too. You pick the date from the pull-down calendar and it says "This product will be in stock on Thursday 25 October, 2012."

Hi, thank for you response
Yes I know that but I want a field that specific determines with the exact strings I mentioned that I could export this through googlefroogle xml feed in a field named availability and reads the current availability status of the product. Not all of my 5000 products are in stock at the warehouse. This mod will let the customers know that the product will be available to ship after X days after the order be placed.

I suggest you download some mods that involve db settings to see how they work. There is at least one that adds new product fields, which should show you an example of the SQL required.

gjh42:

I suggest you download some mods that involve db settings to see how they work. There is at least one that adds new product fields, which should show you an example of the SQL required.

Hi,
That's a nice idea and a good starting point. I'll check it out when I get back home..