-- HikaShop version -- : 2.4.0
-- HikaMarket version -- : 1.6.2
-- Joomla version -- : 3.4.1
-- PHP version -- : 5.3.29
Hello,
on the page of vendor listing and vendor details, I want to show some list of products from category #32 in a module - the list should be independent on which vendor page is currently displayed (it's promo for all the shop).
On the vendor listing, this works nice, there are all the products from desired category shown - but on vendor page the list is empty. As I found this DB query being run, I've understood that the list is being reduced just to vendor's products of this category (and I don't use this feature, I want all vendors' products to be shown:
Code:
SELECT DISTINCT b.*
FROM ceztt_hikashop_product_category AS a
LEFT JOIN ceztt_hikashop_product AS b
ON a.product_id=b.product_id
LEFT JOIN ceztt_hikamarket_vendor AS hikam_vendor
ON b.product_vendor_id = hikam_vendor.vendor_id
WHERE b.product_published=1
AND b.product_type = 'main'
AND a.category_id IN (32)
AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%')
AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1)
AND b.product_vendor_id = 2
ORDER BY RAND()
LIMIT 0, 5
I found the option "Synchronize with currently displayed item when possible" turned on in module settings, so I thought that I just turn it off and the condition "b.product_vendor_id = 2" and all vendors' products will be shown.
But instead, I got the same result on both vendor listing and vendor page I get the same result - just one particular product in the list (all the time the same), which is not even in the requested category nor subcategory. I don't think that there is anything special in the settings of this product, it seems to me like it was picked randomly.
I didn't find the same query as before, but this one is the one that's closest to it (and also the first one operating with the product id :
Code:
SELECT DISTINCT b.*
FROM ceztt_hikashop_product AS b
LEFT JOIN ceztt_hikamarket_vendor AS hikam_vendor
ON b.product_vendor_id = hikam_vendor.vendor_id
WHERE b.product_published=1
AND b.product_id IN (942)
AND b.product_type = 'main'
AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%')
AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1)
ORDER BY b.product_price_percentage DESC
LIMIT 0, 5
Do you know where could be the problem, please? Maybe I've overlooked some kind of setting that causes it?
Thanks in advance.
