Table 30102 "Shpfy Shop"

Shopify · Microsoft.Integration.Shopify · captioned “Shopify Shop” · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 30102 “Shpfy Shops” (5 Learn pages), Page 30101 “Shpfy Shop Card” (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” (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” (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” (“G/L Account”.“No.”)
9	Language Code	Code[10]	Specifies the language of the Shopify Shop.	TableRelation Table 8 “Language”
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” (“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” (“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”; DataClassification CustomerContent
29	Export Customer To Shopify	Boolean	Export Customer to Shopify caption	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”; 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”; DataClassification CustomerContent
34	Contact Source	enum “Shpfy Name Source”	Specifies how to synchronize the contact of the customer.	enum Enum 30108 “Shpfy Name Source”; 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”; 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”; 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”; 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” (“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” (“G/L Account”.“No.”)
49	Customer Mapping Type	enum “Shpfy Customer Mapping”	Specifies how to map customers.	enum Enum 30106 “Shpfy Customer Mapping”; 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”; 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”; 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” (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” (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” (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” (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” (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.” (“Customer Templ.”.Code)
63	Item Templ. Code	Code[20]	Specifies which item template to use when creating unknown items.	TableRelation Table 1382 “Item Templ.” (“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”; DataClassification CustomerContent
73	Return Location	Code[10]	Specifies location code for returned goods.	TableRelation Table 14 “Location” (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” (“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” (“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”
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”; 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”
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”; 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”; 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”; DataClassification CustomerContent
126	Company Mapping Type	Enum “Shpfy Company Mapping”	Specifies how to map companies.	enum Enum 30151 “Shpfy Company Mapping”; 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”; DataClassification CustomerContent
129	Weight Unit	Enum “Shpfy Weight Unit”	Specifies the weight unit of the Shopify Shop.	enum Enum 30163 “Shpfy Weight Unit”; 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”; 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”
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”; 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” (“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”
lookup page Page 30102 “Shpfy Shops”
Customer Templ. Code: TableRelation Table 1381 “Customer Templ.”
Item Templ. Code: TableRelation Table 1382 “Item Templ.”
Return Location: TableRelation Table 14 “Location”
Cash Roundings Account: TableRelation Table 15 “G/L Account”
Refund Acc. non-restock Items: TableRelation Table 15 “G/L Account”
Refund Account: TableRelation Table 15 “G/L Account”
Shipping Charges Account: TableRelation Table 15 “G/L Account”
Sold Gift Card Account: TableRelation Table 15 “G/L Account”
Tip Account: TableRelation Table 15 “G/L Account”
Default Company No.: TableRelation Table 18 “Customer”
Default Customer No.: TableRelation Table 18 “Customer”
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Tax Area Code: TableRelation Table 318 “Tax Area”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
Customer Discount Group: TableRelation Table 340 “Customer Discount Group”
Customer Price Group: TableRelation Table 6 “Customer Price Group”
Language Code: TableRelation Table 8 “Language”
Customer Template Code: TableRelation Table 8618 “Config. Template Header”
Item Template Code: TableRelation Table 8618 “Config. Template Header”
VAT Country/Region Code: TableRelation Table 9 “Country/Region”
Customer Posting Group: TableRelation Table 92 “Customer Posting Group”

Referenced by

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

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

Pages and codeunits on this table

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

Recent changes

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

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.

Across versions

Neighbourhood 57 connected objects and pages