Forum management
- Threads started by me
- Threads I participate in

Developer forum

Recognise master in database when it has no variants

E-mail notifications

Davy Capiau

Posted on 08/12/2025 14:34:53

Hi,

How can you recognize a master (family or regular) in the database when it has no variants anymore ?

It will have no:

- Variantid
- variantgrouprelations
- Variantcounter
- etc.

I don't see how to distinguish from a regular product

Replies

Imar Spaanjaars

Posted on 08/12/2025 14:43:10

This post has been marked as an answer

Then I think it'll fall back to being a standalone product. One other sign could be the absense of a product number as that's usually empty on a master. However, that's not guaranteed, so you can't tell for sure.

Imar

Votes for this answer: 1

Nuno Aguiar

Posted on 09/12/2025 11:35:00

Hi,

There's also the ProductVariantCounter column. It would be 0 if there are no variants.

Best Regards,

Nuno Aguiar

Imar Spaanjaars

Posted on 09/12/2025 11:55:51

I think that's what Davy meant with Variantcounter

Nuno Aguiar

Posted on 09/12/2025 11:58:13

Ah, right... ( :facepalm )

You must be logged in to post in the forum