I have a number of products that are viewable in the store that I cannot find when searching for products from administration. Any suggestions?
Thanks,
Clay
I did not remove the product. When I go into PHPmyadmin I can see the product data and I don't see anything abnormal. Additionally the product is viewable when I export the catalog via the import/export tool. The product has been ordered in the past without issue, even though it was unavailable in admin.
Wow thats unusual, most probably you need to put a print_r($result) type command in you admin/model/catalog/product.php file in the getProducts funtion an see if the missing products show up there.
If they do look in the admin/controller/product.php file for the problem??
I suspect somehow a limit has been set on the number of products the query is able to return.
Hopefully that will be a start for you.
Cheers
Kym
If they do look in the admin/controller/product.php file for the problem??
I suspect somehow a limit has been set on the number of products the query is able to return.
Hopefully that will be a start for you.
Cheers
Kym
Thanks a bunch for the suggestion, What I did was insert a print_r($query) in the getProducts function. (It appears the result is actually assigned to the $query variable). The odd thing is that when I have the print_r function in place the missing products are visible, however if I comment the print_r($query) line out the products are missing again! pretty strange. any thoughts?
OK, I spoke a bit to soon on that last comment.
I changed the items per page in the setting area to 175 for admin. This allowed me to view my entire catalog (150 items)at once. All products are listed but when I start typing product name the missing products do not show. I assume that they actually were listed earlier if I had gone to the right page, but they weren't showing up in the autocomplete in the product name section. However, if I search for the same product in the "model" field all of the missing products are listed.
So it seem to be an issue revolving around the autocomplete functions instead of the actual data query. Any thoughts on how I can address this?
A number of my products have fairly large names, the longest being "Ruger LCP with CT LaserGuard ACE-2 Holster" this happens to be one that is effected, but one named "Ruger LCP ACE-2 Holster" is also not shown in the autocomplete.
Thanks!
Clay
I changed the items per page in the setting area to 175 for admin. This allowed me to view my entire catalog (150 items)at once. All products are listed but when I start typing product name the missing products do not show. I assume that they actually were listed earlier if I had gone to the right page, but they weren't showing up in the autocomplete in the product name section. However, if I search for the same product in the "model" field all of the missing products are listed.
So it seem to be an issue revolving around the autocomplete functions instead of the actual data query. Any thoughts on how I can address this?
A number of my products have fairly large names, the longest being "Ruger LCP with CT LaserGuard ACE-2 Holster" this happens to be one that is effected, but one named "Ruger LCP ACE-2 Holster" is also not shown in the autocomplete.
Thanks!
Clay
Hi again Clay
Sorry for the bumstreer with the print_r($result) thing, I meant $query but it was very late night at my end! Well done for working that one out.
Its great its not actually losing the products from admin, that would be a big WORRY!!
The autocomplete issue is a pain though.
I did a few tests at my end. My version of opencart is 1.5.2.1, whats yours??
Anyway i noticed no problems but I only have a few products.
I remember some other projects I was accross having auto complete issues where the clients internet connection was a bit slow. Whats your connection speed like?
I'm determined to follow this till your happy so I can see you've added the [solved] thing to your original posts title so let me know your version of opencart.
Cheers
Kym
Sorry for the bumstreer with the print_r($result) thing, I meant $query but it was very late night at my end! Well done for working that one out.
Its great its not actually losing the products from admin, that would be a big WORRY!!
The autocomplete issue is a pain though.
I did a few tests at my end. My version of opencart is 1.5.2.1, whats yours??
Anyway i noticed no problems but I only have a few products.
I remember some other projects I was accross having auto complete issues where the clients internet connection was a bit slow. Whats your connection speed like?
I'm determined to follow this till your happy so I can see you've added the [solved] thing to your original posts title so let me know your version of opencart.
Cheers
Kym
This problematic is usually caused by an if statement which the $query may be prevented on outputting based on a possible contribution or due to mass query loads which the server may not be able to return entirely due to waste of resources. Limiting the query loads vs the print_r may help you to solve this issue.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
@Voca:
From the products filter, you can use, either from the admin or from the store-front end a start limit point and an end limit point when launching specific queries to the database in order to avoid mass results.
From the products filter, you can use, either from the admin or from the store-front end a start limit point and an end limit point when launching specific queries to the database in order to avoid mass results.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
There are of course contributions on the market that allows to do such things already. It is very rarely that ideas are being developed as fresh these days with OpenCart.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Who is online
Users browsing this forum: No registered users and 111 guests
