---
id: object/table/30102
type: object
title: Table 30102 "Shpfy Shop"
summary: Table 30102 "Shpfy Shop" in Shopify (Microsoft.Integration.Shopify). 102 fields, 16 public procedures. Introduced in BC29, still in BC30, changed in BC30.
tier: official
language: en
tags:
  - table
  - shopify
versions:
  introduced: "29"
  last_changed: "30"
  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: 3452d4593ae2f692f13e93a22f321ffe583d49c74b96f5d14e8221aee79eed68
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Shopify/app/src/Base/Tables/ShpfyShop.Table.al
    title: src/Apps/W1/Shopify/app/src/Base/Tables/ShpfyShop.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/shopify/get-started
    - https://learn.microsoft.com/dynamics365/business-central/shopify/shopify-account
    - https://learn.microsoft.com/dynamics365/business-central/shopify/synchronize-inventory
    - https://learn.microsoft.com/dynamics365/business-central/shopify/troubleshoot
    - https://learn.microsoft.com/dynamics365/business-central/shopify/walkthrough-setting-up-and-using-shopify
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/online-store-with-shopify
    - topic/business-central/business-functionality/online-store-with-shopify/get-started-with-the-shopify-connector
    - topic/business-central/get-started/learn/business-process-walkthroughs
    - topic/dev-itpro/integration/integrating-with-shopify
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/11373
    - change/bcapps/10675
object_type: table
object_id: 30102
name: Shpfy Shop
caption: Shopify Shop
namespace: Microsoft.Integration.Shopify
app: Shopify
extends: null
first_version: "29"
last_version: "30"
present_in:
  - "29"
  - "30"
changed_in:
  - "30"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 102
  procedures: 19
  events: 0
  subscribers: 0
relations:
  out: 23
  referenced_by: 26
  pages: 3
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 30102 "Shpfy Shop"

> Table 30102 "Shpfy Shop" in Shopify (Microsoft.Integration.Shopify). 102 fields, 16 public procedures. Introduced in BC29, still in BC30, changed in BC30.

Shopify · Microsoft.Integration.Shopify · captioned "Shopify Shop" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Shopify/app/src/Base/Tables/ShpfyShop.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 30102 "Shpfy Shops"](../page/30102.md) (5 Learn pages), [Page 30101 "Shpfy Shop Card"](../page/30101.md) (4).

## Properties

| Property | Value |
|---|---|
| Caption | Shopify Shop |
| DataClassification | SystemMetadata |
| LookupPageId | Shpfy Shops |
| DrillDownPageId | Shpfy Shops |

