--- id: object/table/30152 type: object title: Table 30152 "Shpfy Catalog" summary: Table 30152 "Shpfy Catalog" in Shopify (Microsoft.Integration.Shopify). 19 fields. Introduced in BC29, still in BC30. tier: official language: en tags: - table - shopify versions: introduced: "29" last_changed: null deprecated: null review: state: derived by: null at: null flags: [] generated: at: "2026-10-11T00:31:51.816Z" pipeline: 0.2.0 prompts: {} input_hash: f3d827a8802d7ded485c2c221012468dac6c90cfe4cbdfb956fe87dcf1d07eef evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Shopify/app/src/Catalogs/Tables/ShpfyCatalog.Table.al title: src/Apps/W1/Shopify/app/src/Catalogs/Tables/ShpfyCatalog.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: - https://learn.microsoft.com/dynamics365/business-central/shopify/synchronize-prices objects: [] features: [] topics: - topic/business-central/business-functionality/online-store-with-shopify localizations: [] videos: [] posts: [] guidelines: [] object_type: table object_id: 30152 name: Shpfy Catalog caption: Shopify Catalog namespace: Microsoft.Integration.Shopify app: Shopify extends: null first_version: "29" last_version: "30" present_in: - "29" - "30" changed_in: [] source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 19 procedures: 3 events: 0 subscribers: 0 relations: out: 11 referenced_by: 0 pages: 2 extended_by: 0 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 30152 "Shpfy Catalog" > Table 30152 "Shpfy Catalog" in Shopify (Microsoft.Integration.Shopify). 19 fields. Introduced in BC29, still in BC30. Shopify · Microsoft.Integration.Shopify · captioned "Shopify Catalog" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Shopify/app/src/Catalogs/Tables/ShpfyCatalog.Table.al) · facts from BC29 Learn documents this table through its pages: [Page 30159 "Shpfy Catalogs"](../page/30159.md) (1 Learn page), [Page 30174 "Shpfy Market Catalogs"](../page/30174.md) (1). ## Properties | Property | Value | |---|---| | Caption | Shopify Catalog | | 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 the unique identifier for the catalog in Shopify. | not editable; DataClassification SystemMetadata | | 2 | Company SystemId | Guid | — | not editable; DataClassification SystemMetadata | | 3 | Company Name | Text[500] | Specifies the name of the company that the catalog belongs to. | FlowField: lookup("Shpfy Company".Name where(SystemId = field("Company SystemId"))) | | 4 | Name | Text[500] | Specifies the catalog's name. | not editable | | 5 | Shop Code | Code[20] | — | TableRelation [Table 30102 "Shpfy Shop"](../table/30102.md) (Shpfy Shop); not editable | | 6 | Customer Price Group | Code[10] | Specifies which Customer Price Group is used to calculate the prices in the catalog. | TableRelation [Table 6 "Customer Price Group"](../table/6.md) (Customer Price Group); DataClassification SystemMetadata | | 7 | Customer Discount Group | Code[20] | Specifies which Customer Discount Group is used to calculate the prices in the catalog. | TableRelation [Table 340 "Customer Discount Group"](../table/340.md) (Customer Discount Group); DataClassification SystemMetadata | | 8 | Gen. Bus. Posting Group | Code[20] | Specifies which Gen. Bus. Posting Group is used to calculate the prices in the catalog. | TableRelation [Table 250 "Gen. Business Posting Group"](../table/250.md) (Gen. Business Posting Group) | | 9 | VAT Bus. Posting Group | Code[20] | Specifies which VAT. Bus. Posting Group is used to calculate the prices in the catalog. | TableRelation [Table 323 "VAT Business Posting Group"](../table/323.md) (VAT Business Posting Group) | | 10 | Tax Area Code | Code[20] | Specifies which Tax Area Code is used to calculate the prices in the catalog. | TableRelation [Table 318 "Tax Area"](../table/318.md) (Tax Area) | | 11 | Tax Liable | Boolean | Specifies if Tax Liable is used to calculate the prices in the catalog. | | | 12 | VAT Country/Region Code | Code[10] | Specifies which VAT Country/Region Code is used to calculate the prices in the catalog. | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region) | | 13 | Customer Posting Group | Code[20] | Specifies which Customer Posting Group is used to calculate the prices in the catalog. | TableRelation [Table 92 "Customer Posting Group"](../table/92.md) (Customer Posting Group) | | 14 | Prices Including VAT | Boolean | Specifies if the prices are Including VAT. | | | 15 | Allow Line Disc. | Boolean | Specifies if line discount is allowed while calculating prices for the catalog. | | | 16 | Sync Prices | Boolean | Specifies if the prices are synced to Shopify. | | | 17 | Customer No. | Code[20] | Specifies the customer number assigned to the catalog. When a customer no. is assigned, 'Customer Discount Group', 'Customer Price Group', and 'Allow Line Discount' settings of the customer take precedence over catalog settings. | TableRelation [Table 18 "Customer"](../table/18.md) | | 18 | Catalog Type | Enum "Shpfy Catalog Type" | — | enum [Enum 30169 "Shpfy Catalog Type"](../enum/30169.md) | | 19 | Currency Code | Code[10] | Specifies the currency code for the catalog. | TableRelation [Table 4 "Currency"](../table/4.md) | ## Keys - PK: Id, Company SystemId (clustered) ## Procedures 3 local procedures, no public ones. ## Triggers OnDelete ## Relations - Customer No.: TableRelation [Table 18 "Customer"](../table/18.md) - Gen. Bus. Posting Group: TableRelation [Table 250 "Gen. Business Posting Group"](../table/250.md) - Shop Code: TableRelation [Table 30102 "Shpfy Shop"](../table/30102.md) - Company Name: CalcFormula [Table 30150 "Shpfy Company"](../table/30150.md) - Tax Area Code: TableRelation [Table 318 "Tax Area"](../table/318.md) - VAT Bus. Posting Group: TableRelation [Table 323 "VAT Business Posting Group"](../table/323.md) - Customer Discount Group: TableRelation [Table 340 "Customer Discount Group"](../table/340.md) - Currency Code: TableRelation [Table 4 "Currency"](../table/4.md) - Customer Price Group: TableRelation [Table 6 "Customer Price Group"](../table/6.md) - VAT Country/Region Code: TableRelation [Table 9 "Country/Region"](../table/9.md) - Customer Posting Group: TableRelation [Table 92 "Customer Posting Group"](../table/92.md) ## Pages and codeunits on this table - [Page 30159 "Shpfy Catalogs"](../page/30159.md) (source table) - [Page 30174 "Shpfy Market Catalogs"](../page/30174.md) (source table) ## Across versions - Present in: BC29-30 - Changed (declaration) in: none Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10). ## 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 Catalog")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.