EasyPopulate 4.0 Support Thread

[amandavz]

Nope...I added the basic and that worked really well....then I tried to add the detailed with new zip file names and it's giving me this again:

SKIPPED! - Attribute Entry on Model: 1 - Not Found!
SKIPPED! - Attribute Entry on Model: 2 - Not Found!
SKIPPED! - Attribute Entry on Model: 3 - Not Found!

I'm wondering if I should try to leave off the v_products_options_name, v_products_options_type and v_products_options_values_name off of the detailed? It seems a little redundant.

[amandavz]

Okay...so here I am again. I did get model 1 and 3 to show up, for some reason it is not giving me model 2. I had to change the v_products_attributes_id #'s. So this might have something to do with why Model 2 isn't showing.

I am going to work on this for a bit and see now that I have the answer...if I can't maybe get my equation correct. LOL.

Thank you so much for all your help and information...you have truly been a blessing. :)

[mc12345678]

Nope...I added the basic and that worked really well....then I tried to add the detailed with new zip file names and it's giving me this again:

SKIPPED! - Attribute Entry on Model: 1 - Not Found!
SKIPPED! - Attribute Entry on Model: 2 - Not Found!
SKIPPED! - Attribute Entry on Model: 3 - Not Found!

I'm wondering if I should try to leave off the v_products_options_name, v_products_options_type and v_products_options_values_name off of the detailed? It seems a little redundant.

So the only reason to receive this message, is that there is no result from the following query:
SELECT * FROM zhs_products_attributes
WHERE (
products_attributes_id = v_products_attributes_id AND
products_id = v_products_id AND
options_id = v_options_id AND
options_values_id = v_options_values_id ) LIMIT 1;
(which means that if the value associated with the v_variable on the right is not present in your CSV file (check that using a basic text editor) then the error message appears. You should see that in each of the four columns (v_products_attributes_id, v_products_id, v_optinos_id, and v_options_values_id) that there is some data associated with each of those and that data is other than "0", "", or NULL.

If the query results in a find, then it will/should process the data successfully.

[mc12345678]

Nope...I added the basic and that worked really well....then I tried to add the detailed with new zip file names and it's giving me this again:

SKIPPED! - Attribute Entry on Model: 1 - Not Found!
SKIPPED! - Attribute Entry on Model: 2 - Not Found!
SKIPPED! - Attribute Entry on Model: 3 - Not Found!

I'm wondering if I should try to leave off the v_products_options_name, v_products_options_type and v_products_options_values_name off of the detailed? It seems a little redundant.

If I remember correctly, those three fields are simply human readable versions of the fields (instead of a number that corresponds to something). Before I personally could suggest leaving them off, I would have to look at where they are used (if for any import information) and then assess who is using the file because it may make sense now in the "battle" with learning how to use it that it may be redundant, but it may also be worth having in the future to reference back. But as the original programmer has said, some things were added for human convenience, others for necessity. It is still in Beta, so it is always possible that it could end up being revised, or even those that use it can always effect how it works on their own installation.

Best of luck, it really is a powerful tool. I will say that if you plan on using it for your own store or others that you consider the affect of the need for unique model numbers. Generally speaking it is a minor impact on business, and I think having looked briefly at your site it will have no impact other than don't lose track of what your most recent "number" is. :)

If you follow the process of uploading a basic, then downloading a detailed, touch up the things that are specific to the detailed, then upload that, you should not run into any problems generally speaking.

[amandavz]

Hi mc...so I went through an entire process and it seems to all work just fine. Now that I understand the formula. I deleted all of the existing product from the site and started fresh with new products, by adding them via the Full-EP, then I added the basic attributes and then the detailed attributes, went through the checkout and was redirected to the site for my downloads. Worked like a charm. Thanks so much again for all your help.

I do have another question for you...if I want to add "new" products to the Full-EP list (I have like 7,000 on another site) should I delete the existing information loaded onto the spreadsheet and start with my new products or do I leave them all and then add my new products to the bottom? I am scared I might screw something up if they are on the list. Also, the same with the Basic & Detailed csv files? Delete and upload or just add and upload?

Thanks again. :)

[mc12345678]

Hi mc...so I went through an entire process and it seems to all work just fine. Now that I understand the formula. I deleted all of the existing product from the site and started fresh with new products, by adding them via the Full-EP, then I added the basic attributes and then the detailed attributes, went through the checkout and was redirected to the site for my downloads. Worked like a charm. Thanks so much again for all your help.

I do have another question for you...if I want to add "new" products to the Full-EP list (I have like 7,000 on another site) should I delete the existing information loaded onto the spreadsheet and start with my new products or do I leave them all and then add my new products to the bottom? I am scared I might screw something up if they are on the list. Also, the same with the Basic & Detailed csv files? Delete and upload or just add and upload?

Thanks again. :)

So, I would say that is a bit of a personal choice, which may be swayed based on a number of factors. First and foremost, you should always make a backup of your database before making changes such as what this plugin does. So, regardless of what is in the datafile, you should be able to come back to what you had. Now, other things about which way to go could include, as you said the possibility of making a mistake by changing something that is "older" and should not have been changed, if a single filename is used and "backups" are not maintained, a mistake in the future may not be noticed until it is way too late, storing the same information again and again on the server in the same file type will use ever more and more space, having a single file that contains all of the recent information will/could help in the future, splitting the files up and including some sort of date/time info can help make sense of it all.

Personally though, I would take the safest quickest route. I would remove all of the "old" data from the one spreadsheet, incorporate the new (though if you download the info from the other site, there really is no "new"/"old" to worry about. But, I would temporarily merge the two files or perform some other verification to ensure that the model numbers were different between the two sets of data, make necessary changes to the new data, and then upload the whole new thing.

After that, well, have to perform a sort of risk assessment. Just remember, you're probably doing this to make some sort of money, so whatever keeps you in business, minimizes time away from that, and minimizes duplicattion of effort.

Btw, glad that you got it sorted out. It really does work well. :)

[tcarden]

sorry to ask a dumb question, but am i looking for examples usages,

i.e., a csv file example exported from Open Office. there must one available somewhere around here??

there is an attribute example file but that is all.

thanks

[mc12345678]

sorry to ask a dumb question, but am i looking for examples usages,

i.e., a csv file example exported from Open Office. there must one available somewhere around here??

there is an attribute example file but that is all.

thanks

So, the downloadable version of this plugin only has the one example, but if not mistaken this forum has examples of files at least that have been tried.

If I may ask, why is it that you ask for examples? Perhaps there is another way for you to gain what you want.

[nick02895]

Zen Cart 1.5.1

Database Patch Level: 1.5.1
v1.5.1 [2013-08-19 12:38:13] (Version Update ocov_1.5.0->1.5.1)
v1.5.0 [2011-12-30 23:57:33] (Version Update zc_1.3.9->1.5.0)
v1.3.9h [2011-12-30 23:56:11] (Version Update zc_1.3.8->1.3.9h)
v1.3.8 [2009-05-30 08:43:48] (Fresh Installation)

added a skin
php 5.4.21

using easypopulate 1.2.5.4 works fine
trying easypopulate_4 I have the menu item under tools, but when I click on it I get website cannot be displayed.

I went over the install several times without any success.
I don't see the config option under tools.
I want to use this version, allows metatags.
would like to avoid a fresh install.
I did uninstall my version and tried it, without success. Read here it is co compatible.
searched here for a couple hours and couldn't find a fix.
any suggestions appreciated.

I didn't include the web, your not going to see the issue.