Numinix Product Fields Version: 1.3.0

I have upgraded ZC to 1.5.1 and also Numinix Product Fields to 1.3.1

On the collect info page, I can see the appropriate fields (like dimensions, diameter, condition etc), but when I add data to these fields, it does not get saved.
The next time I open the same product again, these fields are blank.
The preview file or update product file do not give any errors.
Only the data does not get saved.
Can someone help identify the problem.

Hi

On the module download page the section for, optional fields:, says

UPC/ISBN - adds fields for storing a product's UPC and/or ISBN

My experience using this module shows me that only one option can be used at a time per product. IE: add isbn or upc but not both. What happens is if both isbn and upc fields are filled then isbn takes precedence and is the one included in the google feed and upc gets left out. Is anyone else able to get both isbn and upc included in their feed?

I should add that I am using version 1.1.0. It is working fine for my needs otherwise. I am asking because if version 1.3.1 is able to include both isbn and upc fields per product in the merchant center feed then I would upgrade.

installed on zen cart 1.5.0

buildingblocks:

Hi

On the module download page the section for, optional fields:, says

UPC/ISBN - adds fields for storing a product's UPC and/or ISBN

My experience using this module shows me that only one option can be used at a time per product. IE: add isbn or upc but not both. What happens is if both isbn and upc fields are filled then isbn takes precedence and is the one included in the google feed and upc gets left out. Is anyone else able to get both isbn and upc included in their feed?

I should add that I am using version 1.1.0. It is working fine for my needs otherwise. I am asking because if version 1.3.1 is able to include both isbn and upc fields per product in the merchant center feed then I would upgrade.

installed on zen cart 1.5.0

This is supported in version 3.1.3 of the Google Product Search Feeder plugin available on Numinix.com. You can achieve this easily in the GMCF plugin by changing the **elseif **statements into **if **statements.

Thanks for responding.

Should elseif be changed to **if ** just where there are mentions of isbn, ean, upc or for all areas that contain elseif?

numinix:

This is supported in version 3.1.3 of the Google Product Search Feeder plugin available on Numinix.com. You can achieve this easily in the GMCF plugin by changing the **elseif **statements into **if **statements.

buildingblocks:

Thanks for responding.

Should elseif be changed to **if ** just where there are mentions of isbn, ean, upc or for all areas that contain elseif?

Only the section of the code that is determining if the UPC, ISBN, or EAN should be included.

ZC version 1.5.1 - using 2 fields with this mod, the online only and date added. My host has upgraded the php to 5.4.26 Previously I was using 5.2.17. Ever since the change, I recognized that my logs folder was extremely huge, all with the same warning as below:

[16-Apr-2014 17:50:10 America/Chicago] PHP Warning:  Creating default object from empty value in /home/*****/public_html/******/**admin folder **/includes/npf_includes/npf_sql_array/date_added.php on line 2

After testing it out, this warming appears everytime a product is updated. The date added field can be left unmodified while other parts changed and the warning still appears. This does not affect the frontend or backend functionality. But it does make it hard to go through all the logs to find which ones do need attention.

Any insight would help.

yaritai:

ZC version 1.5.1 - using 2 fields with this mod, the online only and date added. My host has upgraded the php to 5.4.26 Previously I was using 5.2.17. Ever since the change, I recognized that my logs folder was extremely huge, all with the same warning as below:

[16-Apr-2014 17:50:10 America/Chicago] PHP Warning: Creating default object from empty value in /home//public_html/*/**admin folder **/includes/npf_includes/npf_sql_array/date_added.php on line 2

> 
> After testing it out, this warming appears everytime a product is updated.  The date added field can be left unmodified while other parts changed and the warning still appears.  This does not affect the frontend or backend functionality.  But it does make it hard to go through all the logs to find which ones do need attention.
> 
> Any insight would help.
This mod hasn't been tested with 5.4 and probably won't be until it's updated to work with ZC 1.5.2-1.6.0.  PHP 5.3 is recommended for ZC 1.5.1: <https://www.zen-cart.com/wiki/index.php/Installation_-_Requirements>

raunharman:

I have upgraded ZC to 1.5.1 and also Numinix Product Fields to 1.3.1

On the collect info page, I can see the appropriate fields (like dimensions, diameter, condition etc), but when I add data to these fields, it does not get saved.
The next time I open the same product again, these fields are blank.
The preview file or update product file do not give any errors.
Only the data does not get saved.
Can someone help identify the problem.

I did not see a reply to this question. I am having the same problem with the entries for UPC and Condition not saving. Any suggestions?

The product-type that I'm having trouble saving is Music. It appears that product type General saves the field data correctly. There must be something I have to edit, but I don't know where to start. Thanks.

chain_man:

The product-type that I'm having trouble saving is Music. It appears that product type General saves the field data correctly. There must be something I have to edit, but I don't know where to start. Thanks.

