---
title: "Table 30102 Shpfy Shop"
author: "JOP-AL"
url: https://jonas-paprotka.de/ref/table/30102-shpfy-shop/
type: table
id: 30102
name: "Shpfy Shop"
app: "Shopify Connector"
namespace: Microsoft.Integration.Shopify
versions: "20-29"
build: 29.0.54011.55644
countries: "W1, DE, US"
source: "https://jonas-paprotka.de/ref/table/30102-shpfy-shop/source/?v=27 https://jonas-paprotka.de/ref/table/30102-shpfy-shop/source/?v=28 https://jonas-paprotka.de/ref/table/30102-shpfy-shop/source/"
checked: 2026-11-20
changed: 2026-10-16
subject: "Microsoft Dynamics 365 Business Central"
license: "Metadata from Microsoft's symbol packages. AL source MIT, Copyright (c) Microsoft Corporation. Selection and wording © 2026 JOP-AL. https://jonas-paprotka.de/licenses/"
---

# Table 30102 Shpfy Shop

JOP-AL, https://jonas-paprotka.de/ref/table/30102-shpfy-shop/

| | |
| --- | --- |
| App | Shopify Connector |
| Namespace | Microsoft.Integration.Shopify |
| Versions | 20-29 |
| Minors | W1 20.1-29.0; DE 20.1-29.0; US 20.1-29.0, [every minor](https://jonas-paprotka.de/ref/table/30102-shpfy-shop/editions.json) |
| Source file | src/Base/Tables/ShpfyShop.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | Code | Code[20] | 20-29 | - | - |
| 2 | Shopify URL | Text[250] | 20-29 | - | - |
| 3 | Enabled | Boolean | 20-29 | - | - |
| 5 | Log Enabled | Boolean | 20-29 | Removed 26.0 | Replaced with field "Logging Mode" |
| 6 | Customer Price Group | Code[10] | 20-29 | - | - |
| 7 | Customer Discount Group | Code[20] | 20-29 | - | - |
| 8 | Shipping Charges Account | Code[20] | 20-29 | - | - |
| 9 | Language Code | Code[10] | 20-29 | - | - |
| 10 | Sync Item | Option | 20-29 | - | - |
| 11 | Item Template Code | Code[10] | 20-29 | Removed 25.0 | Replaced by Item Templ. Code |
| 12 | Sync Item Images | Option | 20-29 | - | - |
| 13 | Sync Item Extended Text | Boolean | 20-29 | - | - |
| 14 | Sync Item Attributes | Boolean | 20-29 | - | - |
| 15 | Sync Item Marketing Text | Boolean | 22-29 | - | - |
| 21 | Auto Create Orders | Boolean | 20-29 | - | - |
| 22 | Auto Create Unknown Items | Boolean | 20-29 | - | - |
| 23 | Auto Create Unknown Customers | Boolean | 20-29 | - | - |
| 24 | Customer Template Code | Code[10] | 20-29 | Removed 25.0 | Replaced by  "Customer Templ. Code" |
| 25 | Product Collection | Option | 20-29 | - | - |
| 27 | Shopify Order No. on Doc. Line | Boolean | 20-29 | - | - |
| 28 | Customer Import From Shopify | Enum Shpfy Customer Import Range | 20-29 | - | - |
| 29 | Export Customer To Shopify | Boolean | 20-29 | Removed 27.0 | Replaced with action "Add Customer to Shopify" in Shopify Customers page. |
| 30 | Shopify Can Update Customer | Boolean | 20-29 | - | - |
| 31 | Can Update Shopify Customer | Boolean | 20-29 | - | - |
| 32 | Name Source | Enum Shpfy Name Source | 20-29 | - | - |
| 33 | Name 2 Source | Enum Shpfy Name Source | 20-29 | - | - |
| 34 | Contact Source | Enum Shpfy Name Source | 20-29 | - | - |
| 35 | County Source | Enum Shpfy County Source | 20-29 | - | - |
| 36 | Default Customer No. | Code[20] | 20-29 | - | - |
| 37 | UoM as Variant | Boolean | 20-29 | - | - |
| 38 | Option Name for UoM | Text[50] | 20-29 | - | - |
| 39 | Shopify Can Update Items | Boolean | 20-29 | - | - |
| 40 | Can Update Shopify Products | Boolean | 20-29 | - | - |
| 41 | Variant Prefix | Code[5] | 20-29 | - | - |
| 42 | Inventory Tracked | Boolean | 20-29 | - | - |
| 43 | Default Inventory Policy | Enum Shpfy Inventory Policy | 20-29 | - | - |
| 44 | Allow Background Syncs | Boolean | 20-29 | - | - |
| 47 | Tip Account | Code[20] | 20-29 | - | - |
| 48 | Sold Gift Card Account | Code[20] | 20-29 | - | - |
| 49 | Customer Mapping Type | Enum Shpfy Customer Mapping | 20-29 | - | - |
| 50 | Status for Created Products | Enum Shpfy Cr. Prod. Status Value | 20-29 | - | - |
| 51 | Action for Removed Products | Enum Shpfy Remove Product Action | 20-29 | - | - |
| 52 | Currency Code | Code[10] | 20-29 | - | - |
| 53 | Gen. Bus. Posting Group | Code[20] | 22-29 | - | - |
| 54 | VAT Bus. Posting Group | Code[20] | 22-29 | - | - |
| 55 | Tax Area Code | Code[20] | 22-29 | - | - |
| 56 | Tax Liable | Boolean | 22-29 | - | - |
| 57 | VAT Country/Region Code | Code[10] | 22-29 | - | - |
| 58 | Customer Posting Group | Code[20] | 22-29 | - | - |
| 59 | Prices Including VAT | Boolean | 22-29 | - | - |
| 60 | Auto Release Sales Orders | Boolean | 22-29 | - | - |
| 61 | Allow Line Disc. | Boolean | 22-29 | - | - |
| 62 | Customer Templ. Code | Code[20] | 22-29 | - | - |
| 63 | Item Templ. Code | Code[20] | 22-29 | - | - |
| 70 | Return and Refund Process | Enum Shpfy ReturnRefund ProcessType | 22-29 | - | - |
| 73 | Return Location | Code[10] | 22-29 | - | - |
| 75 | Refund Acc. non-restock Items | Code[20] | 22-29 | - | - |
| 76 | Refund Account | Code[20] | 22-29 | - | - |
| 100 | Collection Last Export Version | BigInteger | 20-25 | Removed 24.0 | Not used. Moved to "Shpfy Synchronization Info" table. |
| 101 | Collection Last Import Version | BigInteger | 20-25 | Removed 24.0 | Not used. Moved to "Shpfy Synchronization Info" table. |
| 102 | Product Last Export Version | BigInteger | 20-25 | Removed 24.0 | Not used. Moved to "Shpfy Synchronization Info" table. |
| 103 | Product Last Import Version | BigInteger | 20-25 | Removed 24.0 | Not used. Moved to "Shpfy Synchronization Info" table. |
| 104 | SKU Mapping | Enum Shpfy SKU Mapping | 20-29 | - | - |
| 105 | SKU Field Separator | Code[10] | 20-29 | - | - |
| 106 | Tax Area Priority | Enum Shpfy Tax By | 20-29 | - | - |
| 107 | Allow Outgoing Requests | Boolean | 20-29 | - | - |
| 108 | Order Created Webhooks | Boolean | 22-29 | - | - |
| 109 | Order Created Webhook User | Code[50] | 22-29 | - | - |
| 110 | Fulfillment Service Activated | Boolean | 21-29 | - | - |
| 111 | Order Created Webhook User Id | Guid | 23-29 | - | - |
| 112 | Order Created Webhook Id | Text[500] | 23-29 | - | - |
| 113 | Logging Mode | Enum Shpfy Logging Mode | 23-29 | - | - |
| 114 | Bulk Operation Webhook User Id | Guid | 23-29 | - | - |
| 115 | Bulk Operation Webhook Id | Text[500] | 23-29 | - | - |
| 116 | Sync Prices | Boolean | 23-29 | - | - |
| 117 | B2B Enabled | Boolean | 24-29 | Pending 29.0 | B2B features are now available on all Shopify plans. |
| 118 | Can Update Shopify Companies | Boolean | 24-29 | - | - |
| 119 | Default Contact Permission | Enum Shpfy Default Cont. Permission | 24-29 | - | - |
| 120 | Auto Create Catalog | Boolean | 24-29 | - | - |
| 121 | Company Import From Shopify | Enum Shpfy Company Import Range | 24-29 | - | - |
| 122 | Shopify Can Update Companies | Boolean | 24-29 | - | - |
| 123 | Auto Create Unknown Companies | Boolean | 24-29 | - | - |
| 124 | Send Shipping Confirmation | Boolean | 24-29 | - | - |
| 125 | Default Company No. | Code[20] | 24-29 | - | - |
| 126 | Company Mapping Type | Enum Shpfy Company Mapping | 24-29 | - | - |
| 127 | Replace Order Attribute Value | Boolean | 24-29 | Removed 27.0 | This feature will be enabled by default with version 27.0. |
| 128 | Return Location Priority | Enum Shpfy Return Location Priority | 25-29 | - | - |
| 129 | Weight Unit | Enum Shpfy Weight Unit | 25-29 | - | - |
| 130 | Product Metafields To Shopify | Boolean | 26-29 | - | - |
| 131 | Customer Metafields To Shopify | Boolean | 26-29 | - | - |
| 132 | Company Metafields To Shopify | Boolean | 26-29 | - | - |
| 133 | Order Attributes To Shopify | Boolean | 26-29 | - | - |
| 134 | Shpfy Comp. Tax Id Mapping | Enum Shpfy Comp. Tax Id Mapping | 26-29 | - | - |
| 135 | Currency Handling | Enum Shpfy Currency Handling | 28-29 | - | - |
| 136 | Use Shopify Order No. | Boolean | 29 | - | - |
| 137 | Process Returns As | Enum Sales Document Type | 29 | - | - |
| 200 | Shop Id | Integer | 20-29 | - | - |
| 201 | Items Mapped to Products | Boolean | 25-29 | Pending 26.0 | This setting is not used |
| 202 | Posted Invoice Sync | Boolean | 25-29 | - | - |
| 203 | Cash Roundings Account | Code[20] | 27-29 | - | - |
| 204 | Archive Processed Orders | Boolean | 27-29 | - | - |
| 205 | Create Invoices From Orders | Boolean | 27-29 | - | - |
| 206 | Fulfillment Service Updated | Boolean | 27-29 | Pending 28.0 | This field is no longer used. |
| 207 | Advanced Shopify Plan | Boolean | 28-29 | - | - |
| 208 | Find Mapping by Barcode | Boolean | 29 | - | - |
| 209 | Sync HS Code and Country | Boolean | 29 | - | - |

## Keys

| Name | Fields | Sum fields | Versions |
| --- | --- | --- | --- |
| PK, clustered | Code | - | 20-29 |
| Idx1 | Shop Id | - | 20-29 |
| Idx2 | Shopify URL | - | 24-29 |
| Idx3 | Enabled | - | 24-29 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| GetAccessToken | () | SecretText | internal | 20-26 | - | - |
| RequestAccessToken | () | - | internal | 20-29 | - | - |
| HasAccessToken | () | Boolean | internal | 20-29 | - | - |
| CalcShopId | () | - | internal | 20-29 | - | - |
| GetLastSyncTime | (Type: Enum "Shpfy Synchronization Type") | DateTime | internal | 20-29 | - | - |
| SetLastSyncTime | (Type: Enum "Shpfy Synchronization Type") | - | internal | 20-29 | - | - |
| SetLastSyncTime | (Type: Enum "Shpfy Synchronization Type"; ToDateTime: DateTime) | - | internal | 20-29 | - | - |
| CheckGLAccount | (GLAccount: Record "G/L Account") | - | internal | 21-29 | - | - |
| CopyPriceCalculationFieldsFromCustomerTemplate | (TemplateCode: Code[10]) | - | internal | 22-24 | - | - |
| TestConnection | () | Boolean | internal | 23-29 | - | - |
| GetEmptySyncTime | () | DateTime | internal | 23-29 | - | - |
| GetStoreName | () | Text | internal | 24-29 | - | - |
| GetB2BEnabled | () | Boolean | internal | 24-26 | - | - |
| CopyPriceCalculationFieldsFromCustomerTempl | (TemplateCode: Code[20]) | - | internal | 25-28 | - | - |
| GetShopWeightUnit | () | Enum Shpfy Weight Unit | internal | 25-29 | - | - |
| SyncCountries | () | - | internal | 25-29 | - | - |
| CheckApiVersionExpiryDate | (ApiVersion: Text; ApiVersionExpiryDateTime: DateTime) | - | internal | 25-29 | - | - |
| GetShopSettings | () | - | internal | 27-29 | - | - |
| UpdateFulfillmentService | () | - | internal | 27-29 | - | - |
| SetStoreName | (Store: Text) | - | internal | 28-29 | - | - |

## Trigger events

| Name | Parameters | ElementName | Docs |
| --- | --- | --- | --- |
| OnBeforeInsertEvent | (var Rec: Record "Shpfy Shop"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforeinsertevent-table-trigger/ |
| OnAfterInsertEvent | (var Rec: Record "Shpfy Shop"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onafterinsertevent-table-trigger/ |
| OnBeforeModifyEvent | (var Rec: Record "Shpfy Shop"; var xRec: Record "Shpfy Shop"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforemodifyevent-table-trigger/ |
| OnAfterModifyEvent | (var Rec: Record "Shpfy Shop"; var xRec: Record "Shpfy Shop"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onaftermodifyevent-table-trigger/ |
| OnBeforeDeleteEvent | (var Rec: Record "Shpfy Shop"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforedeleteevent-table-trigger/ |
| OnAfterDeleteEvent | (var Rec: Record "Shpfy Shop"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onafterdeleteevent-table-trigger/ |
| OnBeforeRenameEvent | (var Rec: Record "Shpfy Shop"; var xRec: Record "Shpfy Shop"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforerenameevent-table-trigger/ |
| OnAfterRenameEvent | (var Rec: Record "Shpfy Shop"; var xRec: Record "Shpfy Shop"; RunTrigger: Boolean) | '' | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onafterrenameevent-table-trigger/ |
| OnBeforeValidateEvent | (var Rec: Record "Shpfy Shop"; var xRec: Record "Shpfy Shop"; CurrFieldNo: Integer) | per field, ElementName: field name | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onbeforevalidateevent-table-trigger/ |
| OnAfterValidateEvent | (var Rec: Record "Shpfy Shop"; var xRec: Record "Shpfy Shop"; CurrFieldNo: Integer) | per field, ElementName: field name | https://jonas-paprotka.de/docs/dev-itpro/developer/triggers-auto/events/table/devenv-onaftervalidateevent-table-trigger/ |

## Source

Symbols: Microsoft.ShopifyConnector.symbols.ec255f57-31d0-4ca2-b751-f2fa7c745abb, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-11-20.
AL source 27: https://github.com/microsoft/BCApps, MIT, releases/27.x at ad459712441b2fe6cb0cf1c560563f8ec7188a93.
AL source 28: https://github.com/microsoft/BCApps, MIT, releases/28.x at 408a4cc8d3a4c54b60464cc14c964479facb9ba0.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at 4303e5e584d3aa5d9e98cbc615525a5396ad6ed7.

JOP-AL, 2026-11-20.
