EasyPopulate 4.0 Support Thread

[mc12345678]

Hi There,

I am using ZC 1.5.5a for my store. Someone may have had the same problem or may have posted for help but I have gone through this post and can't find anything.

I am trying to get my Attribute file on EP to work but I keep on getting the word SKIPPED every time I upload it to my store. Any help how to fix this would be a great help. You can see an image of what getting below.

If notice, not all records are skipped, just some of them. While the error reporting does not appear very helpful as is, the statement indicates that there is something wrong with the assignment/existence of applicable option values to the product in question. Has a basic attribute file been used to apply the option name/value pairs to all of the products?

BTW, while not text searchable, the admin folder of the site appears to be presented in the image. Recommendation is to rename the admin directory and not posting it again in the future. :)

[LittleAngell52]

If notice, not all records are skipped, just some of them. While the error reporting does not appear very helpful as is, the statement indicates that there is something wrong with the assignment/existence of applicable option values to the product in question. Has a basic attribute file been used to apply the option name/value pairs to all of the products?

BTW, while not text searchable, the admin folder of the site appears to be presented in the image. Recommendation is to rename the admin directory and not posting it again in the future. :)

It's the new download files that get skipped and can't work out how to add them via ep.

[mc12345678]

It's the new download files that get skipped and can't work out how to add them via ep.

The error is related to not being able to find an existing record to be updated. With the detailed attributes file, it is primarily setup to first export the file of known attributes, then to update the individual records (fields) of it and import those changes.

This is based on the following sql:

SELECT * FROM ' . TABLE_PRODUCTS_ATTRIBUTES . '
                    WHERE (
                    products_attributes_id = :products_attributes_id: AND
                    products_id = :products_id: AND
                    options_id = :options_id: AND
                    options_values_id = :options_values_id:
                    ) LIMIT 1;

If that sql comes back with no results then the error in the above image is provided.

[LittleAngell52]

The error is related to not being able to find an existing record to be updated. With the detailed attributes file, it is primarily setup to first export the file of known attributes, then to update the individual records (fields) of it and import those changes.

This is based on the following sql:

SELECT * FROM ' . TABLE_PRODUCTS_ATTRIBUTES . '
                    WHERE (
                    products_attributes_id = :products_attributes_id: AND
                    products_id = :products_id: AND
                    options_id = :options_id: AND
                    options_values_id = :options_values_id:
                    ) LIMIT 1;

If that sql comes back with no results then the error in the above image is provided.

Right so how do I add or can I add my downloadable files via EP? I always add the products to the store first and upload all my downloadable files.

[mc12345678]

Right so how do I add or can I add my downloadable files via EP? I always add the products to the store first and upload all my downloadable files.

Next would be to assign the attribute to the product using the attribute basic type file, and then the attributes detailed (current file that is only partially working) to provide refined information for the individual product.

[LittleAngell52]

Next would be to assign the attribute to the product using the attribute basic type file, and then the attributes detailed (current file that is only partially working) to provide refined information for the individual product.

Right, I will give that a try today and let you know if it has worked or not. If it doesn't then I will scream. LOL

[LittleAngell52]

Next would be to assign the attribute to the product using the attribute basic type file, and then the attributes detailed (current file that is only partially working) to provide refined information for the individual product.

Aww, it worked and thank you so much for your help mc12345678. I don't know what I would do without this forum as been so helpful to get things done in my store.

[mc12345678]

Welcome, glad it is coming together for you. :)