## 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 | Code | Code[20] | Specifies a code to identify this Shopify Shop. | NotBlank |
| 2 | Shopify URL | Text[250] | Specifies the URL of the Shopify Admin you are connecting to. Use the format: "https://{store ID}.myshopify.com". You can build the URL by combining the store ID from the admin URL, e.g., "admin.shopify.com/store/{store ID}" and ".myshopify.com". Simply copy the URL from the Shopify Admin, and the c... |  |
| 3 | Enabled | Boolean | Specifies whether this Shopify shop connection is active. When enabled, the connector requests an access token, imports shop settings, and syncs countries. Ensure the Shopify Admin URL is configured first. |  |
| 5 | Log Enabled | Boolean | — | obsolete Removed 26.0; #if not CLEANSCHEMA26 |
| 6 | Customer Price Group | Code[10] | Specifies which Customer Price Group is used to calculate the prices in Shopify. | TableRelation [Table 6 "Customer Price Group"](../table/6.md) (Customer Price Group) |
| 7 | Customer Discount Group | Code[20] | Specifies which Customer Discount Group is used to calculate the prices in Shopify. | TableRelation [Table 340 "Customer Discount Group"](../table/340.md) (Customer Discount Group) |
| 8 | Shipping Charges Account | Code[20] | Specifies the G/L Account for posting the shipping cost. | TableRelation [Table 15 "G/L Account"](../table/15.md) ("G/L Account"."No.") |
| 9 | Language Code | Code[10] | Specifies the language of the Shopify Shop. | TableRelation [Table 8 "Language"](../table/8.md) |
| 10 | Sync Item | Option | Specifies in which direction items are synchronized. | OptionCaption: ,To Shopify,From Shopify |
| 11 | Item Template Code | Code[10] | — | obsolete Removed 25.0; #if not CLEANSCHEMA25; TableRelation [Table 8618 "Config. Template Header"](../table/8618.md) ("Config. Template Header".Code where("Table Id" = const(27))) |
| 12 | Sync Item Images | Option | Specifies whether you want to synchronize item images and in which direction. | OptionCaption: Disabled,To Shopify,From Shopify |
| 13 | Sync Item Extended Text | boolean | Specifies whether you want to synchronize extended texts to Shopify. |  |
| 14 | Sync Item Attributes | boolean | Specifies whether you want to synchronize item attributes to Shopify. |  |
| 15 | Sync Item Marketing Text | Boolean | Specifies whether you want to synchronize marketing texts to Shopify. |  |
| 21 | Auto Create Orders | Boolean | Specifies whether sales documents, such as orders and invoices, will be created automatically after import. |  |
| 22 | Auto Create Unknown Items | Boolean | Specifies if unknown items are automatically created in Business Central when synchronizing from Shopify. |  |
| 23 | Auto Create Unknown Customers | Boolean | Specifies if unknown customers are automatically created in Business Central when synchronizing from Shopify. |  |
| 24 | Customer Template Code | Code[10] | — | obsolete Removed 25.0; #if not CLEANSCHEMA25; TableRelation [Table 8618 "Config. Template Header"](../table/8618.md) ("Config. Template Header".Code where("Table Id" = const(18))) |
| 25 | Product Collection | Option | — | OptionCaption: ,Tax Group,VAT Prod. Posting Group |
| 27 | Shopify Order No. on Doc. Line | Boolean | Specifies whether the Shopify Order No. is shown in the document line. | DataClassification CustomerContent |
| 28 | Customer Import From Shopify | enum "Shpfy Customer Import Range" | Specifies how Shopify customers are synced to Business Central. If you choose none and there exists no mapping for that customer, the default customer will be used if exists. | enum [Enum 30105 "Shpfy Customer Import Range"](../enum/30105.md); DataClassification CustomerContent |
| 29 | Export Customer To Shopify | Boolean | Export Customer to Shopify <small>caption</small> | obsolete Removed 27.0; #if not CLEANSCHEMA27; DataClassification CustomerContent |
| 30 | Shopify Can Update Customer | Boolean | Specifies whether Shopify can update customers when synchronizing from Shopify. | DataClassification CustomerContent |
| 31 | Can Update Shopify Customer | Boolean | Specifies whether Business Central can update customers when synchronizing to Shopify. | DataClassification CustomerContent |
| 32 | Name Source | enum "Shpfy Name Source" | Specifies how to synchronize the name of the customer. If the value is empty then the value of Name 2 is taken, and Name 2 will be empty. | enum [Enum 30108 "Shpfy Name Source"](../enum/30108.md); DataClassification CustomerContent |
| 33 | Name 2 Source | enum "Shpfy Name Source" | Specifies how to synchronize Name 2 of the customer. | enum [Enum 30108 "Shpfy Name Source"](../enum/30108.md); DataClassification CustomerContent |
| 34 | Contact Source | enum "Shpfy Name Source" | Specifies how to synchronize the contact of the customer. | enum [Enum 30108 "Shpfy Name Source"](../enum/30108.md); DataClassification CustomerContent |
| 35 | County Source | enum "Shpfy County Source" | Specifies how to synchronize the county of the customer/company. | enum [Enum 30104 "Shpfy County Source"](../enum/30104.md); DataClassification CustomerContent |
| 36 | Default Customer No. | Code[20] | Specifies the default customer when not creating a customer for each webshop user. | TableRelation [Table 18 "Customer"](../table/18.md); DataClassification CustomerContent |
| 37 | UoM as Variant | Boolean | Specifies if you want to have the different unit of measures as an variant in Shopify. | DataClassification CustomerContent |
| 38 | Option Name for UoM | Text[50] | Specifies the variant option name for the unit of measure. | DataClassification CustomerContent |
| 39 | Shopify Can Update Items | Boolean | Specifies whether Shopify can update items when synchronizing from Shopify. | DataClassification CustomerContent |
| 40 | Can Update Shopify Products | Boolean | Specifies whether Business Central can update products when synchronizing to Shopify. | DataClassification CustomerContent |
| 41 | Variant Prefix | Code[5] | Specifies the prefix for variants. The variants you have defined in Shopify are created in Business Central based on an increasing number. | DataClassification CustomerContent |
| 42 | Inventory Tracked | Boolean | Specifies if you want to manage your inventory in Shopify based on Business Central. | DataClassification CustomerContent |
| 43 | Default Inventory Policy | Enum "Shpfy Inventory Policy" | Specifies if you want to prevent negative inventory. With "continue" the inventory can go negative, with "Deny" you want to prevent negative inventory. | enum [Enum 30125 "Shpfy Inventory Policy"](../enum/30125.md); DataClassification CustomerContent |
| 44 | Allow Background Syncs | Boolean | Specifies whether synchronization runs in the background. When enabled, you can continue working while large data sets synchronize. Disable for demos or troubleshooting to see real-time progress and receive detailed error messages. | DataClassification CustomerContent |
| 47 | Tip Account | Code[20] | Specifies the G/L Account for post the received tip amount. | TableRelation [Table 15 "G/L Account"](../table/15.md) ("G/L Account"."No.") |
| 48 | Sold Gift Card Account | Code[20] | Specifies the G/L Account for to post the sold gift card amounts. | TableRelation [Table 15 "G/L Account"](../table/15.md) ("G/L Account"."No.") |
| 49 | Customer Mapping Type | enum "Shpfy Customer Mapping" | Specifies how to map customers. | enum [Enum 30106 "Shpfy Customer Mapping"](../enum/30106.md); DataClassification CustomerContent |
| 50 | Status for Created Products | Enum "Shpfy Cr. Prod. Status Value" | Specifies the status of a product in Shopify when an item is create in Shopify via the sync. | enum [Enum 30129 "Shpfy Cr. Prod. Status Value"](../enum/30129.md); DataClassification CustomerContent |
| 51 | Action for Removed Products | Enum "Shpfy Remove Product Action" | Specifies the status of a product in Shopify via the sync when an item is blocked or removed from the Shopify Product in Business Central. | enum [Enum 30131 "Shpfy Remove Product Action"](../enum/30131.md); DataClassification CustomerContent |
| 52 | Currency Code | Code[10] | Specifies the currency used by your Shopify store. Leave blank if it matches the local currency (LCY). When set, exchange rates must be configured. This currency is used when calculating product prices to sync to Shopify and works together with the "Currency Handling" field in the Order section, whi... | TableRelation Currency.Code; DataClassification CustomerContent |
| 53 | Gen. Bus. Posting Group | Code[20] | Specifies which Gen. Bus. Posting Group is used to calculate the prices in Shopify. | TableRelation [Table 250 "Gen. Business Posting Group"](../table/250.md) (Gen. Business Posting Group); DataClassification CustomerContent |
| 54 | VAT Bus. Posting Group | Code[20] | Specifies which VAT. Bus. Posting Group is used to calculate the prices in Shopify. | TableRelation [Table 323 "VAT Business Posting Group"](../table/323.md) (VAT Business Posting Group); DataClassification CustomerContent |
| 55 | Tax Area Code | Code[20] | Specifies which Tax Area Code is used to calculate the prices in Shopify. | TableRelation [Table 318 "Tax Area"](../table/318.md) (Tax Area); DataClassification CustomerContent |
| 56 | Tax Liable | Boolean | Specifies if Tax Liable is used to calculate the prices in Shopify. | DataClassification CustomerContent |
| 57 | VAT Country/Region Code | Code[10] | Specifies which VAT Country/Region Code is used to calculate the prices in Shopify. | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region); DataClassification CustomerContent |
| 58 | Customer Posting Group | Code[20] | Specifies which Customer Posting Group is used to calculate the prices in Shopify. | TableRelation [Table 92 "Customer Posting Group"](../table/92.md) (Customer Posting Group); DataClassification CustomerContent |
| 59 | Prices Including VAT | Boolean | Specifies if the prices calculate for Shopify are Including VAT. | DataClassification CustomerContent |
| 60 | Auto Release Sales Orders | Boolean | Specifies if a sales document, such as order or invoice, should be released after creation. | DataClassification CustomerContent |
| 61 | Allow Line Disc. | Boolean | Specifies if line discount is allowed while calculating prices for Shopify. | DataClassification CustomerContent |
| 62 | Customer Templ. Code | Code[20] | Specifies which customer template to use when creating unknown customers. | TableRelation [Table 1381 "Customer Templ."](../table/1381.md) ("Customer Templ.".Code) |
| 63 | Item Templ. Code | Code[20] | Specifies which item template to use when creating unknown items. | TableRelation [Table 1382 "Item Templ."](../table/1382.md) ("Item Templ.".Code) |
| 70 | Return and Refund Process | Enum "Shpfy ReturnRefund ProcessType" | Specifies how returns and refunds from Shopify are handles in Business Central. The import process is always done within the import of a Shopify order. | enum [Enum 30139 "Shpfy ReturnRefund ProcessType"](../enum/30139.md); DataClassification CustomerContent |
| 73 | Return Location | Code[10] | Specifies location code for returned goods. | TableRelation [Table 14 "Location"](../table/14.md) (Location where("Use As In-Transit" = const(false))); DataClassification CustomerContent |
| 75 | Refund Acc. non-restock Items | Code[20] | Specifies a G/L Account No. for goods where you don't want to have an inventory correction. | TableRelation [Table 15 "G/L Account"](../table/15.md) ("G/L Account"."No."); DataClassification CustomerContent |
| 76 | Refund Account | Code[20] | Specifies a G/L Account No. for the difference in the total refunded amount and the total amount of the items. | TableRelation [Table 15 "G/L Account"](../table/15.md) ("G/L Account"."No."); DataClassification CustomerContent |
| 104 | SKU Mapping | Enum "Shpfy SKU Mapping" | Specifies if and based on what you want to create variants in Business Central. | enum [Enum 30132 "Shpfy SKU Mapping"](../enum/30132.md) |
| 105 | SKU Field Separator | Code[10] | Specifies a field separator for the SKU if you use "Item. No + Variant Code" to create a variant. |  |
| 106 | Tax Area Priority | Enum "Shpfy Tax By" | Specifies the tax area source and the sequence to be followed. | enum [Enum 30109 "Shpfy Tax By"](../enum/30109.md); DataClassification CustomerContent |
| 107 | Allow Outgoing Requests | Boolean | Specifies whether syncing data to Shopify is enabled. |  |
| 108 | Order Created Webhooks | Boolean | Specifies whether to automatically synchronize orders when they're created in Shopify. Shopify will notify Business Central that orders are ready. Business Central will schedule the Sync Orders from Shopify job on the Job Queue Entries page. The user account of the person who turns on this toggle wi... |  |
| 109 | Order Created Webhook User | Code[50] | Specifies the user who will run the Sync Orders from Shopify job on the Job Queue Entries page. This is the user who turned on the Auto Import Orders from Shopify toggle. | TableRelation User."User Name"; not editable; DataClassification EndUserIdentifiableInformation |
| 110 | Fulfillment Service Activated | Boolean | — |  |
| 111 | Order Created Webhook User Id | Guid | — | TableRelation User; not editable; DataClassification EndUserIdentifiableInformation |
| 112 | Order Created Webhook Id | Text[500] | — | not editable |
| 113 | Logging Mode | Enum "Shpfy Logging Mode" | Specifies whether the log is activated. | enum [Enum 30141 "Shpfy Logging Mode"](../enum/30141.md) |
| 114 | Bulk Operation Webhook User Id | Guid | — | TableRelation User; not editable; DataClassification EndUserIdentifiableInformation |
| 115 | Bulk Operation Webhook Id | Text[500] | — | not editable |
| 116 | Sync Prices | Boolean | Specifies if prices are synchronized to Shopify with product sync. |  |
| 117 | B2B Enabled | Boolean | — | obsolete Pending 29.0; #if not CLEANSCHEMA32 |
| 118 | Can Update Shopify Companies | Boolean | Specifies whether Business Central can update companies when synchronizing to Shopify. | DataClassification CustomerContent |
| 119 | Default Contact Permission | Enum "Shpfy Default Cont. Permission" | Specifies the default customer permission for new companies. | enum [Enum 30148 "Shpfy Default Cont. Permission"](../enum/30148.md); DataClassification CustomerContent |
| 120 | Auto Create Catalog | Boolean | Specifies whether a B2B catalog is automatically created for new companies. | DataClassification CustomerContent |
| 121 | Company Import From Shopify | Enum "Shpfy Company Import Range" | Specifies how Shopify companies are synced to Business Central. | enum [Enum 30149 "Shpfy Company Import Range"](../enum/30149.md); DataClassification CustomerContent |
| 122 | Shopify Can Update Companies | Boolean | Specifies whether Shopify can update companies when synchronizing from Shopify. | DataClassification CustomerContent |
| 123 | Auto Create Unknown Companies | Boolean | Specifies if unknown companies are automatically created in Business Central when synchronizing from Shopify. | DataClassification CustomerContent |
| 124 | Send Shipping Confirmation | Boolean | Specifies whether the customer is notified when the shipment is synchronized to Shopify. | DataClassification CustomerContent |
| 125 | Default Company No. | Code[20] | Specifies the default customer when not creating a company for each B2B company. | TableRelation [Table 18 "Customer"](../table/18.md); DataClassification CustomerContent |
| 126 | Company Mapping Type | Enum "Shpfy Company Mapping" | Specifies how to map companies. | enum [Enum 30151 "Shpfy Company Mapping"](../enum/30151.md); DataClassification CustomerContent |
| 127 | Replace Order Attribute Value | Boolean | — | obsolete Removed 27.0; #if not CLEANSCHEMA27 |
| 128 | Return Location Priority | Enum "Shpfy Return Location Priority" | Specifies the priority of the return location. | enum [Enum 30162 "Shpfy Return Location Priority"](../enum/30162.md); DataClassification CustomerContent |
| 129 | Weight Unit | Enum "Shpfy Weight Unit" | Specifies the weight unit of the Shopify Shop. | enum [Enum 30163 "Shpfy Weight Unit"](../enum/30163.md); DataClassification CustomerContent |
| 130 | Product Metafields To Shopify | Boolean | Specifies whether product/variant metafields are synchronized to Shopify. |  |
| 131 | Customer Metafields To Shopify | Boolean | Specifies whether customer metafields are synchronized to Shopify. |  |
| 132 | Company Metafields To Shopify | Boolean | Specifies whether company metafields are synchronized to Shopify. |  |
| 133 | Order Attributes To Shopify | Boolean | Specifies if Business Central document no. is synchronized to Shopify as order attribute. |  |
| 134 | Shpfy Comp. Tax Id Mapping | Enum "Shpfy Comp. Tax Id Mapping" | Specifies how to map Shopify Tax Id with Business Central. | enum [Enum 30166 "Shpfy Comp. Tax Id Mapping"](../enum/30166.md); DataClassification CustomerContent |
| 135 | Currency Handling | Enum "Shpfy Currency Handling" | Specifies which currency is used in Shopify orders processing. Using presentment currency may cause differences between amounts in LCY after posting documents. | enum [Enum 30171 "Shpfy Currency Handling"](../enum/30171.md) |
| 136 | Use Shopify Order No. | Boolean | Specifies whether the Shopify order number is used as the document number on the created Sales Order or Sales Invoice. You can overwrite the selection for the specific Shopify Order. |  |
| 137 | Process Returns As | Enum "Sales Document Type" | Specifies what type of document to create when processing returns. Credit Memo creates a sales credit memo. Return Order creates a sales return order. | enum [Enum 36 "Sales Document Type"](../enum/36.md); DataClassification CustomerContent |
| 200 | Shop Id | Integer | — |  |
| 201 | Items Mapped to Products | Boolean | Specifies if only the items that are mapped to Shopify products/Shopify variants are synchronized from Posted Sales Invoices to Shopify. | obsolete Pending 26.0; #if not CLEANSCHEMA29 |
| 202 | Posted Invoice Sync | Boolean | Specifies whether the posted sales invoices can be synchronized to Shopify. |  |
| 203 | Cash Roundings Account | Code[20] | Specifies the general ledger account to use when you post cash rounding differences from Shopify POS transactions. | TableRelation [Table 15 "G/L Account"](../table/15.md) ("G/L Account"."No.") |
| 204 | Archive Processed Orders | Boolean | Specifies whether Shopify orders are automatically archived when they are paid, fulfilled, and have associated sales documents with all lines shipped. |  |
| 205 | Create Invoices From Orders | Boolean | Specifies if fully fulfilled Shopify orders should be created as sales invoices. |  |
| 206 | Fulfillment Service Updated | Boolean | — | obsolete Pending 28.0; #if not CLEANSCHEMA31 |
| 207 | Advanced Shopify Plan | Boolean | — |  |
| 208 | Find Mapping by Barcode | Boolean | Specifies whether to use the barcode as a fallback when the primary SKU mapping strategy does not find a match. |  |
| 209 | Sync HS Code and Country | Boolean | Specifies whether the Tariff No. (as harmonized system code) and Country/Region of Origin Code are synchronized to Shopify variants. Required for AI channel distribution and customs-aware selling. |  |

