After creating a vendor product disappears in admin handle (catalog/product list)

Hi

I'm adm1 (administrator)
In nop 3.9

I created a product P1
I link it to a manufacturer M1
I link it to a category Cat1
cat1 is a sub-category of cat2.
This manufacturer M1 created its own customer account C1
I change and link the customer C1 to Vendor V1
I allow vender rights to C1 as well

With this configuration, I have 3 roles for the same partner : C1, M1 and V1

Now, I want work on P1 as web owner administrator Adm1
In catalog/product, the product P1 has disapeared
No product in the list! empty

I tought product P1 handle may be reserved only for vendor V1...
I test to connect myself to C1 identity as I want to fill an order at its place.
The product list is empty as well

I closed C1 session
I go to categories list: categories are well displayed.
I select cat1 and edit button
I go to products tab
Now I see the product P1 (only these linked to cat1)

I could enter in P1 with view button and to try it I press View.
The page of products handle opens but empty

Thus, all products disappeared now.
Vender C1 or me (Adm1) don't see any products.

Regards
Luc

I continu my investigation:

I just created a new product P2 as Adm1
I insert a photo and text only. Nothing else.
I save it
P2 is in the product list, alone!

I add the link to the category cat1
I save it
P1 is still in product list

I added the link to the previous manufafacturer M1
I save it
P1 is in the product list.
All is right here

but all former products are disappeared from the product list

Note: 2 disapeared products (P3 and P4) had been created with Nop3.8 4 monthes ago
the last one, P1 was created with Nop3.9 a week ago
P3 and P4 have no link with M1, C1 nor M1
P4 was desabled as well.

I continued to add information and link in the product P2.
P2 always appears in product list and are openable as expected.

When I use the manufacturer link and open M1:
Click on Products tab displays ALL products linked to this manufacturer: P1 and P2.
when I click on P2: the product page opens as exepected.
When I click on P1: product list opens without P1(nor P3, P4). Only P2 is in the Product list.

How could I help you ?
I think P1 has bug(s) in SQL server record.

I try later to insert a new vender
Maybe P2 will disappear as well in this step..............

my tast tests:
- delete of vendor link for customer C1
- desabling of Vender V1
Products list is wrong!


Right now I've a product P1 visible by web visitors (guests) but not handle as admin.

I foresee I lost these products P1, P3 and P4
Maybe would it be the same issue with hundred products lost...


PS. even my profile photo disappeared here :)

A nice weekend
Luc

Still an idea:

Someone well knowing Nop 3.9 database could give me a SQL request to catch differences between P1, P2, P3 and P4 products please?
I could then give you the result as well.

Luc

Hi
On the home page, I've  products P1 and P2 all visible.

But another visual difference between P1 and P2:
When I click on P2 on the home page, I can going into administration or page handle at the top of the page.
When I click on P1 I have only administration option.

regards,
Luc