Table 30102 Shpfy Shop

Shopify Connector, Microsoft.Integration.Shopify
List17181920212223242526272829
Fields521716610634
Keys2
Procedures11235411

In 29 4 added, 1 gone

field(136; "Use Shopify Order No."; Boolean)new in 29
added
field(137; "Process Returns As"; Enum "Sales Document Type")new in 29
added
field(208; "Find Mapping by Barcode"; Boolean)new in 29
added
field(209; "Sync HS Code and Country"; Boolean)new in 29
added
internal CopyPriceCalculationFieldsFromCustomerTempl(TemplateCode: Code[20])25 to 28
gone

In 28 1 marked obsolete, 3 added

field(117; "B2B Enabled"; Boolean)new in 24
marked Pending, tag 29.0: B2B features are now available on all Shopify plans.
field(135; "Currency Handling"; Enum "Shpfy Currency Handling")new in 28
added
field(207; "Advanced Shopify Plan"; Boolean)new in 28
added
internal SetStoreName(Store: Text)new in 28
added

In 27 2 state changed, 6 added, 2 gone

field(29; "Export Customer To Shopify"; Boolean)new in 20
Pending to Removed, tag 27.0: Replaced with action "Add Customer to Shopify" in Shopify Customers page.
field(127; "Replace Order Attribute Value"; Boolean)new in 24
Pending to Removed, tag 27.0: This feature will be enabled by default with version 27.0.
field(203; "Cash Roundings Account"; Code[20])new in 27
added
field(204; "Archive Processed Orders"; Boolean)new in 27
added
field(205; "Create Invoices From Orders"; Boolean)new in 27
added
field(206; "Fulfillment Service Updated"; Boolean)new in 27
added
internal GetAccessToken(): SecretText20 to 26changed in 24
gone
internal GetB2BEnabled(): Boolean24 to 26
gone
internal GetShopSettings()new in 27
added
internal UpdateFulfillmentService()new in 27
added

In 26 1 state changed, 4 gone, 5 added

field(5; "Log Enabled"; Boolean)new in 20
Pending to Removed, tag 26.0: Replaced with field "Logging Mode"
field(100; "Collection Last Export Version"; BigInteger)20 to 25
gone
field(101; "Collection Last Import Version"; BigInteger)20 to 25
gone
field(102; "Product Last Export Version"; BigInteger)20 to 25
gone
field(103; "Product Last Import Version"; BigInteger)20 to 25
gone
field(130; "Product Metafields To Shopify"; Boolean)new in 26
added
field(131; "Customer Metafields To Shopify"; Boolean)new in 26
added
field(132; "Company Metafields To Shopify"; Boolean)new in 26
added
field(133; "Order Attributes To Shopify"; Boolean)new in 26
added
field(134; "Shpfy Comp. Tax Id Mapping"; Enum "Shpfy Comp. Tax Id Mapping")new in 26
added

In 25 2 state changed, 8 added, 1 gone

field(11; "Item Template Code"; Code[10])new in 20
Pending to Removed, tag 25.0: Replaced by Item Templ. Code
field(24; "Customer Template Code"; Code[10])new in 20
Pending to Removed, tag 25.0: Replaced by "Customer Templ. Code"
field(128; "Return Location Priority"; Enum "Shpfy Return Location Priority")new in 25
added
field(129; "Weight Unit"; Enum "Shpfy Weight Unit")new in 25
added
field(201; "Items Mapped to Products"; Boolean)new in 25
added
field(202; "Posted Invoice Sync"; Boolean)new in 25
added
internal CopyPriceCalculationFieldsFromCustomerTemplate(TemplateCode: Code[10])22 to 24
gone
internal CopyPriceCalculationFieldsFromCustomerTempl(TemplateCode: Code[20])25 to 28
added
internal GetShopWeightUnit(): Enum "Shpfy Weight Unit"new in 25
added
internal SyncCountries()new in 25
added
internal CheckApiVersionExpiryDate(ApiVersion: Text; ApiVersionExpiryDateTime: DateTime)new in 25
added

In 24 1 marked obsolete, 4 state changed, 15 added, 1 changed

