EasyPopulate 4.0 Support Thread

[mc12345678]

Sorry to see that you are having difficulty. From the above data though, the item with model# A123456 is not a new item but an update of an existing item indicating that there already exists an item with that model#.

If that is so, then when going back to look at the "desired" new item, what is happening is that another has been updated.

To confirm this situation, if you export the complete product list, you can then sort on model # and look for duplicates. Starting specifically with that model#.

Otherwise it may help to identify the process of which report method is chosen to export the file, then what filename the changes are saved as for upload. More questions may follow, but that is a start.

[Bruce1952]

mc12345678,

The original file did add as a new product and because the fields were not filled out I then attempted to add more information to see if the fields would then update, which did not happen. I have tried to update several times and still nothing happens.

I have checked for duplicates and do not have any using the search option in the admin/categories.



I deleted the product and installed again and this is the message that I received after re-installing:

UPDATED! - Model: 787-01951 | 1 | Product im | Genuine Ro | | | | | | 2.5 | A16801, 78 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | 0 | 0 | | | 0 | 0 | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-16 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
UPDATED! - Model: A318228 | 1 | Product im | Genuine Ro | | | | | | 0.91 | A318228 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | 0 | 0 | | | 0 | 0 | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
No model field in record. This line was not imported1 | Product im | Genuine Ro | | | | | | 0 | | 0 | | | | 0 | 0 | | none | | | 0 | | | | | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | 0001-01-01 | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
NEW PRODUCT! - Model: A123456 | 1 | Product im | Genuine Ro | | | | | | 1 | A123456 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | 0 | 0 | | | 0.5 | 0 | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |

Updated records: 156
New Imported records: 1
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 15648440
Memory Peak: 16318192
Execution Time: 2.96993088722 seconds.

I have also noted that it is not loading user defined product fields which are: products_sku,products_price_carrot,products_length,products_height,products_widt h,products_carrot,threshold_set,products_condition,products_EHF,additional_skus, additional_skus_only,discontinue,products_pdf_attachment,products_vendor_code,pr oducts_vendor_price,availability_id

I am assuming that It has to do with the user defined product fields.

[mc12345678]

mc12345678,

The original file did add as a new product and because the fields were not filled out I then attempted to add more information to see if the fields would then update, which did not happen. I have tried to update several times and still nothing happens.

I have checked for duplicates and do not have any using the search option in the admin/categories.



I deleted the product and installed again and this is the message that I received after re-installing:

UPDATED! - Model: 787-01951 | 1 | Product im | Genuine Ro | | | | | | 2.5 | A16801, 78 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | 0 | 0 | | | 0 | 0 | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-16 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
UPDATED! - Model: A318228 | 1 | Product im | Genuine Ro | | | | | | 0.91 | A318228 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | 0 | 0 | | | 0 | 0 | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
No model field in record. This line was not imported1 | Product im | Genuine Ro | | | | | | 0 | | 0 | | | | 0 | 0 | | none | | | 0 | | | | | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | 0001-01-01 | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
NEW PRODUCT! - Model: A123456 | 1 | Product im | Genuine Ro | | | | | | 1 | A123456 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | 0 | 0 | | | 0.5 | 0 | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |

Updated records: 156
New Imported records: 1
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 15648440
Memory Peak: 16318192
Execution Time: 2.96993088722 seconds.

I have also noted that it is not loading user defined product fields which are: products_sku,products_price_carrot,products_length,products_height,products_widt h,products_carrot,threshold_set,products_condition,products_EHF,additional_skus, additional_skus_only,discontinue,products_pdf_attachment,products_vendor_code,pr oducts_vendor_price,availability_id

I am assuming that It has to do with the user defined product fields.

Sorry to see that you are having difficulty. From the above data though, the item with model# A123456 is not a new item but an update of an existing item indicating that there already exists an item with that model#.

If that is so, then when going back to look at the "desired" new item, what is happening is that another has been updated.

To confirm this situation, if you export the complete product list, you can then sort on model # and look for duplicates. Starting specifically with that model#.

Otherwise it may help to identify the process of which report method is chosen to export the file, then what filename the changes are saved as for upload. More questions may follow, but that is a start.

Still need this and more information... Not in front of your computer, so can not make random guesses at what is going on. Now there are new things not previously identified with which to contend. In what table(s) are all of those extra fields? Are they all listed in the configuration->Easy Populate 4->custom fields entry? What data type is each one? Are they all listed in the example provided above? If your datafile only had one record in it, do you get a different result? What EP4 file modifications are there? What happens if you omit the custom fields from the import? What program is used to modify the files?

[SStreich]

