Not all products in database are showing up

I have 79 products listed in MYSQL database but only 48 showing in the Hikashop admin product listing!

Any ideas?

If you have characteristics, one variant will be created in the hikashop_product table for each combination of characteristics of your products.
So the number of entries in that table will not reflect the number of products in your store.

Hi,

this is not a variant issue.

This is mostly from products that were imported from virtuemart.

If I create a new menu item with a "product page" option there are products that appear in the drop down menu under the "select a product" list.

But they do not appear anywhere in the Hikashop components product listing.

Hi,

Then it's probably that the link between products and categories was not properly created during the import from VirtueMart for some reason.
That link is stored in the table hikashop_product_category so you should check on it. You should have at least one entry for each product. If not you should add it.