Product Product Category Object Reference
Overview
The join table between Products and the Product Categories they belong to.
| Property |
Value |
| API Name |
s_c__Products_Product_Categories__c |
| Label |
Product Product Category |
| Plural Label |
Products Product Categories |
| Type |
Custom Object |
Fields
| Field Label |
API Name |
Type |
Required |
Description |
| Active |
s_c__Active__c |
Checkbox |
No |
Determines whether the related Product is active on the related Product Category. At least one of these relationships should be active for a Product to be displayed on a store. Particularly considering StoreConnect supports multiple stores, this configuration describes the fact that the Product itself is active for sale, and that it’s inclusion in a store’s category is active, therefore the Product should be available for sale in that store |
| Product Category |
s_c__Category_Id__c |
Lookup (s_c__Product_Category__c) |
Yes |
A Lookup to the Category related to the given Product. |
| Product Category Name |
s_c__Category_Name__c |
Formula (Text) |
No |
Formula field that displays the Category name for related lists. |
| Position |
s_c__Position__c |
Number(18,0) |
No |
The position of this Product in relation to all Products in this Category. Lower numbers are shown first. If not specified, products are sorted alphabetically by name. |
| Primary |
s_c__Primary__c |
Checkbox |
No |
Determines whether the Category is the Primary Category for the given Product. |
| Product |
s_c__Product_Id__c |
Lookup (Product2) |
No |
|
| Product Name |
s_c__Product_Name__c |
Formula (Text) |
No |
Formula field that displays the Product name for related lists. |
| Taxonomy Name |
s_c__Taxonomy_Name__c |
Formula (Text) |
No |
Formula field that displays the Taxonomy name for related lists. |
| StoreConnect External ID |
s_c__sC_Id__c |
Text(36) |
No |
StoreConnect External ID, do not modify in Salesforce |
Relationships
| Field |
Type |
Related Object |
Relationship Name |
s_c__Category_Id__c |
Lookup |
s_c__Product_Category__c |
Product_Category_Products |
s_c__Product_Id__c |
Lookup |
Product2 |
Product_Category_Products |
Last updated March 6, 2025