## Keys

- PK: Code (clustered)
- Idx1: Shop Id
- Idx2: Shopify URL
- Idx3: Enabled

## Procedures

- `RequestAccessToken()` (internal)
- `HasAccessToken(): Boolean` (internal)
- `TestConnection(): Boolean` (internal)
- `GetStoreName(): Text` (internal)
- `SetStoreName(Store: Text)` (internal)
- `CalcShopId()` (internal): Calc Shop Id.
- `GetEmptySyncTime(): DateTime` (internal)
- `GetLastSyncTime(Type: Enum "Shpfy Synchronization Type"): DateTime` (internal)
- `SetLastSyncTime(Type: Enum "Shpfy Synchronization Type")` (internal)
- `SetLastSyncTime(Type: Enum "Shpfy Synchronization Type"; ToDateTime: DateTime)` (internal)
- `CheckGLAccount(GLAccount: Record "G/L Account")` (internal)
- `GetShopSettings()` (internal)
- `GetShopWeightUnit(): Enum "Shpfy Weight Unit"` (internal)
- `SyncCountries()` (internal)
- `CheckApiVersionExpiryDate(ApiVersion: Text; ApiVersionExpiryDateTime: DateTime)` (internal)
- `UpdateFulfillmentService()` (internal)

Plus 3 local procedures.

