Is there a limit on products association in badges?

  • Posts: 45
  • Thank you received: 3
5 years 7 months ago #297494

-- HikaShop version -- : 3.5.1
-- Joomla version -- : 3.8.12

My client claims, and I can confirm after a test, that she can't add more than 51 products. She can select more, but when saving the selection keeps only the first 51 products. Is there a limit, and if so, is it configurable? She uses a badge for new products over all product categories, so she needs more than that. FOr now, she works around it by creating a second badge, and if there is a limit, I guess for better control, she would have to maintain one badge per main category, but maybe there is a trick?

Kind regards,
Terry

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

  • Posts: 81540
  • Thank you received: 13070
  • MODERATOR
5 years 7 months ago #297495

Hi,

The products selection is stored as a list of the ids of the products separated by a comma in the badge_product_id column of the hikashop_badge table. That column type is varchar 255 by default. So it can only store up to 255 characters.
If you want more than that, then simply change the type of that column to "text" in your phpmyadmin and you'll be able to store around 65000 characters in it and thus at least several thousands products.

The following user(s) said Thank You: bytekultur

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

Time to create page: 0.062 seconds
Powered by Kunena Forum