EasyPopulate 4.0 Support Thread

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

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

Okay, I roughly completed my review of what is needed to perform a search, or at least an advanced search (which should offer more options than a basic search), anyways. It looks like there may need to be data present in a few other tables for a product to show up on a search. Here is the coded criteria to get something back from a search with some variables replaced with the ZC default table name (No extensions used):

FROM (products p
             LEFT JOIN manufacturers  m
             USING(manufacturers_id), products_description  pd, categories c, products_to_categories p2c )
             LEFT JOIN meta_tags_products_description mtpd
             ON mtpd.products_id= p2c.products_id
             AND mtpd.language_id = :languagesID";

There is a lot of data that can potentially be returned. The beginning of the statement is not included above, as it does not so directly affect whether something will be returned at all.

Now, I haven't gone to see how the above behaves, and I'm not always on the ball with the various SQL layouts, but if you would entertain the following ideas, perhaps can resolve the issue...

To me, it looked like the meta data needed to be present, but that seems wrong. Although I had run the model number update last night on my unmodeled data, I went ahead again today created a new generic product, didn't enter a model number, reviewed the meta_tags_product_description table and saw that there was an entry missing for my latest addition, performed a search on the product and it appeared... So, does not seem to be related to that.

Did a little searching, which you should have already done as well.. Check this link to see if it offers a solution for your problem: http://www.zen-cart.com/showthread.p...395#post816395

I know there are more recent similar articles because I was watching some of them unfold in the last month or so, but I couldn't tell you exactly where to find them and what specifically corrected their issue.

[ideasgirl]

I haven't read your latest post but I just wanted to tell you that I did several searches and the pattern I see is that every model number where there are only 2 digits after the - are not searchable, not even if I add a number or a letter. So only the 002-### appear to be "real" model numbers, the others are like "non-existent" on the db.

I just noticed that I thought that was a pattern, but there are 3 digit models that are also not searchable. And the thing is that not only by model number, if you do a search for an item of those, you won't find it neither by doing a search by name.

----
I also noticed that all the model numbers after the - are the same as the product id. So I guess that was the patch work, right? I haven't seen anything not matching.

[ideasgirl]

Thanks for all the help MC, don't worry anymore for this issue. Here's what I did to solve it and the resume of everything:

-The 2 items that were repeated models were actually repeated items (I learned this from customer so no biggy there), the items where there and the final total of items were 834.

-I noticed that after the basic att import all the attributes were in place, just not sorted.

-Since the detailed import failed few times (100%), I went to the attributes sorter feature and click on sort all attributes for all products, and that made the sort issue to disappear.

-Then last I exported a detailed att export, I downloaded it and did the "Please Select" changes on the spreadsheet and then uploaded without any issues.

-----------MAGIC-----------

On the new site all the numbers are searchable, so I will see if downloading and uploading the full list on the old one will solve that issue there.

I believe that the little db patch you gave me should be included on your ReadMe file for next version because that really would be a great piece of info to those that don't have/use model numbers on their items and want to use EP from then on.... If I got that piece of info 3 weeks ago, my customer wouldn't have gone for so much trouble and time creating those on the datasheet. It's GOLD info.