Good afternoon,
I'm having an issue with which I hope someone can point me in the direction of solving.
I have a extension (VQmod) installed which can filter products by manufacturer, using url ?manufacturer_filter=55
This works fine for products which are inserted through the admin. But I also have a script which can import products from my supplier, and the filter does not find these products. It does almost exact the same as inserting a product through the admin (I took the queries from that model), but apparently not everything that needs to be done to make the product be found with the filter.
Now when I edit an imported product and save, the product can immediately be found with the filter. So it looks like something is 'set' through the admin which is not set in the importer.
I've checked al tables that should contain information for this like 'product', 'product_to_category' and 'product_description' and all info is there.
So where can I look to check what is going wrong? Is there some 'cache' for the products/filter which is cleared only through admin? Or am I forgetting to insert values in a table needed for the filter to find the product?
In the source code I can't find anything that arranges for ?manufacturer_filter=55 to perform a query (also not in the extension xml), but it seems to work for products inserted through admin. So I don't think the extension is the problem, but my method of inserting products.
Any help will be appreciated
I'm having an issue with which I hope someone can point me in the direction of solving.
I have a extension (VQmod) installed which can filter products by manufacturer, using url ?manufacturer_filter=55
This works fine for products which are inserted through the admin. But I also have a script which can import products from my supplier, and the filter does not find these products. It does almost exact the same as inserting a product through the admin (I took the queries from that model), but apparently not everything that needs to be done to make the product be found with the filter.
Now when I edit an imported product and save, the product can immediately be found with the filter. So it looks like something is 'set' through the admin which is not set in the importer.
I've checked al tables that should contain information for this like 'product', 'product_to_category' and 'product_description' and all info is there.
So where can I look to check what is going wrong? Is there some 'cache' for the products/filter which is cleared only through admin? Or am I forgetting to insert values in a table needed for the filter to find the product?
In the source code I can't find anything that arranges for ?manufacturer_filter=55 to perform a query (also not in the extension xml), but it seems to work for products inserted through admin. So I don't think the extension is the problem, but my method of inserting products.
Any help will be appreciated
Attached a screenshot to better explain the issue. The dropdown says 12 articles, which is correct. But only five are shown:the products inserted through admin. Products that I have imported through a script are not shown here, although they are perfectly ok and show up everywhere else in the shop.
Attachments
Screen Shot 2018-09-27 at 08.37.36.png (134.76 KiB) Viewed 605 times
Well, this sounds like calling a Doctor, and telling him, thatI have a extension (VQmod) installed ...
It does almost exact the same ...
But I also have a script which can import products ...
it hurts real bad, but you don't know where, and why ...
But better don't expect anyone, to know, what you're talking about,
as long as you do not deliever anything on any value, not even an
OC Version and the Theme used.
But did you at least activate those Products, in the Admin Product Section ?
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
OC 1.5.6IP_CAM wrote: ↑Thu Sep 27, 2018 9:14 pmWell, this sounds like calling a Doctor, and telling him, thatI have a extension (VQmod) installed ...
It does almost exact the same ...
But I also have a script which can import products ...
it hurts real bad, but you don't know where, and why ...
But better don't expect anyone, to know, what you're talking about,
as long as you do not deliever anything on any value, not even an
OC Version and the Theme used.
But did you at least activate those Products, in the Admin Product Section ?
Ernie
Theme: Aquacart
Extension: https://www.opencart.com/index.php?rout ... n_id=13915
Extension is not the issue, since it's also happening with other extensions with the same functionality
Yes products are enabled ofcourse. On a database level there seems to be no difference between the products.
Maybe lets put it another way: can anyone point me to the file that executes the query that decides which products are shown on the category page when using a filter?
Did you make sure, that they are linked to a Category in the DB ?
Ernie
---
Ernie
---
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Yes, the products appear in the corresponding category, but when I start filtering, the imported products don't appear in the filter results.
Below 2 screenshots from db.
12975 is the imported product, 12996 is inserted through admin
Below 2 screenshots from db.
12975 is the imported product, 12996 is inserted through admin
Attachments
Screen Shot 2018-09-28 at 08.58.23.png (37.72 KiB) Viewed 533 times
Screen Shot 2018-09-28 at 08.58.13.png (47.19 KiB) Viewed 533 times
Screen Shot 2018-09-28 at 08.57.37.png (17.02 KiB) Viewed 533 times
Who is online
Users browsing this forum: Google [Bot] and 231 guests