Numinix Product Fields Version: 1.3.0

[bislewl]

Matt-

What version mySQL are you running?

[aestheticdesign]

Matt-

What version mySQL are you running?

Server version: 5.5.38-35.2
MySQL client version: 5.0.96

[bislewl]

Server version: 5.5.38-35.2
MySQL client version: 5.0.96

You really should be on version MySQL 5.5 or better yet 5.6 for PCI compliance.

[andis02]

I use the Numinix MSRP field. But what does the "Condition" mean, what should I enter? I take a image for the field. How do I add the field in the template file? just echo TEXT_PRODUCTS_MSRP in the template file??

[bislewl]

I use the Numinix MSRP field. But what does the "Condition" mean, what should I enter? I take a image for the field. How do I add the field in the template file? just echo TEXT_PRODUCTS_MSRP in the template file??

Typically I add a file (perhaps should be added to the module)
in the catalog/includes/functions/extra_functions/npf_fields.php with this content

<?php  if (!function_exists('npf_field_value')) {
    function npf_field_value($id, $field){
        global $db;
        $product = $db->Execute("SELECT * FROM ".TABLE_PRODUCTS." WHERE products_id=".(int)$id." LIMIT 1");
            $value = $product->fields[$field];
            return $value;
    }
 }

Then in the template, I will add this where I want the value (note: replace products_msrp with your field)
$products_id should be the products_id for that product.

echo npf_field_value($product_id,'products_msrp'); 

[andis02]

Thank you, Sir. It's working.
Do you know the "Condition" is for what?

[bislewl]

Thank you, Sir. It's working.
Do you know the "Condition" is for what?

Condition is a field that is automatically installed with Numinix Product Fields. Some don't use it, others may put New/Used/Rebuilt etc in there.

[ts232]

I am having the same problem at Step 4, when trying to add the Description 2 field. The error message is below. I am running MySQL 5.1, and upgrading to 5.5 or 5.6 is not a viable option for me. I noticed that when I look at the database, is appears the the first line in the sqlupdate for adding the Description2 field is also not working ("ALTER TABLE products_description ADD products_description2 text NULL default NULL;"). There is no column for products_description2.

Any ideas for what could be causing the problem? Thanks!

[09-Nov-2014 08:45:26] PHP Fatal error:  1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO zen_product_type_layout (configuration_id, configuration_title, conf' at line 3 :: ALTER TABLE products_description ADD products_description2 text NULL default NULL;

INSERT INTO zen_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 Product Description 2', 'SHOW_PRODUCT_INFO_DESCRIPTION2', '0', 'Show the second description on the product info page?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),'); ==> (as called by) /home/hbzenftp/hardbrakes.com/hbadmin/includes/functions/extra_functions/npf_functions.php on line 70 <== in /home/hbzenftp/hardbrakes.com/includes/classes/db/mysql/query_factory.php on line 155

[bislewl]

What version of ZenCart are you running?

[CSGODeimos]

What version of ZenCart are you running?

I know this is an old thread and I'm bumping it but..

I contacted Numinix support because I couldn't click add for UPC under catalog / numinix. They wrote out a few simple instructions for me to follow so I could do it manually.

I followed them step by step, the product fields show up but when I enter the UPC number and update it. It's doesn't show on the product page on the site nor in the source code.

Not sure what to do o_o

This is needed for Google Shopping too.