EasyPopulate 4.0 Support Thread

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_width,products_carrot,threshold_set,products_condition,products_EHF,additional_skus,additional_skus_only,discontinue,products_pdf_attachment,products_vendor_code,products_vendor_price,availability_id

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

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_width,products_carrot,threshold_set,products_condition,products_EHF,additional_skus,additional_skus_only,discontinue,products_pdf_attachment,products_vendor_code,products_vendor_price,availability_id

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

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.

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?

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/stats_products_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/stats_products_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/stats_products_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/stats_products_viewed.php

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

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.

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.

Thanks for that little pointer- I went back and checked the files.
Sure enough it was a old file I didn't replace with the upgrade, it came from ultimate seo and was the /includes/classes/db/mysql (I replaced both the define and query) so not sure which one but whatever it works now.

There are a few on the store side that are loaded by the admin side that could be involved. If able to do a comparison, may I suggest doing so across the install. Also could look for mysql_ related functions identifying operation is used in some EP4 files to provide backwards compatibility and may be so in other software.

SStreich:

Thanks for that little pointer- I went back and checked the files.
Sure enough it was a old file I didn't replace with the upgrade, it came from ultimate seo and was the /includes/classes/db/mysql (I replaced both the define and query) so not sure which one but whatever it works now.

Glad it was resolved. :) hope all goes well with the software. :)

After further comparison it was definitely the query_factory file.

mc12345678:

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.

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.

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.

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.

Bruce1952:

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.

Noticed something else looking over some history, are you sure also that the issues with previous files randomly disappearing has been fully addressed?

Glad though to see that the issue is comparable to "normal" operation. If the issue arises that there is a problem with EP4, please get back to the forum and provide information... I expect that once the product info issue is corrected that you should be able to use all of your additional products fields as originally setup.

I've tried to search for information on the issue i'm having, if you know where it is please direct me or if you can answer this that would be great too..

Zencart version - 1.5.1
Easy Populate version - 4.0.28

I created a few items using the Zencart admin then exported a .csv file containing those items. I opened the file using the recommended OpenOffice and made sure to have the options (Separated by Tab - Comma - Text Delimiter ") I added some items to the csv file and saved it as test.csv. When I use EP to import the new items I get an error:

No model field in record. This line was not imported Limited E |

Also, a few times (not every time) some of the imported items will not be in the proper sub category even know I had copied the category from other items already uploaded via Admin. Also, some items will randomly disappear entirely.

Any help is appreciated, thanks!

Might be able to help, but first need help to give help... It is highly unlikely that anyone else is in front of your computer screen besides yourself to provide indication of what is being performed. Ie, which of the several EP4 file types are being exported. Then which field(s) are being included/modified/deleted from the file. The filename provided will result in processing the file as if it is a full export related file...

As to the error about not importing,that is related (or expected to be related) to the entry not having a model number, letter, or other unique designation for the product.

Filterable Exports:
Complete Products

Categories:
Alpha, Limited Edition

Manufacturers:
Wizard of the Coast

Status:
All

I am not modifying any of the first row at all, no editing no deleting.

Generally I often end up with several items all with the same v_products_model - do I need to have unique v_products_model?

ExtensiveEnterprises:

Filterable Exports:
Complete Products

Categories:
Alpha, Limited Edition

Manufacturers:
Wizard of the Coast

Status:
All

I am not modifying any of the first row at all, no editing no deleting.

Generally I often end up with several items all with the same v_products_model - do I need to have unique v_products_model?

Regarding unique model #s, yes, unique model #s are required for each product that is to be uploaded otherwise the data in (or omitted from) a later entry will populate the earlier entry...

There are a number of ways to rectify duplicate model#s, including using the data exported by eP4, or as necessary additional data added to the export file.

Doesn't the system automatically create Product ID's?

I suppose what it comes down to is, what is this warning:

No model field in record. This line was not imported Limited E |

and what do I need to do to make my stuff actually import?

ExtensiveEnterprises:

Doesn't the system automatically create Product ID's?

Yes, ZC provides a unique product_id for each product in the database, though that product_id is likely to be different than the product_id of another store and is not referenced by mass data available from a vendor that provides a product with it's own model#. Also certainly two different vendors marketing two different types of product could have the same model #, but things can be done with that data to make them unique in a store.

So to address the second question (not quoted here) about what it takes to populate the store using EP4. Please do not take any comments/suggestions as anything "personal" or attacking, there is no intention of anything other than providing assistance or indicating information that is perceived to be needed to resolve the issue(s).

1. Please read the instructions that are provided to understand the overall functionality and that a. Model # is required.
2. Populate a product in ZC with information that you would like to see/try to change. (Existing data is fine, but important to understand the data in the database.) This is part of the instructions as well.
3. Download the data to a file. From the above it appears that the data is being prefiltered. There is also an option to download the full product data. This latter option is probably useful for a store that is just starting to use EP4 to ensure that the data is sound for future updates.
4. Maintain the first part of the filename depending on how the data is to be used/manipulated. The specific filename prefixes needed are identified in the instructions. An attributes basic file won't necessarily provide the information needed to populate Stock-By-Attributes, if that plugin is installed.
5. Ensure (like eluded) that the csv file for upload is properly quoted (and escaped). And that the field separator is appropriately identified for the export from the spreadsheet program (expected to be the same separator as in the downloaded csv file.)
6. Attempt an upload of a file with a single product. Even if it is a disabled product. Product should remain in the database unless the status of the product is set to 9 in the upload file. Data related to a product will be "deleted" if the row contains no data in the applicable column. Inthe case of two product having the same model # the data of the last row with that model# will replace any data before that row's entry.

Ought to provide a good starting point.