How to Add Custom Product Fields in Zencart

Problem: How to add a product custom field named length.

This to consider (modifications in):
1.) database
2.) scripts
-----------------------------------
1.) Database - a custom column should be add to the products table.
Execute this line (for column name products_length):
ALTER TABLE `products` ADD `products_length` INT NOT NULL AFTER `products_status`

2.) Scripts - we have to modify at least 4 files
a.) admin/includes/modules/products/collect_info.php - we need to query the field's value:

Find this line:

if (isset($_GET['pID']) && empty($_POST)) {
$product = $db->Execute("select pd.products_name, pd.products_description, pd.products_url,

//And add the following line:
p.products_length, //(just look at the pattern)


*we need to show the fields in the product page, so add this line (maybe under Product Qty Min/Unit Mix: or where ever you want):

<tr>
<td class="main"><?php echo TEXT_PRODUCTS_LENGTH; ?></td>
<td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . ' ' . zen_draw_input_field('products_length', ($pInfo->products_length == 0 ? 0 : $pInfo->products_length)); ?></td>
</tr>

b.) admin/includes/languages/english/product.php - this is where we will define the label for the field, just add this line:


define('TEXT_PRODUCTS_LENGTH','Length:');


c.) admin/includes/modules/update_product.php - we need to update the update statement.
Find this line:


$sql_data_array = array('products_quantity' => $products_quantity,


And insert this line:

'products_length' => zen_db_prepare_input($_POST['products_length']),


If you are not familiar with how a query works, just look at the pattern. Easy right?

Well, I guess that's it we have a custom length field. This field can be shown in the frontend but we have to modify the respective file.