## Triggers

OnDelete

## Relations

- drill-down page [Page 30102 "Shpfy Shops"](../page/30102.md)
- lookup page [Page 30102 "Shpfy Shops"](../page/30102.md)
- Customer Templ. Code: TableRelation [Table 1381 "Customer Templ."](../table/1381.md)
- Item Templ. Code: TableRelation [Table 1382 "Item Templ."](../table/1382.md)
- Return Location: TableRelation [Table 14 "Location"](../table/14.md)
- Cash Roundings Account: TableRelation [Table 15 "G/L Account"](../table/15.md)
- Refund Acc. non-restock Items: TableRelation [Table 15 "G/L Account"](../table/15.md)
- Refund Account: TableRelation [Table 15 "G/L Account"](../table/15.md)
- Shipping Charges Account: TableRelation [Table 15 "G/L Account"](../table/15.md)
- Sold Gift Card Account: TableRelation [Table 15 "G/L Account"](../table/15.md)
- Tip Account: TableRelation [Table 15 "G/L Account"](../table/15.md)
- Default Company No.: TableRelation [Table 18 "Customer"](../table/18.md)
- Default Customer No.: TableRelation [Table 18 "Customer"](../table/18.md)
- Gen. Bus. Posting Group: TableRelation [Table 250 "Gen. Business Posting Group"](../table/250.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)
- Customer Price Group: TableRelation [Table 6 "Customer Price Group"](../table/6.md)
- Language Code: TableRelation [Table 8 "Language"](../table/8.md)
- Customer Template Code: TableRelation [Table 8618 "Config. Template Header"](../table/8618.md)
- Item Template Code: TableRelation [Table 8618 "Config. Template Header"](../table/8618.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)

