EasyPopulate 4.0 Support Thread

mc12345678:

What plugin is this? What is the link to download it?

Are you sure it's not just adding visible information to the user display side? After installing it was there anything on the admin side that had to be entered new/differently for product in the admin?
The link to the plugin as requested

adb34:

The link to the plugin as requested

Well after running all around to get to the file, the instructions (README.txt) provide the instructions necessary to 1) install the plugin (SQL statement needed to be executed) and 2) then the field to be added to the user defined fields section: products_cost

This information is now carried from EP4 to the admin and back while using EP4...

mc12345678:

I'll also try to take a look at how images are prepped for saving when using ZC 1.5.4 to see if there is anything further, but really my suggestiion in keeping with good filenaming principles, is that the file itself should be stored in all lowercase, no spaces, be named uniquely (folder(s) used as necessary) so that don't overwrite another image or have an image appear as an extra image to another product (see applicable FAQ for images). Then the EP4 file should contain the matching information for the main product image. All subsequent additional images will display as setup for your cart.

So I dug a bit into the code for a default zc install and didn't see anything that renamed a file to be all lowercase. It toys with it for comparisons against strings, but didn't see anything that modifies the string...

What did you discover with the test/process used? I know I tried to access the problem images using all lowercase letters and the server responded that the file wasn't there, so also wondering if there is something else installed or otherwise affecting the process (other plugins). Because IH4 is activated and uses the older hash function, I am not able to tell how your previous images were identified to offer further review/comment.

Hello

Newbie here , so i apologize if its something obvious for the gurus.

This is not my first shop, but it is my first zencart.
I have a "clean" install on dreamhost and it is up to date.

I manged to get the plugin working.

When i try to upload i get an error, i searched the forums, but did not find anything similar,
and looking at the logs i see.

[17-Feb-2016 17:42:44 America/Los_Angeles] PHP Fatal error:  1062:Duplicate entry '2-1' for key 'PRIMARY' :: INSERT INTO misolproducts_description SET
									products_id				=	'2',
									language_id				=	'1',
									products_name			=	'FORMATO  \"REQUISICION\" 500 PZAS',
									products_description	=	'FORMATO  \"REQUISICION\" 500 PZAS',
									
									products_url			=	''
									 ==> (as called by) /

But i cant find a way to get thru it.
please advice. all pointers and suggestions are greatly appreciated.

agidi:

Hello

Newbie here , so i apologize if its something obvious for the gurus.

This is not my first shop, but it is my first zencart.
I have a "clean" install on dreamhost and it is up to date.

I manged to get the plugin working.

When i try to upload i get an error, i searched the forums, but did not find anything similar,
and looking at the logs i see.

[17-Feb-2016 17:42:44 America/Los_Angeles] PHP Fatal error: 1062:Duplicate entry '2-1' for key 'PRIMARY' :: INSERT INTO misolproducts_description SET
products_id = '2',
language_id = '1',
products_name = 'FORMATO "REQUISICION" 500 PZAS',
products_description = 'FORMATO "REQUISICION" 500 PZAS',

                                products_url            =    ''
                                 ==> (as called by) /

> 
> But i cant find a way to get thru it.
> please advice. all pointers and suggestions are greatly appreciated.

Well, welcome to Zen cart? (I say that because you've been a member since 2009, but just now making your first post. :)

As such, any time an issue is being described, well there needs to be more of a definition.. And such a description should not require being asked for.

So, that small formality aside, I need more information... A lot more information..  
1) ZC version?
2) File name being used for import.
3) File type/fields included.
4) settings in configuration->EP4 (In particular related to what type of primary key is being used.
5) at this point, how many products have been entered/imported and associated products_id.
6) what was used to create/modify the CSV file?

Anything else that can be considered to possibly resolve/understand this issue, perhaps the datafile that is being attempted?

mc12345678:

