# Product Product Category Object Reference

Source: https://support.storeconnect.com/articles/products-product-categories-object-reference · Last modified 21 August 2026

## 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](product-category-object-reference)) | 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](product2-object-reference)) | 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-object-reference) | Product_Category_Products |
| `s_c__Product_Id__c` | Lookup | [Product2](product2-object-reference) | Product_Category_Products |

---

## Follow StoreConnect

- [Email Newsletter](https://getstoreconnect.com/c/lp-newsletter)
- [LinkedIn Newsletter](https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7444956928444862464)
- [YouTube](https://www.youtube.com/channel/UCngKdP2x8l1wcbAKW3tvU8g)
- [LinkedIn](https://www.linkedin.com/company/storeconnect)
- [X / Twitter](https://x.com/storeconnecthq)

## Popular Links

- [Partners](https://getstoreconnect.com/partners)
- [News](https://getstoreconnect.com/articles/news)
- [Events](https://getstoreconnect.com/articles/events)
- [Feature Comparison](https://getstoreconnect.com/how-we-compare)
- [Download a free trial](https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000FMkeKUAT)
- [Book a Demo](https://getstoreconnect.com/contact)

## Documentation

- [Help documentation](https://support.storeconnect.com/help-documentation)
- [AI agents](https://support.storeconnect.com/ai)
- [Videos & tutorials](https://support.storeconnect.com/videos-tutorials)
- [Developer reference](https://support.storeconnect.com/developer-reference)
- [Release notes](https://support.storeconnect.com/release-notes)
- [Troubleshooting](https://support.storeconnect.com/troubleshooting)
- [Trust Center](https://trust.getstoreconnect.com/)
- [Status Page](https://status.storeconnect.com/)

## Contact

- info@getstoreconnect.com
- US +1 415 745 3230
- AUS +61 2 8365 2308

100 S Ashley Dr, Suite 600-2461
Tampa FL 33602-600 USA

Level 22, Sydney Place
180 George Street
Sydney, NSW, 2000, AUS

---

StoreConnect Support — https://support.storeconnect.com/articles/products-product-categories-object-reference