Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

AI OnAI Off

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

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.