Product Category Keeps Disappearing

-- HikaShop version -- : 4.3.0
-- Joomla version -- : 3.9.19
-- PHP version -- : 7.4.0
-- Browser(s) name and version -- : Firefox Developer 78.ob8
-- Error-message(debug-mod must be tuned on) -- : Blank Page

I noticed that a product category on the front of the site was not displaying correctly, all 404 and 500 errors for page resources, but other product category pages were fine. See below.
Problem - Beer
No Problem - Soda
I temporarily fixed it by clearing the products and re importing them from scratch.
Today I look again and the problem is back.

I've searched throughout this forum and can not find a solution. This is fairly time sensitive since it is our primary product line. Thanks for your help!

Here is a category that is functioning properly: extonbeverage.com/shop-products/category/2345-soda.html
Here is the problem category: extonbeverage.com/shop-products/category/2123-beer.html

The first displays correctly, the second white screens. The error reads as provided above, 500 and 404s.

I've attempted to remove and add canonical urls, but there is no effect.

I'm not sure if this is related, but looking at the db and the hikashop_product table, there are over 14,000,000 records. The cron is set to import from the POS every 5 minutes. Is it just adding new records rather than updating existing records and the website is timing out because it has to go through so many product records?

I cleared the products via sql, and reimported the latest product update file and the page works again. Which is what happened last time.

So I guess the question is: How do I keep the product update cron from adding new records, but instead just update products that are already in the db?

The problem appears to be that the Mass Actions I have set to update certain products characteristics and add in the variants, is the challenge. Every time it runs it adds in the new variants, the count is up to 16 per product needing the options, at 100+ products needing the options, that adds up quickly.

Is there a way to keep that mass action from running on products that already have the characteristic variants? Joomla errors when I attempt to add a filter for the characteristic, see screenshot.