I did first post this againnst the template I was using http://www.zen-cart.com/showthread.p...98#post1258298 #269

Found this plugin from Numinix, product fields. Seems to have what I am looking for but having problems with the install.

After a file merge uploaded all files to the relevant locations. install.sql scripted on install is giving back 'WARNING: An Error occurred, please refresh the page and try again.'

Going to the product screen and doing an update I am getting the same error message.

I have tried to do an uninstall of the script message coming back saying 'ERROR: Cannot DROP column products_sh_eu because it does not exist.' etc.

Log files

[10-Sep-2014 16:25:50] PHP Fatal error: 1054:Unknown column 'products_barcode' in 'field list' :: update eshop_products set products_quantity = '1000', products_type = '1', products_model = 'HD-FAM901', products_price = '2.4917', products_date_available = null, products_weight = '0', products_status = '1', products_virtual = '0', products_tax_class_id = '1', manufacturers_id = '0', products_quantity_order_min = '1', products_quantity_order_units = '1', products_priced_by_attribute = '0', product_is_free = '0', product_is_call = '0', products_quantity_mixed = '1', product_is_always_free_shipping = '0', products_qty_box_status = '1', products_quantity_order_max = '0', products_sort_order = '0', products_discount_type = '0', products_discount_type_from = '0', products_price_sorter = '2.4917', products_barcode = '', products_condition = '', products_image = 'christmas/FAMX901.jpg', products_last_modified = now(), master_categories_id = '75' where products_id = '182' in /homepages/20/d503465712/htdocs/shops/ZenCart/eshop/includes/classes/db/mysql/query_factory.php on line 120
[10-Sep-2014 16:24:02] PHP Fatal error: 1062: Duplicate entry 'SHOW_PRODUCT_INFO_CONDITION' for key 'unq_config_key_zen' :: INSERT INTO eshop_product_type_layout (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Show Condition', 'SHOW_PRODUCT_INFO_CONDITION', '0', 'Show product condition on product info page (requires Numinix Product Fields)?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),'); in /homepages/20/d503465712/htdocs/shops/ZenCart/eshop/includes/classes/db/mysql/query_factory.php on line 120
install.sql

ALTER TABLE products ADD products_condition varchar(32) NULL default NULL;

INSERT INTO product_type_layout (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
(NULL, 'Show Condition', 'SHOW_PRODUCT_INFO_CONDITION', '0', 'Show product condition on product info page (requires Numinix Product Fields)?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),');
extra info

Template; Westminster New