EasyPopulate 4.0 Support Thread

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

[mc12345678]

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.

So, what is the model number for which the two are "the same"? Will provide an update SQL to correct that as well.. Though could create a new problem...

Still confused on how that could happen from the query that was provided if no products began with 002-, the SQL was run as provided to "prepend 002- to all items that did not have a model number", and that I think the table structure for products prevents the same products_id to be applied to two different entries. So, I can't see how two products could have the same model# after the query provided when a duplicate did not exist before the query provided and the above was true, but regardless, seems like could/need to reset the model #'s for those two items which can be done with a query similar to what was provided before, but specific to the items that are currently an issue.

[ideasgirl]

Don't worry about it. Customer will do those 2 by hand, he doesn't mind.

I ran the Att Basic spreadsheet, and it went through just fine with those 2 items again in blue, but it's understandable and few red ones that are actually inactive on main product list, so that's also understandable.

What is not understandable is that when running the detailed att then everything when red. But even products that says there aren't on the inventory, they are.

The thing is that for some reason the main/first store is not displaying some products the same way the new one is; and also the sort order of product attribues aren't showing as they are supposed to on the new site. For example "Please select" not being first and by default.

Old Main Site: www.uogold.com/index.php?main_page=product_info&cPath=0&products_id=100

New Copy Site: www.uogold.com/uoresources.com/index.php?main_page=product_info&cPath=2_7&products_id=103

Both are supposed to have the PREV / NEXT buttons but the old site doesn't. Also look at the dropdown options on new site.

[mc12345678]

Don't worry about it. Customer will do those 2 by hand, he doesn't mind.

I ran the Att Basic spreadsheet, and it went through just fine with those 2 items again in blue, but it's understandable and few red ones that are actually inactive on main product list, so that's also understandable.

What is not understandable is that when running the detailed att then everything when red. But even products that says there aren't on the inventory, they are.

The thing is that for some reason the main/first store is not displaying some products the same way the new one is; and also the sort order of product attribues aren't showing as they are supposed to on the new site. For example "Please select" not being first and by default.

Old Main Site: www.uogold.com/index.php?main_page=product_info&cPath=0&products_id=100

New Copy Site: www.uogold.com/uoresources.com/index.php?main_page=product_info&cPath=2_7&products_id=103

Both are supposed to have the PREV / NEXT buttons but the old site doesn't. Also look at the dropdown options on new site.

The missing Prev/Next is either a template issue or that someone turned off a setting; however, regarding the sort order, orders are applied in the detailed import. After that, I would say that something else is messing with presenting the order. Unfortunately there is nothing related to that particular issue that I can see from physically looking at the web page as a visitor, though it does seem like the div tag for the prev/next buttons is presented without anything beyond that. Might be an issue with the applicable code, but I have not gone into typical code to figure it out. Further differences could be a result of files in override directories on one site but not the other...

As for the red on detailed attributes import, well, could be any number of reasons again without further detailed information. There could be a problem with the way the headings are entered (space before or after a heading entry)... Are you reusing an "old" file in anyway? Or are you downloading a new file, then changing the data inside of it?

You also realize that by having two products downloaded with the same model number that when the file is uploaded it will cause data overwrite so that (and I think that its the case) but both items will have the same data instead of being two unique items. Sorry for taking so long to get this out, I thought I had already sent it. :)

[ideasgirl]

The missing Prev/Next is either a template issue or that someone turned off a setting

I'm not sure of that because here you can see on original one the PREV/NEXT buttons are present, that only happens when a search is done:

www.uogold.com/index.php?main_page=product_info&cPath=11_10&products_id=100

You also realize that by having two products downloaded with the same model number that when the file is uploaded it will cause data overwrite so that (and I think that its the case) but both items will have the same data instead of being two unique items

Yes, I'm aware that there is only 1 item and is the latest on the spreadsheet because having same model it will override all the info of first item found with same model. But isn't it supposed to happen on the attributes as well? On the attributes the item will appear only once, so it's supposed to be attached to only one product, and not affect the import... right?

What I'm going to do is delete those 2 from the detailed att list and see how it goes.

[ideasgirl]

I was just informed that those 2 numbers that were repeated was because he had them twice on the listings.

Now I believe that the items that are not found on the imports they aren't really there. When you see the items on admin you will see them there, but you can't search for them, it's like they don't exist, but when you search for the others, there's no problem. Maybe this is an issue from the patch we did to number the models?

[mc12345678]

I was just informed that those 2 numbers that were repeated was because he had them twice on the listings.

Now I believe that the items that are not found on the imports they aren't really there. When you see the items on admin you will see them there, but you can't search for them, it's like they don't exist, but when you search for the others, there's no problem. Maybe this is an issue from the patch we did to number the models?

I'll say this... Identify an item that had a model # renumbered, that is not locatable in the "search" you have been doing, then go into the admin panel, edit that product, add a character to the end of the model number, save it, and tell me if that new model number is searchable. (Ideally, would like to be able to do that myself, but I can't seem to find where the problematic web address has been provided.) If the item can now be found using that model number, then the model renumbering was incomplete, if however, it still is not found, then there is other data that is incomplete to get a search result. I'm trying to look now to see what information must exist together in order to be provided as a search result.

My guess is that something else is wrong with the database... If ajeh were looking over this, I bet she could tell you straight off where to look. I know I have seen a thread in the forums that addresses something like this: product is listed in admin and store, but not found in a search.