Don't miss out Virtual Happy Hour this Friday (April 26).

Try our conversational search powered by Generative AI!

AI OnAI Off

Anyone know the Table/Column that tells us which Category/Node is the primary Category/Node for a Product in Commerce

Bernard Quick
Bernard Quick
Vote:
 

Hi,

I need to export some commerce data (Categories and Products in those categories).  I have that figured out, but I cannot find the table/column that tells me what the primary/main category is for a product.

Anyone know?

Thanks,

-Bernie

#157786
Sep 22, 2016 1:47
Magnus Rahl
Magnus Rahl
Vote:
 

It is determined by the row in the NodeEntryRelation table with the lowest SortOrder, for each entry id.

#157787
Sep 22, 2016 7:05
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.