Can't delete a product using admin

  • Posts: 29
  • Thank you received: 2
6 years 8 months ago #289331

-- HikaShop version -- : 3.3.0
-- Joomla version -- : 3.8.4
-- PHP version -- : 5.6

I have added a product to my Hikashop. I tried to add multiple characteristics to the product listing. I also had many variants to each characteristic. As a result, my database table "product" now has over 300,000 pages in it because of the variants.

I have tried to delete the problem product, but when I try to delete it I get an Internal Server Error and can't delete the product. I also cannot open the product for editing either. When I try to open the product for editing, I get an "Access Forbidden" error.

How can I delete this product and clean up the database so that I don't have so many pages of variants?

I would be glad to share privately admin access to my site if someone can help.

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

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
6 years 8 months ago #289346

Hi,

You can potentially do it with the mass action system in System>Mass actions.
You can create a new one with a filter on the column product_parent_id equal to the id of the product for which you want to delete the variants, and with an action "delete the elements".
When you click on the process button, it will delete the first 500 elements (you can increase that to 2000 and it should still work in the limitation area). Repeat the process button until there are no variants left and you'll then be able to access your product and reconfigure it.
Otherwise, if you want to clear all your products in a fast way, go in your phpmyadmin and empty the tables hikashop_price, hikashop_product, hikashop_variant, hikashop_product_category, hikashop_product_related and hikashop_file.

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

  • Posts: 29
  • Thank you received: 2
6 years 8 months ago #289373

Cleared the un-needed entries using PHPMyAdmin. Database is cleaned up now and site is functioning properly.

Thanks for the info.

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

Time to create page: 0.058 seconds
Powered by Kunena Forum