## Referenced by

26 fields in 26 objects relate to this table (TableRelation or CalcFormula).

- [Table 30103 "Shpfy Synchronization Info"](../table/30103.md): Shop Code
- [Table 30107 "Shpfy Customer Template"](../table/30107.md): Shop Code
- [Table 30112 "Shpfy Shop Inventory"](../table/30112.md): Shop Code
- [Table 30113 "Shpfy Shop Location"](../table/30113.md): Shop Code
- [Table 30118 "Shpfy Order Header"](../table/30118.md): Shop Code
- [Table 30121 "Shpfy Orders to Import"](../table/30121.md): Shop Code
- [Table 30124 "Shpfy Payment Transaction"](../table/30124.md): Shop Code
- [Table 30125 "Shpfy Payout"](../table/30125.md): Shop Code
- [Table 30127 "Shpfy Product"](../table/30127.md): Shop Code
- [Table 30128 "Shpfy Shop Collection Map"](../table/30128.md): Shop Code
- [Table 30129 "Shpfy Variant"](../table/30129.md): Shop Code
- [Table 30131 "Shpfy Shipment Method Mapping"](../table/30131.md): Shop Code
- [Table 30133 "Shpfy Order Transaction"](../table/30133.md): Shop
- [Table 30134 "Shpfy Payment Method Mapping"](../table/30134.md): Shop Code
- [Table 30136 "Shpfy Staff Member"](../table/30136.md): Shop Code
- [Table 30137 "Shpfy Initial Import Line"](../table/30137.md): Shop Code
- [Table 30143 "Shpfy FulFillment Order Header"](../table/30143.md): Shop Code
- [Table 30148 "Shpfy Bulk Operation"](../table/30148.md): Shop Code
- [Table 30150 "Shpfy Company"](../table/30150.md): Shop Code
- [Table 30152 "Shpfy Catalog"](../table/30152.md): Shop Code
- [Table 30153 "Shpfy Catalog Price"](../table/30153.md): Shop Code
- [Table 30154 "Shpfy Suggest Payment"](../table/30154.md): Shop Code
- [Table 30155 "Shpfy Dispute"](../table/30155.md): Shop Code
- [Table 30156 "Shpfy Language"](../table/30156.md): Shop Code
- [Table 30158 "Shpfy Payment Terms"](../table/30158.md): Shop Code
- [Table 30400 "Shpfy Market Catalog Relation"](../table/30400.md): Shop Code