Well, welcome to Zen cart? (I say that because you've been a member since 2009, but just now making your first post. :)

As such, any time an issue is being described, well there needs to be more of a definition.. And such a description should not require being asked for.

So, that small formality aside, I need more information... A lot more information..

1. ZC version?
2. File name being used for import.
3. File type/fields included.
4. settings in configuration->EP4 (In particular related to what type of primary key is being used.
5. at this point, how many products have been entered/imported and associated products_id.
6. what was used to create/modify the CSV file?

Anything else that can be considered to possibly resolve/understand this issue, perhaps the datafile that is being attempted?

Forgot to also ask, what version of EP4?

Thought I posted this over 6 hours ago, but I guess not....

Well, based on the error message content I can tell that not using EP4 version 4.0.32 (or higher)... Other than that, I don't have a specific clue at the moment what is causing this issue. Can only suggest upgrading to the latest ZC version and associated software.

Hello Again,

I have a similar problem, however mine is not related to character length. When importing with EP4, new products are not appearing, yet in Zen Cart in Category/Products, it displays that there are multiple products active yet they don't display. After looking at my SQL Database the new products are there and displaying all the imported data except for "product_name" and "product_description". For example if the new product I imported has products_id 5, there is no data for the two fields in question, obvious why they don't show up in Zen Cart. What am I doing wrong?

allmart:

Hello Again,

I have a similar problem, however mine is not related to character length. When importing with EP4, new products are not appearing, yet in Zen Cart in Category/Products, it displays that there are multiple products active yet they don't display. After looking at my SQL Database the new products are there and displaying all the imported data except for "product_name" and "product_description". For example if the new product I imported has products_id 5, there is no data for the two fields in question, obvious why they don't show up in Zen Cart. What am I doing wrong?

Okay, so now that I've gone back to identify what version of EP4 has possibly been installed (assuming still EP4 version 4.0.32 on ZC 1.5.4) the questions posted above apply to this issue as well... What filetype was trying to be populated, what was the filename, what are the headers in the csv file that was imported, and what is the text for one or more of the product that. Are not showing up, what are the admin settings for items such as what the primary_key is (assuming the default being products_model), are these new product or is data being removed from existing product...

In otherwords need enough information to reproduce the issue and/or possibly identify if something in fact was being done incorrectly.

Sorry, Easy Populate 4.0.32 on ZC 1.5.4.

csv file below:

v_products_model,v_products_type,v_products_image,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_weight,v_product_is_call,v_products_sort_order,v_products_quantity_order_min,v_products_quantity_order_units,v_products_priced_by_attribute,v_product_is_always_free_shipping,v_date_avail,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_tax_class_title,v_status,v_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
AR695GR,1,AR695GR.png,Arizona Grapeade 24x680ml Can,24x680ml Can,,,,,17.99,39,0,0,1,1,0,0,0000-00-00 00:00:00,0000-00-00 00:00:00,100,Arizona Beverages Canada,Cans Non-Carbonated,Taxable Goods,1,0,0,0,0,0,,,

msg after import:

UPDATED! - Model: AR695GR | 1 | AR695GR.pn | Arizona Gr | 24x680ml C | | | | | 17.99 | 39 | 0 | 0 | 1 | 1 | 0 | 0 | 0000-00-00 | 0000-00-00 | 100 | Arizona Be | Cans Non-C | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |

filename: Book1.csv

And that's the file in it's entirety? Did that model number previously exist or was that a new product?

No, it is not the file in it's entirety, I just wanted to give a short example. It is a new product.

allmart:

No, it is not the file in it's entirety, I just wanted to give a short example. It is a new product.

If you can hang with me just a moment longer, I'd appreciate it. Does the file have the same v_products_model in it more than once? Also, to confirm you are receiving the same error in the debug.txt file as identified on the previous page?

I changed some code to try to allow not having to include a few fields in the import file and I believe that was done incorrectly which is causing the issue identified by you and on the previous page. It is also why I haven't updated the code that is referenced in the first post of this thread. So that I can be sure to ferret out the issue, I would like that information.

Until I resolve the issue created in version 4.0.32, there is an older version that is fully functional (minus the additions made since then) from following the link in the first post of this thread... Your help in this matter is appreciated. I know this tool s helpful to many and am tryiing to make further improvements and keep it functional.

This is the error I found in my log directory:

[19-Feb-2016 08:04:51 America/Phoenix] PHP Warning: Invalid argument supplied for foreach() in /home/content/x/x/x/xxxxx/html/store/xxxxx/easypopulate_4_import.php on line 1908

and no the file does not have the same v_products_model in it more than once.

I will downgrade to the older version as suggested.

Thanks for your help and prompt response.

Please provide the link to the older version, thank you.

allmart:

Please provide the link to the older version, thank you.

Actually, just took a look and thank you so much for looking in the logs directory for that error. The problem on lin 190x is the use of $languages instead of $langcode...

So easiest way to fix this would be to open admin/easypopulate_4_import.php with a plain text editor.
Search for $languages.
Replace with $langcode.
Issue should be resolved.

I'll be updating github momentarily with that change.

Excellent! it works.

Thank you!!!

allmart:

Excellent! it works.

Thank you!!!

Thanks for the update. Github has been updated with that code correction for EP4 version 4.0.32.

Just discovered this error after importing a file with a product that already exists:

An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

ep_debug_log.txt:

MySQLi 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 ':products_name:, products_description = '24x680ml Can', products_url = '' ' at line 1
When executing:
UPDATE products_description SET products_name = :products_name:, products_description = '24x680ml Can', products_url = '' WHERE products_id = 1 AND language_id = 1

The above lines are repeated in the log multiple times for each product_id

Importing new products alone works perfectly.

allmart:

Just discovered this error after importing a file with a product that already exists:

An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

ep_debug_log.txt:

MySQLi 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 ':products_name:, products_description = '24x680ml Can', products_url = '' ' at line 1
When executing:
UPDATE products_description SET products_name = :products_name:, products_description = '24x680ml Can', products_url = '' WHERE products_id = 1 AND language_id = 1

> 
> The above lines are repeated in the log multiple times for each product_id
> 
> Importing new products alone works perfectly.

When posting code, please use the # button in the messagebox toolbar to create ```
[CODE] and [/CODE]
``` tags so that weird things don't appear in the posted message and believe it or not it is actually easier to read the result. But... in this case doesn't matter much.

That would be because on line 1933 is ```
:products_name:
``` while on line 1946 is ```
:v_products_name:

Intention was for line 1933 to have :v_products_name: so that the code might seem clearer to understand. :)

So, again, open admin/easypopulate_4_import.php search for:

:products_name:

replace with:

:v_products_name:

and it will/should work.

github is already updated based on the above report.