How to display on details and cart pages "other clients also bought"

  • Posts: 32
  • Thank you received: 1
  • Hikashop Business
3 weeks 2 days ago #367467

-- HikaShop version -- : 5.1.6
-- Joomla version -- : 5.3.0
-- PHP version -- : 8.3.6

Hi,

I'm unable to display products that "other clients also bought". I don't know how to configure the content module and if there is other settings that need to be configured also. Can you provide a tutorial on what is needed to be configured so that when customer is on a product details page, it display a listing of products bought by previous customers who purchased the current product? Also is it possible to show this too on the cart page? Sort of like showing the customer before they checkout they might find this product useful or something of interest and entice them to add to the cart. Thank you!

Please Log in or Create an account to join the conversation.

  • Posts: 83997
  • Thank you received: 13611
  • MODERATOR
3 weeks 1 day ago #367468

Hi,

So, there are several steps:
1. First, you want to create a module of the type "hikashop content module" via the Joomla modules manager (already done for you)
2. Then, you want to select it in the "Modules under the product page" setting of the HikaShop configuration:
www.hikashop.com/support/documentation/5...html#display_product
3. In the settings of the module, under the HikaShop options tab, you want to:
- Select your main category in the "main category" setting
- Select "product" for the "Type of content" setting
- Set the "Sub elements filter" setting to "all sub elements"
- Set the "Synchronize" setting to "Yes"
- Make sure the "Discounted only", "Related products from cart only" and "Recently viewed" settings are turned off
- Set the "relation" setting to "other clients also bought"

This will display the listing below the description on the product page.
Note that for the module to display products on a product page, you need to already have orders with the status "confirmed" with the product of the page included in these orders, AND you need to have other products in these orders.

There is no option to display a "listing of the products bought by other users along with the products already in the current cart" on the checkout.
The closest is this :
www.hikashop.com/marketplace/product/142-checkout-related.html
But the products need to be selected as related products of the products in the cart.

Please Log in or Create an account to join the conversation.

  • Posts: 32
  • Thank you received: 1
  • Hikashop Business
3 weeks 11 hours ago #367497

Hi Nicolas,

Thanks for providing such a thorough set of steps. I'm running into a problem though once I setup. On the product details pages I get the following error. 1054 - Unknown column 'a.ordering' in 'order clause'

Also in the browser console and error about jQuery.
- Uncaught ReferenceError: jQuery is not defined

I also have the module set to display on all pages. Here is a screenshot of the module settings.



Any thoughts? Thanks.

Attachments:
Last edit: 3 weeks 11 hours ago by rjrsinc. Reason: Added screenshot.

Please Log in or Create an account to join the conversation.

  • Posts: 83997
  • Thank you received: 13611
  • MODERATOR
2 weeks 6 days ago #367505

Hi,

The issue is with the "ordering column". Change it to something else than "ordering". Or activate the "random items" setting.
It will prevent the error from happening.
We'll add a patch on our end so that this doesn't happen.

Please Log in or Create an account to join the conversation.

  • Posts: 32
  • Thank you received: 1
  • Hikashop Business
2 weeks 6 days ago #367522

I updated the ordering to product id. Seems to work now, however I'm noticing that some products are not displaying images. I think it has something to do with webp option enabled or perhaps since enabling this module. Any thoughts

?

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 83997
  • Thank you received: 13611
  • MODERATOR
2 weeks 5 days ago #367525

Hi,

If you open a product with the issue, you'll have the same problem. So it's not only a listing issue.
It's indeed linked to webp.
From what I can see on your website on a page with the problem, the webp file for these products is corrupted somehow and the browser is not able to render it properly.
So, try going in the folder images/com_hikashop/upload/thumbnails/300x300f via FTP and delete the webp images from these products. Then, display the product again on the frontend. HikaShop will try to regenerate the webp image from the original image.
If you don't get the issue, then problem solved.
If you get the same issue, then it means there is a problem with the original image preventing PHP from generating the webp image. What you could do is to generate the webp image yourself on your computer and upload it via FTP to the correct location.

The following user(s) said Thank You: rjrsinc

Please Log in or Create an account to join the conversation.

  • Posts: 32
  • Thank you received: 1
  • Hikashop Business
2 weeks 3 days ago #367542

Hi Nicolas,

I tried deleting the specific webp file from the server and then refreshed the page and this process seems to be generating the webp file correctly and is now loading in the browser.
Depending on if the product image is being displayed from the module or if the product image is displayed on a details page, I need to delete the corresponding webp image file at the appropriate location. So in the case of the image displayed from the module, it is pulling images from the /images/com_hikashop/upload/thumbnails/150x150f/ directory and if the image is a product details image, it is coming from the //images/com_hikashop/upload/thumbnails/300x300f/ directory like you referenced.

This seems to be resolving the issue when I encounter any missing images. Thanks for the tip.

The following user(s) said Thank You: nicolas

Please Log in or Create an account to join the conversation.

Time to create page: 0.103 seconds
Powered by Kunena Forum