My first ZenCart tip
update_product.php
Again, search for “description”. Change the following sections as you find them:
$sql_data_array = array('products_name' => zen_db_prepare_input($_POST['products_name'][$language_id]),
‘products_description’ => zen_db_prepare_input($_POST['products_description'][$language_id]),
‘products_url’ => zen_db_prepare_input($_POST['products_url'][$language_id]));
gets changed to:
// YOUR NAME HERE
$sql_data_array = array('products_name' => zen_db_prepare_input($_POST['products_name'][$language_id]),
‘products_description’ => zen_db_prepare_input($_POST['products_description'][$language_id]),
‘products_description2′ => zen_db_prepare_input($_POST['products_description2'][$language_id]),
‘products_url’ => zen_db_prepare_input($_POST['products_url'][$language_id]));
Save the file as previously outlined.



I can’t begin to tell you how wonderful this is. I’ve searched the Zen site over and over and nothing could touch what I needed. THANKS…. BUT…. The admin collect_info works, the preview_info works, but it’s not writing the input to the database. I opend php MyAdmin and verified the fields are correct. Also I verified the new records are writing to the database but the new fileds are blank. Additionally Both New records and Updated records are not writing to the new fields, AND I’m not getting any error messages. If I could beg your help, Can you point me to areas to look for possible mistakes or errors? I’m so close I can smell it…
Thanks a MILLION…
Spoken on March 6th, 2008 at 1:05 pm