EasyPopulate 4.0 Support Thread

[ideasgirl]

If the store owner mapped 001- as consecutive entries instead of in accordance with the product_id (or if mistyped when entering it by product_id) then the possibility of duplication may exist and then, well all sorts of unexpected things start happening if the duplication was not planned.

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.

[ideasgirl]

I couldn't edit my post to include the screenshot I forgot to include:
http://imageshack.com/a/img823/9546/llna.jpg

[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?