add new field to products_table

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

that question has a really long answer.

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

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

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

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 ... :smile:

Hi linda,

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

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

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

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

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

You have several peices ...

collect_info.php
new_product_preview.php
preview_info.php
update_product.php

Then be sure that you keep in mind the Product Types ...

Thank you linda,

I altered those contents but still its not taking the name of the file into the database i dunno why can you help

What exactly are you trying to do here?

You could try using the Image Handler contribution which expands image support and allows you greater control over images directly from the admin area, without using FTP.
You can control small/medium/large for main and additional images.

I would like to add a different image that should show up only on the popup, So i like to add extra image while uploading product details and want that image to show when popup comes