EasyPopulate 4.0 Support Thread

[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

[mc12345678]

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

Again, welcome to ZC!

So with regards to this issue and the way EP4 works. As you have found/desire, entry of multiple products in a single "swoop" is easier with this plugin. That said, it still "follows" the same process. First the product must exist, and as part of "creating" the product, it must go into a category. Then, to apply attributes, the attribute(s) must exist (attributes basic), then the product is populated with the attribute(s) (attributes detailed). In each step that relates to a product, EP4 generally requires a unique model#; however, with EP4 version 4.0.32, it is possible to relate product by the products_id when the admiin configuration settings are "properly" set. A word of note/caution though is that it also depends on how you plan to use/automate EP4. If your import information will be from a vendor iin the form of some other file, then purely using the model# (or possibly some other field as recoded in Ep4) would be suggested. If the data to be imported will be "self generated" then use of the products_id might be more suitable. For those that don't yet have a model# associated, the same feature can be used to apply one to the product.

Help any?

[decalman]

Thank you sir, makes sense ( Sort of ) So in short, add the attribuets in the basic version then once complete get the advanced attibutes and set my prices?

[mc12345678]

Thank you sir, makes sense ( Sort of ) So in short, add the attribuets in the basic version then once complete get the advanced attibutes and set my prices?

Not quite based on the error message of the original post.

Add product,
At some point before assigning attributes to a product add attributes (attribute basic)
After product exists in database assign attributes (attribute detailed).
If continuing to experience difficulty with the code not permitting this to occur, please identify current version. Being used of EP4.

Product can be added by any file that doesn't begin with the predefined filenames. The suggested method is to use the full product link to obtain a valid file format then can modify it to suit for upload.

[lukaswlu]

I have zencart 151 with easy populate for 15x.

It works great but I have Canadapost module and would like to add dimensions to my packages.
So I created v_products_weight v_products_length v_products_width v_products_height in my csv.
Run the file:
UPDATED! - Model: Vineco010 | Pinot Grig | 10 | 69 | 69 | 69 |
UPDATED! - Model: Vineco030 | Cabernet R | 18 | 69 | 69 | 69 |
UPDATED! - Model: Vineco034 | Merlot Was | 18 | 69 | 69 | 69 |
Upload Complete

So everything seems ok, but no, the lenght width and height did not update the weight did.
I can see the values in my products sql database. Not sure what I am doing wrong or if easy populate can do this?
Any help would be greatly appreciated.

[mc12345678]

I have zencart 151 with easy populate for 15x.

It works great but I have Canadapost module and would like to add dimensions to my packages.
So I created v_products_weight v_products_length v_products_width v_products_height in my csv.
Run the file:
UPDATED! - Model: Vineco010 | Pinot Grig | 10 | 69 | 69 | 69 |
UPDATED! - Model: Vineco030 | Cabernet R | 18 | 69 | 69 | 69 |
UPDATED! - Model: Vineco034 | Merlot Was | 18 | 69 | 69 | 69 |
Upload Complete

So everything seems ok, but no, the lenght width and height did not update the weight did.
I can see the values in my products sql database. Not sure what I am doing wrong or if easy populate can do this?
Any help would be greatly appreciated.

Not sure when you say easy populate for 15x if you mean this version of easypopulate, or one of the others. If you have EasyPopulate v4 then yes the user defined product fields requested above can be imported (as well as exported) with one minor admin setting adjustment.

In the configuration settings for EP4, there is a user defined field option. Add to it: products_length, products_width, products_height

Try exporting the product information file, for product where this is already defined, the values should be present, for others they will be either blank or 0.
Then on upload of a file with those fields listed, if the fields are present the data ought to be updated/inserted as applicable.