add new field to products_table

[webhie]

I want to add new fields to products_table.

this includes adding new column in admin page

and where should i add the insert query

[notrub225]

that question has a really long answer.

[Ajeh]

The easiest way to figure out where you have to make a change is to pick a field similar to what you are trying to add ...

Say you wanted something like products_model

You would then do a search in the Tools ... Developer's Tool Kit ... and in the bottom input box type:
products_model

Pick Catalog/Admin from the dropdown and click search ...

Now this will include more places than you may need, but it will show you all files that use this field name ...

NOTE: a field like products_model may later be referred to as model or $model or $products_model etc.

It really depends on what all you are trying to do and where you need to display/add/edit this field ...

[webhie]

The easiest way to figure out where you have to make a change is to pick a field similar to what you are trying to add ...

Say you wanted something like products_model

You would then do a search in the Tools ... Developer's Tool Kit ... and in the bottom input box type:
products_model

Pick Catalog/Admin from the dropdown and click search ...

Now this will include more places than you may need, but it will show you all files that use this field name ...

NOTE: a field like products_model may later be referred to as model or $model or $products_model etc.

It really depends on what all you are trying to do and where you need to display/add/edit this field ...

Thank you Ajeh,notrub,

I would like to add an extra image for my products, I identified where the form has image input and replicated changed its name at all pages as image2 and included an extra field to database.

If i select the directory to store the extra image.it goes to the database but the filename is not transferred to the database nor the file gets uploaded..

Can you help

[Ajeh]

Zen Cart already has built in unlimited additional images ...

Do a search on:

calico cat
images/medium
additional images

You should find a 10001 threads on how to utilize them ...

[webhie]

Hi linda,

Can we do that from zen admin without going for ftp,

[Ajeh]

Medium, Large and Additional Images are added via FTP ...

[webhie]

Can pl you tell me which area of code responsible for first image upload and entry indirectory

[Ajeh]

That is more or less a combination of the /admin/modules files ...

[webhie]

Thank u linda,

I found that collect_info is responsible for outer form which i changed and i need to know what should be changed to upload the image name to database and where it should be modified for an upload