## Pages and codeunits on this table

- [Page 30101 "Shpfy Shop Card"](../page/30101.md) (source table)
- [Page 30102 "Shpfy Shops"](../page/30102.md) (source table)
- [Page 30142 "Shpfy Shop Selection"](../page/30142.md) (source table)
- [Codeunit 30107 "Shpfy Sync Countries"](../codeunit/30107.md) (codeunit runs on it)
- [Codeunit 30123 "Shpfy Sync Customers"](../codeunit/30123.md) (codeunit runs on it)
- [Codeunit 30167 "Shpfy Process Orders"](../codeunit/30167.md) (codeunit runs on it)
- [Codeunit 30178 "Shpfy Product Export"](../codeunit/30178.md) (codeunit runs on it)
- [Codeunit 30184 "Shpfy Sync Product Image"](../codeunit/30184.md) (codeunit runs on it)
- [Codeunit 30185 "Shpfy Sync Products"](../codeunit/30185.md) (codeunit runs on it)
- [Codeunit 30198 "Shpfy Sync Shop Locations"](../codeunit/30198.md) (codeunit runs on it)
- [Codeunit 30285 "Shpfy Sync Companies"](../codeunit/30285.md) (codeunit runs on it)
- [Codeunit 30458 "Shpfy Delete Webhook Subs."](../codeunit/30458.md) (codeunit runs on it)

