Failure Product after large number of Variants

-- HikaShop version -- : 3.1.1
-- Joomla version -- : 3.7.4
-- PHP version -- : 5.6

Hi All,

I Tested something with large number of variants, issue now is i cannot open this product anymore, then i get a 500 Server Error
PHP Error is telling me following

**
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 56 bytes) in /home/vhosts/houtvanappel.nl/httpdocs/libraries/joomla/database/driver/mysqli.php on line 886
**

I can add other products and everything, but this specific product causes this error, how can i remove this product, select and delte doesnt work, gives same error...

Hello,

How many variants do you have for your product ?

Please understand that, more you have variant and more memory it will require for your server to handle them all.
So if you want to interact with huge number of variants ; you need to increase your server memory limit.

Regards,

Do i need to upgrade the limit of the SQL?

It happend by accident, its over 2000 variants if i guess.
but i cannot delete the product anymore, because of getting 500 server error.
how to delete this one?

Hello,

The memory limit issue you have is regarding PHP.

2000 is indeed way too much for variants and you can use "options" of "custom fields" in order to avoid having so many items.
If you got more than 100 variants, we consider that you can use another feature to avoid having so many entries to manage (prices, images, etc).

If you can't delete them from the backend product page, I'm afraid that you'll need to do it manually via PHPMyAdmin.
You have to delete elements in the table "hikashop_product" which have the "product_type" "variant" and the "product_parent_id" of the product causing issues.
And you also need to clean up the table "hikashop_variant" and maybe the table "hikashop_price" if you added prices to these variants.

Regards,