Its the update product file that saves it to the database. If I remember correctly, the music type has its OWN update product file. I think its contained in the music folder. While the example in this mod only shows how to do it for the product types which I think is 3 of them. So you will have to compare the update file for product and use it for the music update file.

This is what I assume is happening as you most likely did not edit the separate file. Please have a backup of your site and database before doing this. I recommend having a test site so your live store is not affected during your merges.

Thanks for the suggestions!

It appears that the Music product update file already has the NPF changes added. Any other ideas?

chain_man:

It appears that the Music product update file already has the NPF changes added. Any other ideas?

For the update file, I assume you did the merges yourself? You cannot take the update file in the mod and place it in the music folder. The music folder has its own unique update file.

Also, once you get that update file resolved, and IF you wanted to show these new fields on the product listing, you will have to change the install sqls to reference the music product type. You will want to change it from '1' to '2'. '2' being the music product type id for music products.

I found the answer to my problem. The file admin/includes/modules/product_music/collect_info.php was altered during the installation of the plugin. But one piece was missing:

about Line 67:

                           ```
   p.products_discount_type, p.products_discount_type_from,
                                  p.products_price_sorter, p.master_categories_id
                          from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd,
                               " . TABLE_PRODUCT_MUSIC_EXTRA . " pe  

 
Should be:

                               ```
       p.products_discount_type, p.products_discount_type_from,
                                      p.products_price_sorter, p.master_categories_id" . $npf_fields . "
                              from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd,
                                   " . TABLE_PRODUCT_MUSIC_EXTRA . " pe  

This segment was copied from admin/includes/modules/product/collect_info.php.

What was really happening was that the field changes were being captured in the database, but were not being displayed back to the product editing page.

I have started another thread when I could not find this. The links to it is http://www.zen-cart.com/showthread.php?213334-Westminster-New&p=1258298#post1258298

Sorry for the side link :(

Sorry wrong link http://www.zen-cart.com/showthread.php?214556-numinix-product-fields&p=1258311#post1258311

I wanted to install Numinix Shipping Boxes Manager and so I tried installing Numinix Product Fields as the first step.

Using ZC 1.5.1, Product Fields 2.0, PHP 5.2.17

I was at step 4 and tried to add the Dimensions field.

I get "WARNING: An Error occurred, please refresh the page and try again."

This is in the log file:

[26-Sep-2014 17:12:47 America/Chicago] 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 'ALTER TABLE zc_products ADD products_dim_type ENUM('in','cm') NOT NULL default '' at line 3 :: #MODIFY THE DEFAULT ACCORDINGLY FOR THE NEXT 2 ROWS
ALTER TABLE zc_products ADD products_weight_type ENUM('lbs','kgs') NOT NULL default 'lbs' after products_weight;
ALTER TABLE zc_products ADD products_dim_type ENUM('in','cm') NOT NULL default 'in' after products_weight_type;

ALTER TABLE zc_products ADD products_length DECIMAL(6,2) NULL default NULL after products_dim_type;
ALTER TABLE zc_products ADD products_width DECIMAL(6,2) NULL default NULL after products_length;
ALTER TABLE zc_products ADD products_height DECIMAL(6,2) NULL default NULL after products_width;
ALTER TABLE zc_products ADD products_ready_to_ship ENUM('0','1') NOT NULL default '1' after products_height;
ALTER TABLE zc_products ADD products_actual_weight varchar(32) NULL default NULL after products_weight;
ALTER TABLE zc_products ADD products_diameter varchar(32) NULL default NULL;

INSERT INTO zc_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 Dimensions', 'SHOW_PRODUCT_INFO_DIMENSIONS', '0', 'Show product dimensions on product info page (requires Numinix Product Fields)?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array('1', '0'),'),
(NULL, 'Show Diameter', 'SHOW_PRODUCT_INFO_DIAMETER', '0', 'Show product diameter on product info page (requires Numinix Product Fields)?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array('1', '0'),'),
(NULL, 'Show Conversions', 'SHOW_PRODUCT_INFO_CONVERSIONS', '0', 'Show weight and dimension conversions on product info page (requires Numinix Product Fields)?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array('1', '0'),'),
(NULL, 'Show Smaller Units', 'SHOW_PRODUCT_INFO_SMALLER_UNITS', '0', 'Show weight and dimensions as g/oz? (requires Numinix Product Fields)?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array('1', '0'),'),
(NULL, 'Show Actual Weight', 'SHOW_PRODUCT_INFO_ACTUAL_WEIGHT', '0', 'Show zc_products actual weight on product info page (requires Numinix Product Fields)?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array('1', '0'),'); in /home/bandera/public_html/zc/includes/classes/db/mysql/query_factory.php on line 120

I'm not sure what I'm missing in the installation. When I look at the database, it looks like the changes have been made. I can see the fields that were added.

Matt-

What version mySQL are you running?

bislewl:

Matt-

What version mySQL are you running?

Server version: 5.5.38-35.2
MySQL client version: 5.0.96

aestheticdesign:

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.