## Recent changes

- 2026-09-18 [#11373 [Shopify] Improve shop navigation and background sync guidance](../../changes/bcapps/11373.md) (main, BC30, feature)
- 2026-08-27 [#10675 Temporarily suppress AS0072 (ObsoleteTag 29.0) on 10 Base App elements for v30 prep](../../changes/bcapps/10675.md) (main, BC30, fix)

## Across versions

- Present in: BC29-30
- Changed (declaration) in: BC30

## Deprecations

- procedure UpdateFulfillmentService: guarded (#if not CLEAN28)
- field Customer Template Code: Removed 25.0 (#if not CLEANSCHEMA25), "Replaced by "Customer Templ. Code""
- field Item Template Code: Removed 25.0 (#if not CLEANSCHEMA25), "Replaced by Item Templ. Code"
- field Items Mapped to Products: Pending 26.0 (#if not CLEANSCHEMA29), "This setting is not used"
- field Log Enabled: Removed 26.0 (#if not CLEANSCHEMA26), "Replaced with field "Logging Mode""
- field Export Customer To Shopify: Removed 27.0 (#if not CLEANSCHEMA27), "Replaced with action "Add Customer to Shopify" in Shopify Customers page."
- field Replace Order Attribute Value: Removed 27.0 (#if not CLEANSCHEMA27), "This feature will be enabled by default with version 27.0."
- field Fulfillment Service Updated: Pending 28.0 (#if not CLEANSCHEMA31), "This field is no longer used."
- field B2B Enabled: Pending 29.0 (#if not CLEANSCHEMA32), "B2B features are now available on all Shopify plans."

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 Shop")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.