Re: Using EP4 to update existing products
Hi all,
We have just had our site upgraded to version 1.5.4 and have Easy Populate 4.0.28 - Beta 01-03-2015 which are testing at present before we go live. Here is some server info:
PHP Version: 5.3.28 (Zend: 2.3.0) PHP Memory Limit: 128M
Server OS: Linux 3.18.5-x86_64-linode52
The EP4 version seems to work ok apart from one thing when I add a new product in csv file it loads it to the site but does not load into the fields. Below is information regarding the upload.
UPDATED! - Model: A16783 | 1 | Product im | Genuine Ro | | | | | | 22.55 | A16783 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | | 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: 732-04839 | 1 | Product im | Genuine Ro | | | | | | 2.68 | A16800, 73 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | | 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: 787-01951 | 1 | Product im | Genuine Ro | | | | | | 2.5 | A16801, 78 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | | 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.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 | | | |
UPDATED! - Model: A123456 | 1 | Product im | Genuine Ro | | | | | | 1 | A123456 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | | 0 | | | 0.5 | | 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 | | | |
Once done I go to the product A123456 that has not added the information to the required fields within it (not that this is only with new product). If I change information on product that are already on the site they are changed using the EP4 module correctly.
Am I doing something wrong when I add new product in the csv file. I have tried copying a line of information already in the file and changed part number and price but still fields are left blank.
Any help would be appreciated as I really like the module and want to sort out if it is the person (ME) on the keyboard not doing correctly.
Re: Using EP4 to update existing products
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.
Re: Using EP4 to update existing products
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.
Re: Using EP4 to update existing products
Quote:
Originally Posted by
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.
Quote:
Originally Posted by
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?
Re: Using EP4 to update existing products
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.
Re: Using EP4 to update existing products
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.
Re: Using EP4 to update existing products
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.
Re: Using EP4 to update existing products
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.
Re: Using EP4 to update existing products
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.
Re: Using EP4 to update existing products
Quote:
Originally Posted by
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. :)
