# How the StoreConnect data model fits together Source: https://support.storeconnect.com/articles/data-model-overview · Last modified 21 August 2026 StoreConnect installs around 200 Salesforce objects. Read individually they are hard to place, because the schema is wide rather than deep: a handful of objects carry most of the relationships, and everything else hangs off them. Use this article to get oriented before you go looking for a specific object, and to learn the conventions that let you predict what an object looks like before you open it. :::note If you are new to Salesforce objects and fields, read [StoreConnect and Salesforce objects and fields](storeconnect-object-and-field-definitions) first. It covers what objects, fields, and relationships are, how StoreConnect extends the eleven standard objects it uses, and the custom field limits that apply. This article assumes that and concentrates on navigating the reference. To explore the same model visually, the StoreConnect Console has a built-in [Schema Explorer](schema-explorer): an interactive entity relationship diagram covering every object and how they connect. ::: ## Reading any object's page Every object reference article has the same four sections, and the last one is the one people miss: | Section | Answers | |---------|---------| | **Overview** | What the object is, and its API name | | **Fields** | Every field, its type, and whether it is required | | **Relationships** | What this record **points at** | | **Referenced by** | What **points at** this record | **Relationships** and **Referenced by** are the two directions of the same question, and you usually need the second one. If you are asking "what is related to this?", read **Referenced by**. Its **Also links to** column names what a join record connects to on its far side, so you can follow a relationship through a junction without opening it. ## Naming conventions Everything the package installs carries the `s_c__` namespace. Beyond that, three conventions make most of the schema predictable. - **A lookup field ends in `_Id__c`.** `s_c__Store_Id__c` points at the store, `s_c__Product_Id__c` at a product. There are 180 of them. If you are looking for the link between two objects, search for the target's name followed by `_Id__c`. - **`s_c__sC_Id__c` is the sync key.** 148 objects carry it. It is a GUID StoreConnect owns, used to match records between Salesforce and the storefront database. Use it as the external ID when importing, and never edit it by hand. - **Junction objects are named after both sides.** `Product_Tag__c`, `Zone_Country__c`, `Content_Blocks_Pages__c`. See [junction objects](junction-objects). ## The shape of the schema A few objects carry a disproportionate share of the relationships. Knowing which ones tells you where to start reading. | Object | Records pointing at it | What it anchors | |--------|-----------------------:|-----------------| | [Store](store-object-reference) | 40 | Nearly all configuration. 39 objects carry a store lookup | | [Product2](product2-object-reference) | 39 | The catalog, and most commerce | | [Media](media-object-reference) | 26 | Every image, file, and document | | [Account](account-object-reference) | 22 | Customers, suppliers, and brands | | [Contact](contact-object-reference) | 18 | People, and storefront sign-in | | [Product Category](product-category-object-reference) | 15 | Catalog structure | | [Order](order-object-reference) | 14 | Everything after checkout | **Store is the one to understand first.** Almost anything configurable is either on the store record or on an object that points at it, which is what makes a single Salesforce org able to run several storefronts with different catalogs, themes, and payment providers. ## Functional areas The custom objects group into a few areas. This is a reading aid rather than anything the schema enforces: - **Catalog** — products, categories, variants, traits, media, pricing - **Orders and checkout** — carts, orders, payments, vouchers, promotions, discounts - **Store and design** — stores, themes, pages, content blocks, menus, style and script blocks - **Content** — articles, article categories, tags - **Customers and access** — accounts, contacts, memberships, credit, points, approvals - **Fulfillment and inventory** — shipments, stock levels and locations, transfers, zones - **Point of sale** — outlets, registers, shifts, POS layouts and actions, print templates - **Platform** — sync records, custom data mappings, error definitions, settings [Custom objects](custom-objects) lists all of them, and [how stores, themes, and design elements relate](how-stores-themes-and-design-relate) walks through the store and design area in detail. ## Finding your way When you need to know how two objects connect: 1. Open the object reference for either one. 2. Check **Relationships** for a direct lookup to the other. 3. If it is not there, check **Referenced by** — the link is often on a third record that points at both. The **Also links to** column names it. 4. If the connecting record is a junction, [junction objects](junction-objects) explains what that means for querying, importing, and deleting. Most "there is no relationship between these" conclusions turn out to be a junction one step away. --- ## 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/data-model-overview