field(29; "Export Customer To Shopify"; Boolean)new in 20
marked Pending, tag 24.0: Replaced with action "Add Customer to Shopify" in Shopify Customers page.
field(100; "Collection Last Export Version"; BigInteger)20 to 25
Pending to Removed, tag 24.0: Not used. Moved to "Shpfy Synchronization Info" table.
field(101; "Collection Last Import Version"; BigInteger)20 to 25
Pending to Removed, tag 24.0: Not used. Moved to "Shpfy Synchronization Info" table.
field(102; "Product Last Export Version"; BigInteger)20 to 25
Pending to Removed, tag 24.0: Not used. Moved to "Shpfy Synchronization Info" table.
field(103; "Product Last Import Version"; BigInteger)20 to 25
Pending to Removed, tag 24.0: Not used. Moved to "Shpfy Synchronization Info" table.
field(117; "B2B Enabled"; Boolean)new in 24
added
field(118; "Can Update Shopify Companies"; Boolean)new in 24
added
field(119; "Default Contact Permission"; Enum "Shpfy Default Cont. Permission")new in 24
added
field(120; "Auto Create Catalog"; Boolean)new in 24
added
field(121; "Company Import From Shopify"; Enum "Shpfy Company Import Range")new in 24
added
field(122; "Shopify Can Update Companies"; Boolean)new in 24
added
field(123; "Auto Create Unknown Companies"; Boolean)new in 24
added
field(124; "Send Shipping Confirmation"; Boolean)new in 24
added
field(125; "Default Company No."; Code[20])new in 24
added
field(126; "Company Mapping Type"; Enum "Shpfy Company Mapping")new in 24
added
field(127; "Replace Order Attribute Value"; Boolean)new in 24
added
key(Idx2; "Shopify URL")new in 24
added
key(Idx3; Enabled)new in 24
added
internal GetAccessToken(): SecretText20 to 26changed in 24
changed, was internal GetAccessToken(): Text
internal GetStoreName(): Textnew in 24
added
internal GetB2BEnabled(): Boolean24 to 26
added

In 23 1 marked obsolete, 8 added

field(5; "Log Enabled"; Boolean)new in 20
marked Pending, tag 23.0: Replaced with field "Logging Mode"
field(111; "Order Created Webhook User Id"; Guid)new in 23
added
field(112; "Order Created Webhook Id"; Text[500])new in 23
added
field(113; "Logging Mode"; Enum "Shpfy Logging Mode")new in 23
added
field(114; "Bulk Operation Webhook User Id"; Guid)new in 23
added
field(115; "Bulk Operation Webhook Id"; Text[500])new in 23
added
field(116; "Sync Prices"; Boolean)new in 23
added
internal TestConnection(): Booleannew in 23
added
internal GetEmptySyncTime(): DateTimenew in 23
added

In 22 2 marked obsolete, 19 added, 1 changed

field(11; "Item Template Code"; Code[10])new in 20
marked Pending, tag 22.0: Replaced by Item Templ. Code
field(15; "Sync Item Marketing Text"; Boolean)new in 22
added
field(24; "Customer Template Code"; Code[10])new in 20
marked Pending, tag 22.0: Replaced by "Customer Templ. Code"
field(53; "Gen. Bus. Posting Group"; Code[20])new in 22
added
field(54; "VAT Bus. Posting Group"; Code[20])new in 22
added
field(55; "Tax Area Code"; Code[20])new in 22
added
field(56; "Tax Liable"; Boolean)new in 22
added
field(57; "VAT Country/Region Code"; Code[10])new in 22
added
field(58; "Customer Posting Group"; Code[20])new in 22
added
field(59; "Prices Including VAT"; Boolean)new in 22
added
field(60; "Auto Release Sales Orders"; Boolean)new in 22
added
field(61; "Allow Line Disc."; Boolean)new in 22
added
field(62; "Customer Templ. Code"; Code[20])new in 22
added
field(63; "Item Templ. Code"; Code[20])new in 22
added
field(70; "Return and Refund Process"; Enum "Shpfy ReturnRefund ProcessType")new in 22
added
field(73; "Return Location"; Code[10])new in 22
added
field(75; "Refund Acc. non-restock Items"; Code[20])new in 22
added
field(76; "Refund Account"; Code[20])new in 22
added
field(104; "SKU Mapping"; Enum "Shpfy SKU Mapping")new in 20changed in 22
changed, was field(104; "SKU Mapping"; Enum "Shpfy SKU Mappging")
field(108; "Order Created Webhooks"; Boolean)new in 22
added
field(109; "Order Created Webhook User"; Code[50])new in 22
added
internal CopyPriceCalculationFieldsFromCustomerTemplate(TemplateCode: Code[10])22 to 24
added

In 21 4 marked obsolete, 2 added

field(100; "Collection Last Export Version"; BigInteger)20 to 25
marked Pending, tag 21.0: Not used. Moved to "Shpfy Synchronization Info" table.
field(101; "Collection Last Import Version"; BigInteger)20 to 25
marked Pending, tag 21.0: Not used. Moved to "Shpfy Synchronization Info" table.
field(102; "Product Last Export Version"; BigInteger)20 to 25
marked Pending, tag 21.0: Not used. Moved to "Shpfy Synchronization Info" table.
field(103; "Product Last Import Version"; BigInteger)20 to 25
marked Pending, tag 21.0: Not used. Moved to "Shpfy Synchronization Info" table.
field(110; "Fulfillment Service Activated"; Boolean)new in 21
added
internal CheckGLAccount(GLAccount: Record "G/L Account")new in 21
added