Table 30127 "Shpfy Product"
Shopify · Microsoft.Integration.Shopify
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 9 connected objects and pages
Shopify · Microsoft.Integration.Shopify · captioned “Shopify Product” · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 30126 “Shpfy Products” (4 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Shopify Product |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Id | BigInteger | Specifies a unique identifier for the product. Each id is unique across the Shopify system. No two products will have the same id, even if they’re from different shops. via Page 30126 “Shpfy Products” | not editable |
| 2 | Created At | DateTime | Specifies when the product was created in Shopify. via Page 30126 “Shpfy Products” | not editable |
| 3 | Updated At | DateTime | Specifies when the product was updated in Shopify. via Page 30126 “Shpfy Products” | not editable |
| 4 | Has Variants | Boolean | — | not editable |
| 5 | Description | Text[250] | Specifies the description in Shopify. via Page 30126 “Shpfy Products” | |
| 6 | Description as HTML | Blob | — | |
| 7 | Preview URL | Text[250] | Specifies the url to preview the product on the webshop. via Page 30126 “Shpfy Products” | not editable |
| 8 | URL | Text[250] | Specifies the url to the product on the webshop. via Page 30126 “Shpfy Products” | not editable |
| 9 | Product Type | Text[50] | Specifies the product type in Shopify. via Page 30126 “Shpfy Products” | |
| 10 | SEO Description | Text[250] | Specifies the description in Shopify used for Search Engine Optimization (SEO). If you change this, this will immediately send to Shopify. via Page 30126 “Shpfy Products” | |
| 11 | SEO Title | Text[100] | Specifies the title in Shopify used for Search Engine Optimization (SEO). If you change this, this will immediately send to Shopify. via Page 30126 “Shpfy Products” | |
| 12 | Title | Text[100] | Specifies the name of the product in Shopify. via Page 30126 “Shpfy Products” | not editable |
| 13 | Vendor | Text[100] | Specifies the name of the product’s vendor. via Page 30126 “Shpfy Products” | not editable |
| 14 | Image Id | BigInteger | — | not editable |
| 15 | Status | Enum “Shpfy Product Status” | Specifies the status of the product in Shopify. Valid values are: active, archived, draft, unlisted. If you change this, this will immediately send to Shopify. via Page 30126 “Shpfy Products” | enum Enum 30130 “Shpfy Product Status” |
| 100 | Shop Code | Code[20] | Specifies the Shopify Shop where these products are synchronized to/from. via Page 30126 “Shpfy Products” | TableRelation Table 30102 “Shpfy Shop” (Shpfy Shop); not editable |
| 101 | Item SystemId | Guid | — | not editable; DataClassification SystemMetadata |
| 102 | Last Updated by BC | DateTime | — | not editable; DataClassification SystemMetadata |
| 103 | Item No. | Code[20] | Specifies the item number. via Page 30126 “Shpfy Products” | FlowField: lookup(Item.“No.” where(SystemId = field(“Item SystemId”))) |
| 104 | Image Hash | Integer | — | not editable; DataClassification SystemMetadata |
| 105 | Tags Hash | Integer | — | not editable; DataClassification SystemMetadata |
| 106 | Description Html Hash | Integer | — | not editable; DataClassification SystemMetadata |
| 107 | Has Error | Boolean | Specifies whether there is an error when creating an item. | not editable; DataClassification SystemMetadata |
| 108 | Error Message | Text[2048] | Specifies the error message if an error has occurred. | not editable; DataClassification SystemMetadata |
Keys
- PK: Id (clustered)
- Key2: Shop Code, Item SystemId
- Key3: Item SystemId
Procedures
GetCommaSeparatedTags(): Text(internal): Get Comma Seperated Tags.GetDescriptionHtml(): Text(internal): Get Description Html.SetDescriptionHtml(NewDescriptionHtml: Text)(internal): Set Description Html.UpdateTags(CommaSeparatedTags: Text)(internal): Update Tags.CalcTagsHash(): Integer(internal)
Triggers
OnDelete
Relations
- Shop Code: TableRelation Table 30102 “Shpfy Shop”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 30100 “Shpfy Cue”: Unmapped Products
Pages and codeunits on this table
- Page 30126 “Shpfy Products” (source table)
- Page 30143 “Shpfy Products Overview” (source table)
- Codeunit 30179 “Shpfy Product Image Export” (codeunit runs on it)
Recent changes
- 2026-09-02 #10775 [Shopify] Optimize unmapped cue counts (main, BC30, performance)
- 2026-07-09 #9253 [Shopify] Disambiguate Shopify timestamp field captions and tooltips (main, BC30, fix)
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Shpfy Product"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.