EasyPopulate 4.0 Support Thread

[mc12345678]

Yes, it was consecutive entries on the spreadsheet (nothing to do with product_id).

I already ran it with both 001, and 002, didn't see anything unusual the only odd thing that on products all display if i sorted by model number for example 001-101, then 001-1001, 001-1019, 001-102, 001-1020... that kind of sorting, but it will do the same in both scenarios.

I will use 002 just to be safe.

So, if all of the entries had 4 digits after the - and these now only have three, you could use 002-0 as the prefix and that would put them in a somehat numerical order. You could also get real picky about it, and if want all items to have 4 digits after the dash, could imploy the query with an additional catch on the where part:

So here the concat would have '002-000'
Where products_model = '' and products_id < 10;
And then have 002-00
Where products_model = '' and products_id < 100;
And then have 002-0
Where products_model = '' and products_id < 1000;
And then have 002-
Where products_model = '' and products_id < 10000;
(Thankfully no product has products_id = 0 otherwise would need one more. But thatthe "lazy" way to apply the formatting.

[ideasgirl]

I will keep it simple, he's not picky about it, we just want to solve the issue, and he can take it from there on when entering products.

Thanks! You have been great help.

[ideasgirl]

Ok, BIG PROBLEM.

I did it as planned. Worked like a charm, here's where it failed:
-I did a new export to propagate new site. = FINE AND DANDY, everything worked just right.
-I did another export of attributes to upload and import to new site. = everything turn to this:
SKIPPED! - Attribute Entry on Model: 002-12 - Not Found!
with all the model numbers WRONG.

I checked the spreadsheet and there it was, all the numbers where changed on the spreadsheet... WHY?
Instead of 002-100, 002-1000, 002-1002.... they are 002-12, 002-13, 002-14. And even there's a model 002-1009, the system is saying there's not.

Final report on that:
Updated records: 0
New Imported records: 0
Errors Detected: 3439
Warnings Detected: 0
Memory Usage: 4546612
Memory Peak: 4755516
Execution Time: 0.787619829178 seconds.

NOW WHAT?

[mc12345678]

Ok, BIG PROBLEM.

I did it as planned. Worked like a charm, here's where it failed:
-I did a new export to propagate new site. = FINE AND DANDY, everything worked just right.
-I did another export of attributes to upload and import to new site. = everything turn to this:
SKIPPED! - Attribute Entry on Model: 002-12 - Not Found!
with all the model numbers WRONG.

I checked the spreadsheet and there it was, all the numbers where changed on the spreadsheet... WHY?
Instead of 002-100, 002-1000, 002-1002.... they are 002-12, 002-13, 002-14. And even there's a model 002-1009, the system is saying there's not.

Final report on that:
Updated records: 0
New Imported records: 0
Errors Detected: 3439
Warnings Detected: 0
Memory Usage: 4546612
Memory Peak: 4755516
Execution Time: 0.787619829178 seconds.

NOW WHAT?

Ok, deep breath. Please slow down and provide more detail.

File names, expected action to be done with that file. (Attribute detailed upload, download, etc.)
Regarding the "change" of model numbers, considering what was explained as likely duplicate entries of content with different products_id's are you saying that no where in the data is the model numbers that you had before when exporting? That would occur if the where statement was omitted in the update query which would then make every model# begin with 002- not just the ones that were previously blank.

Also, browser cache/cookies refreshed?

[ideasgirl]

Not understanding very well your questions but I will try to be accurate...

are you saying that no where in the data is the model numbers that you had before when exporting?

Yes, like I posted... on the spreadsheet AND on the site when you are in frontend there are many of those model numbers, but system is not recognizing those numbers. Like for example: model 002-1009 is there, but system is saying there's no product with model number 002-1009.

The previous upload I did with the other spreadsheet where I discovered the issue this morning is gone because I restored the database afterwards with the backup I had made before the import, so there are nowhere on the db.

Would this answer your questions?

[mc12345678]

Not understanding very well your questions but I will try to be accurate...


Yes, like I posted... on the spreadsheet AND on the site when you are in frontend there are many of those model numbers, but system is not recognizing those numbers. Like for example: model 002-1009 is there, but system is saying there's no product with model number 002-1009.

The previous upload I did with the other spreadsheet where I discovered the issue this morning is gone because I restored the database afterwards with the backup I had made before the import, so there are nowhere on the db.

Would this answer your questions?

Unfortunately, no it adds more questions.

Please in order of time identify what you have done. At some point today a backup of something was made. At some point something was restored (what was the something a EP4 file, the complete database?)

When you say frontend, are you referring to the admin panel or in the store?
I thought the model numbers were not used for anything specific, so how can one search for the model as a customer to the store?

There may be other issues with the data if previously a search was successful, but now not.

What I was referring to was, when you download/export the database to a spreadsheet are the original model numbers still in the spreadsheet?

[mc12345678]

Unfortunately, no it adds more questions.

Please in order of time identify what you have done. At some point today a backup of something was made. At some point something was restored (what was the something a EP4 file, the complete database?)

When you say frontend, are you referring to the admin panel or in the store?
I thought the model numbers were not used for anything specific, so how can one search for the model as a customer to the store?

There may be other issues with the data if previously a search was successful, but now not.

What I was referring to was, when you download/export the database to a spreadsheet are the original model numbers still in the spreadsheet?

The other question I was trying to get an answer to was: what file were you trying to upload into the database? What did you expect to change/be doing?

So did you create an attribute detailed file for one or more products, but had not created an attributes basic file? So therefore when you used the attributes detailed file to "modify" attribute data EP4 created an "error"?

From what little has been provided it seems that the product(s) (with new model numbers) didn't have the attributes applied to them that were tried when the "error" message appeared.

To understand clearer explanations of what was done and what was observed need to be provided. Preferably in order of time. Also take your time in explaining. If I was standing over your shoulder when this all happened, I wouldn't be asking a single question, because I would have watched exactly what was done. No one here had that luxury, so we need to hear from you what is going on, how it is identified, what was expected to be seen/happen, etc... As said, take a deep breath, relax, and tell the story from beginning to end.

[ideasgirl]

At some point something was restored (what was the something a EP4 file, the complete database?

Actually I didn't with the current site, I did a backup last night but this morning (after being notified by customer about duplication) what I did was used same spreadsheet (with new model numbers) and use the DELETE feature of EP.

Then after that, all my tests have been using the backup/restore using MyBackupSql module.

When you say frontend, are you referring to the admin panel or in the store?

Store.

I thought the model numbers were not used for anything specific, so how can one search for the model as a customer to the store.

They actually aren't, I'm doing the search because the system is saying they don't exist to do the attributes.

What I was referring to was, when you download/export the database to a spreadsheet are the original model numbers still in the spreadsheet?

When you say original, do you mean the ones that were done by the patch you gave me? If so, yes, but there are others that weren't present on original spreadsheet, but now that I think it's maybe because the original spreadsheet only has the ACTIVE products and attributes has them all.... maybe?

Still doesn't explains why is rejecting the ones that are active.

-----------
Yes, you are right! I didn't do the simple attributes first, I did the detailed one... so I guess that's the bad step?

[mc12345678]

Actually I didn't with the current site, I did a backup last night but this morning (after being notified by customer about duplication) what I did was used same spreadsheet (with new model numbers) and use the DELETE feature of EP.

Then after that, all my tests have been using the backup/restore using MyBackupSql module.


Store.


They actually aren't, I'm doing the search because the system is saying they don't exist to do the attributes.


When you say original, do you mean the ones that were done by the patch you gave me? If so, yes, but there are others that weren't present on original spreadsheet, but now that I think it's maybe because the original spreadsheet only has the ACTIVE products and attributes has them all.... maybe?

Still doesn't explains why is rejecting the ones that are active.

-----------
Yes, you are right! I didn't do the simple attributes first, I did the detailed one... so I guess that's the bad step?

Yes that is the step in the process that was missed. Basic import to create the link of the attribute to the product, then a detailed attribute import to link the data specific to that attribute (price, and other information).

And although I possibly still have more questions, if you are able to at least able to move forward with the next desired step, then you should be able to sort out the other issues on your own.

When dealing with attributes (and other options) a "basic" import must be done/or have been done before a detailed import can be done. This is true even when using ZC for one product at a time... Think about the process.. EP4 just does it a little quicker and with several things at once...

So, a product gets added with some basic things, then a bunch of other data gets entered... Then Option Names are created, option values are assigned to option names, then option name/value combinations are tied to a product, then all of the details of each attribute are populated, one attribute at a time... Well, EP4 does this in two steps: the Basic attributes will create new option names if necessary, and new option values, but then will assign the combination to the product. The detailed attribute import then populates all other information that relates to the product's attribute. If the first step hasn't been done either in ZC admin ("slow way") or in EP4 (or similar software) through the basic import, then it must be done...

This process has been described before in this thread, but is provided again to hopefully help the next individual checking out this plugin.

[ideasgirl]

Ok, I'm going step by step with new exports I just made. I ran your patch, and made new backup of that, and new exports.

When I ran the products on new sites (complete product list) I notices few blue items what is not supposed to because everything should be green (new items).

When looking for those numbers in the database I see they are duplicated. So apparently the patch somehow didn't work to perfection because there are few items with same model number. To be exact: 2.