I just installed this or tried to and am getting an error that I cannot seem to find the cause.
ZC154 apache Mysql
the plugin is from the download link (purchased) and then again from github.
The error is when I click on the tools tab for EP4
EP4 FATAL ERROR: No default language set.
The site is using en (it's the only language installed)
From Apache error log:
[Fri Apr 10 21:22:39 2015] [warn] [client 107.77.76.52] mod_fcgid: stderr: PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/**/public_html/myadminfolder/easypopulate_4.php on line 184, referer: http://www.**.com/myadminfolder/stat...cts_viewed.php
[Fri Apr 10 21:22:39 2015] [warn] [client 107.77.76.52] mod_fcgid: stderr: PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home/**/public_html/myadminfolder/includes/functions/extra_functions/easypopulate_4_functions.php on line 1143, referer: http://www.**.com/myadminfolder/stat...cts_viewed.php
[Fri Apr 10 21:22:39 2015] [warn] [client 107.77.76.52] mod_fcgid: stderr: PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/mysite/public_html/myadminfolder/includes/functions/extra_functions/easypopulate_4_functions.php on line 1142, referer: http://www.**.com/myadminfolder/stat...cts_viewed.php
[Fri Apr 10 21:22:39 2015] [warn] [client 107.77.76.52] mod_fcgid: stderr: PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/mysite/public_html/myadminfolder/easypopulate_4.php on line 180, referer: http://www.**.com/myadminfolder/stat...cts_viewed.php

I saw some discussion about this back on 1.53
Any advice would be appreciated.

[mc12345678]

What PHP version is reported when clicking on version from the admin panel in the upper right hand corner. While there please identify the reported database information in the lower portion of the upper window.

This was first seen in ZC 1.5.3 because of the way ZC 1.5.3 transitioned to mysqli_ type database calls. EP4 uses some of these direct database calls to provide a slightly more continuous operation. When an error occurs, instead of halting all code, an error log is generated specifically for EP4.

There are also a few files that if not closely related to the original files will cause trouble. Ie if they are from older versions of the same file. That had been seen by a few trying to install the other supported URI rewriter where the 1.5.4 version of the file wasn't used with the 1.5.4 version of ZC.

[SStreich]

PHP Version: 5.3.29 (Zend: 2.3.0) PHP Memory Limit: 128M
Database: MySQL 5.5.40-36.1
I just recently upgraded from ZC153 to 154
If I recall there was a difference in a db file as I ran winmerge on all the files before upgrading. But I don't recall which one it was, it wasn't under any of the admin folders.

[Bruce1952]

Still need this and more information... Not in front of your computer, so can not make random guesses at what is going on. Now there are new things not previously identified with which to contend. In what table(s) are all of those extra fields? Are they all listed in the configuration->Easy Populate 4->custom fields entry? What data type is each one? Are they all listed in the example provided above? If your datafile only had one record in it, do you get a different result? What EP4 file modifications are there? What happens if you omit the custom fields from the import? What program is used to modify the files?

Here is the information that you have requested:

CREATE TABLE IF NOT EXISTS `products` (
`products_id` int(11) NOT NULL AUTO_INCREMENT,
`products_type` int(11) NOT NULL DEFAULT '1',
`products_quantity` float NOT NULL DEFAULT '0',
`products_model` varchar(32) DEFAULT NULL,
`products_sku` varchar(32) DEFAULT NULL,
`products_image` varchar(64) DEFAULT NULL,
`products_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
`products_price_w` varchar(150) DEFAULT '0',
`products_price_carrot` decimal(15,4) DEFAULT '0.0000',
`products_virtual` tinyint(1) NOT NULL DEFAULT '0',
`products_date_added` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`products_last_modified` datetime DEFAULT NULL,
`products_date_available` datetime DEFAULT NULL,
`products_weight` float NOT NULL DEFAULT '0',
`products_length` float(6,2) DEFAULT NULL,
`products_height` float(6,2) DEFAULT NULL,
`products_width` float(6,2) DEFAULT NULL,
`dangerous_goods` int(1) DEFAULT '0',
`products_status` tinyint(1) NOT NULL DEFAULT '0',
`products_carrot` tinyint(1) DEFAULT '0',
`threshold_set` tinyint(1) DEFAULT '0',
`products_tax_class_id` int(11) NOT NULL DEFAULT '0',
`manufacturers_id` int(11) DEFAULT NULL,
`products_ordered` float NOT NULL DEFAULT '0',
`products_quantity_order_min` float NOT NULL DEFAULT '1',
`products_quantity_order_units` float NOT NULL DEFAULT '1',
`products_priced_by_attribute` tinyint(1) NOT NULL DEFAULT '0',
`product_is_free` tinyint(1) NOT NULL DEFAULT '0',
`product_is_call` tinyint(1) NOT NULL DEFAULT '0',
`products_quantity_mixed` tinyint(1) NOT NULL DEFAULT '0',
`product_is_always_free_shipping` tinyint(1) NOT NULL DEFAULT '0',
`products_qty_box_status` tinyint(1) NOT NULL DEFAULT '1',
`products_quantity_order_max` float NOT NULL DEFAULT '0',
`products_sort_order` int(11) NOT NULL DEFAULT '0',
`products_discount_type` tinyint(1) NOT NULL DEFAULT '0',
`products_discount_type_from` tinyint(1) NOT NULL DEFAULT '0',
`products_price_sorter` decimal(15,4) NOT NULL DEFAULT '0.0000',
`master_categories_id` int(11) NOT NULL DEFAULT '0',
`products_mixed_discount_quantity` tinyint(1) NOT NULL DEFAULT '1',
`metatags_title_status` tinyint(1) NOT NULL DEFAULT '0',
`metatags_products_name_status` tinyint(1) NOT NULL DEFAULT '0',
`metatags_model_status` tinyint(1) NOT NULL DEFAULT '0',
`metatags_price_status` tinyint(1) NOT NULL DEFAULT '0',
`metatags_title_tagline_status` tinyint(1) NOT NULL DEFAULT '0',
`products_condition` varchar(32) DEFAULT NULL,
`products_EHF` varchar(100) NOT NULL DEFAULT 'none',
`additional_skus` varchar(250) DEFAULT NULL,
`additional_skus_only` int(1) DEFAULT NULL,
`discontinue` int(1) DEFAULT '0',
`products_pdf_attachment` varchar(300) NOT NULL,
`products_vendor_code` varchar(32) DEFAULT NULL,
`products_vendor_price` decimal(15,4) DEFAULT NULL,
`availability_id` int(11) DEFAULT NULL,
PRIMARY KEY (`products_id`),
KEY `idx_products_date_added_zen` (`products_date_added`),
KEY `idx_products_status_zen` (`products_status`),
KEY `idx_products_date_available_zen` (`products_date_available`),
KEY `idx_products_ordered_zen` (`products_ordered`),
KEY `idx_products_model_zen` (`products_model`),
KEY `idx_products_price_sorter_zen` (`products_price_sorter`),
KEY `idx_master_categories_id_zen` (`master_categories_id`),
KEY `idx_products_sort_order_zen` (`products_sort_order`),
KEY `idx_manufacturers_id_zen` (`manufacturers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20689 ;

I have attached images as well.

Using Open office to edit the files.

Removed the addition fields and still had the same issues as shown in images fields not loaded.

This is what is shown when the file has been uploaded:

Filename: Full-EP2015Apr11-205047.csv

NEW PRODUCT! - Model: EP4test | 1 | Product im | Rover | ep4test | | | | | 2 | 0 | | | | | | | | | 1 | Rover | EP4 Test F | | | | | | | | | | |
Finished Processing Import File

Updated records: 0
New Imported records: 1
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 11443144
Memory Peak: 11916512
Execution Time: 0.0130989551544 seconds.

[mc12345678]

After the upload, have you gone to phpmyadmin to review the data in the products table for that model#? I.e., is it that the data has arrived in the table but is not appearing through the admin? (Thought being/having to do with cacheing of data...) None of this is expected nor previously identified, so am trying to find where the disconnect is occurring. Especially since Image 1 shows information that is not appearing in the following images... (Ie. model # is shown on the admin screen, $2/$0 is showing, etc... But upon entry into the product information, the data is not showing..

In the original post of this issue, it was identified that the site had been recently updated by someone else, and that the current site in use is a "demo" site... Seems that there could be issues with the ZC files between these two locations as compared to a standard/clean installation of ZC...

Are you able to add a new product from the admin without issue?

FWIW, Numinix plugins should not in any way interfere with EP4 or other properly written plugins.

Not described, but when attempting to add a new product to the database without the additional fields in the CSV that were identified on the previous page, was the custom_fields entry blank as well?

If there is still difficulty with importing with just the ZC standard products datatable information and the custom_fields in the Easy Populate V4 configuration menu is blank, then it would appear as there is something else that is awry about how the data is retrieved within the admin panel for the current site. It may also help to have/see the csv file as viewed in a plain text editor pasted between CODE tags [CODE] generated by selecting the # symbol above the reply entry area.

[Bruce1952]

After the upload, have you gone to phpmyadmin to review the data in the products table for that model#? I.e., is it that the data has arrived in the table but is not appearing through the admin? (Thought being/having to do with cacheing of data...) None of this is expected nor previously identified, so am trying to find where the disconnect is occurring. Especially since Image 1 shows information that is not appearing in the following images... (Ie. model # is shown on the admin screen, $2/$0 is showing, etc... But upon entry into the product information, the data is not showing..

In the original post of this issue, it was identified that the site had been recently updated by someone else, and that the current site in use is a "demo" site... Seems that there could be issues with the ZC files between these two locations as compared to a standard/clean installation of ZC...

Are you able to add a new product from the admin without issue?

FWIW, Numinix plugins should not in any way interfere with EP4 or other properly written plugins.

Not described, but when attempting to add a new product to the database without the additional fields in the CSV that were identified on the previous page, was the custom_fields entry blank as well?

If there is still difficulty with importing with just the ZC standard products datatable information and the custom_fields in the Easy Populate V4 configuration menu is blank, then it would appear as there is something else that is awry about how the data is retrieved within the admin panel for the current site. It may also help to have/see the csv file as viewed in a plain text editor pasted between CODE tags [CODE] generated by selecting the # symbol above the reply entry area.

Ok I am able to load a new product but the same issue with fields are not loading. It is the same as if I am using EP4 to upload.

I will advise the installer of the issue and get him to check the database etc.