[SOLVED] Imported products not displayed (in backend and frontend)

-- HikaShop version -- : 4.2.2
-- Joomla version -- : 3.9.12
-- PHP version -- : 7.2
-- Browser(s) name and version -- : all

Good morning

I have a problem which I Have been puzzling with for over a week now:

I have a Filemaker database with 19.200 products, ready for import in the MySQL tables
(wich I have done several times over the tears)

When I do this, my products don't show!

My procedure is:
a. I upload the records to hikashop_product
b. I upload the records to hikashop_product_category

The data is in the MySQL tables, all is fine

BUT

In the backend the product does not show if I select "products"

What do I miss here???

Did I forgot something?

Greetz, Dick

Hi,

This means that the "product_type" column of the hikashop_product table is not filled with the value "main" like all the main products entries are when you create product entries via the interface.

Halleluah!!!!!

Thanks Nicholas!