Is there a way to clean up the Hikashop product database?

Hi,

3600*~10 variants is only less than 50 000 entries in the hikashop_product.
That's not what is eating your database memory. It shouldn't take more than a few MB. Normally, variants don't have a description and just use the description of their main product, and the description is the main thing eating the memory for a product entry.

The first thing to do is to open your PHPMyAdmin and check the number of entries for each table in the database and the size of each table. I would wager the problem is elsewhere, in another table.
For example, if you've been running HikaShop for years with the Email history plugin activated without a "number of days" set in its settings, the email log table in the database has been steadily growing without any cleanup of its data. The emails take quite a bit of space individually, so if you have hundreds of thousands of them, that could take a significant share of the pie.
It's been a while now that this setting has been added with it's default set to 30 days. But if you updated from an old version, it's possible that you still have that setting empty.

But it could be something else entirely. I'm just talking about the email history because that's something that happened to someone else in the past. Anyways, what to do next depends on what you find in the database.

Hi,

You have 500 MB of data for carts, with 2.3 millions carts in the database. Most of them must be spam, the rest, too old. Probably only a few dozen is even relevant. We implemented improvments recently against these, but these must be from before.
Empty the hikashop_cart and hikashop_cart_product tables to fix this.
You also have 900MB of data from the Joomla Smart Search. You can try to clear the index and try to reindex the search in the Smart Search component. Also, in the HikaShop Smart search plugin, there is a setting to index variants. Check that this is turned off before reindexing the data. That should eat a lot less memory.
You also have 100MB of emails, for a total of a bit more than 10K emails logged. I would recommend clearing the hikashop_email_log table and making sure the plugin is properly configured, as I was saying in my previous message.
The product and variant data is only 50MB in total. You can ignore it, that's not your problem, as I was expecting.

Hi,

Yes, you can just drop all rows in these tables.
What that will do is that real users with a cart will loose their cart.
So, ideally, you want to do that when you know there are not many people connected to your website.