EasyPopulate 4.0 Support Thread

[allmart]

Excellent! it works.

Thank you!!!

[mc12345678]

Excellent! it works.

Thank you!!!

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

[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 'roducts_name:, products_description = '24x680ml Can', products_url = '' ' at line 1
When executing:
UPDATE products_description SET products_name = roducts_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.

[mc12345678]

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.

[allmart]

Fixed...Thanks again!!!

[mc12345678]

Fixed...Thanks again!!!

No, thank you. Wish there wasn't a need, but keep the comments coming as identified. While not everything will definitely be included as requested, at least attention can/would be provided. :) Nice to have a fresh set of eyes to offer input.

[decalman]

HI there,

I am trying to work out how to add my products via Easy pop 4, I have added 1 x product with the attributes i require through admin and downloaded the CSV file for the attibutes, I then tried to add another product using the CSV however when i goto import the file it comes up with SKIPPED! - Attribute Entry on Model: dk_0601k0116 - Not Found!. I am only adding the products to the Attrib-Detailed-EP2016Feb24-001019 file, should i be edditing other CSV files as well??

Anyhelp will be fantastic as i have around 2000 products to add with different attributes and through admin will take a very very long time

Thank you in advance

Glenn