Shopify
Shopify is an e-commerce platform that allows anyone to sell online, at their retail location and everywhere in between.
Data integration: Skyvia supports importing data to and from Shopify, exporting Shopify data to CSV files, replicating Shopify data to relational databases, and synchronizing Shopify data with other cloud apps and relational databases.
Query: Skyvia Query supports Shopify.
Establishing Connection
Skyvia supports two kinds of authentication for Shopify: Custom App and Access Token. The default and recommended way to connect is using Custom App authentication. The Access Token authentication uses legacy custom apps, which cannot be created in new Shopify accounts since January 1, 2026. It is kept for compatibility purposes for older Shopify accounts.
Getting Parameters for Custom App Authentication
To obtain the required parameters for Custom App authentication, you need to create an app in the Shopify Dev Dashboard. For this, perform the following steps:
-
In your Shopify store, click Apps > in the menu on the left.
-
Click App settings.
-
Click Develop apps on the top of the page.
-
Click Build app in Dev Dashboard.
-
In the Dev Dashboard, click Create App.
-
Under Start from Dev Dashboard, specify the new app name, for example, Skyvia, and click Create.
-
In the URLs section specify the App URL -
https://app.skyvia.com
-
In the Access section, specify the Redirect URLs -
https://app.skyvia.com/oauthcallback/shopify
-
Click Select Scopes.
-
Select scopes for the data you want to work with in Skyvia and click Done. We recommend selecting all Admin API scopes.
-
Click Release, then, in the opened dialog click Release again.
-
On the left, click Settings.
-
Under Credentials, copy Client ID and Secret.
Getting Access Token for Access Token Authentication
For the information on legacy custom apps and tokens for Access Token authentication, refer to https://help.shopify.com/en/manual/apps/app-types/custom-apps
Creating Connection Using Custom App Authentication
To create a connection to Shopify using Access Token authentication, perform the following steps:
-
Specify your Shopify Store full domain name, not just the store part of it. For example,
mystore-300.myshopify.comorhttps://mystore-300.myshopify.com
-
Paste Client ID and Client Secret.
-
Click Sign In with Shopify.
-
Sign in to Shopify.
-
Click Install.
Creating Connection Using Access Token Authentication
To create a connection to Shopify using Access Token authentication, perform the following steps:
-
Specify your Shopify Store full domain name, not just the store part of it. For example,
mystore-300.myshopify.comorhttps://mystore-300.myshopify.com -
In the Authentication list, select Access Token.
-
Paste your custom app Access Token.
Additional Connection Parameters
Metadata Cache
You can specify the period after which Metadata Cache expires.
Suppress Extended Requests
Shopify API does not return binary fields when querying multiple records. To query values of binary fields, Skyvia performs additional extended requests. Such API requests can be performed for each record of the corresponding object. However, this can decrease performance and significantly increase the number of API calls used.
To reduce the number of API calls, you can select the Suppress Extended Requests checkbox in Advanced Settings.
Connector Specifics
Filtering Specifics
Shopify API supports the following native filters:
| Object | Operator | Field |
|---|---|---|
| AbandonedCheckouts, Companies, Blogs, BusinessEntities, Files, InventoryItems, ScriptTags, WebhookSubscriptions | = |
Id |
<=, >=, >, <, = |
CreatedAt, UpdatedAt | |
| Articles | = |
Id, Blog_Id |
<=, >=, >, <, = |
PublishedAt, CreatedAt, UpdatedAt | |
| AutomaticDiscountNodes, CustomerAccountPages, CodeDiscountNodes, CustomerSavedSearches, DeliveryProfiles, DiscountNodes, DiscountRedeemCodeSavedSearches, Menus, PriceLists, ProductFeeds, Publications, Segments, ShopifyFunctions, Themes, UrlRedirects, Validations | = |
Id |
| BusinessEntities_ShopifyPaymentsAccount_BalanceTransactions, BusinessEntities_ShopifyPaymentsAccount_BankAccounts, BusinessEntities_ShopifyPaymentsAccount_Payouts | = |
BusinessEntity_Id |
| CarrierServices | = |
Id, Active |
| CashTrackingSessions | = |
Id, Location_Id |
<=, >=, >, <, = |
ClosingTime, OpeningTime | |
| CashTrackingSessions_Adjustments, CashTrackingSessions_CashTransactions | = |
CashTrackingSession_Id |
| Catalogs, Disputes, Markets | = |
Id, Status |
| CheckoutProfiles | = |
Id, IsPublished |
| Collections, Custom Objects | = |
Id |
<=, >=, >, <, = |
UpdatedAt | |
| Comments | = |
Id, Status |
<=, >=, >, <, = |
PublishedAt, CreatedAt, UpdatedAt | |
| Companies_ContactRoles, Companies_Contacts, Companies_MainContact_RoleAssignments | = |
Company_Id |
| CompanyLocations | = |
Id, Company_Id |
<=, >=, >, <, = |
CreatedAt, UpdatedAt | |
| CompanyLocations_RoleAssignments, CompanyLocations_StaffMemberAssignments | = |
CompanyLocation_Id |
| Customers | = |
Id, State |
<=, >=, >, <, = |
CreatedAt, UpdatedAt | |
| Customers_AddressesV2, Customers_StoreCreditAccounts | = |
Customer_Id |
| DeliveryCustomizations, PaymentCustomizations | = |
Id, Enabled |
| DeliveryProfiles_ProfileItems | = |
DeliveryProfile_Id |
| DraftOrders | = |
Id, Status, Customer_Id |
<=, >=, >, <, = |
CreatedAt, UpdatedAt | |
| DraftOrders_LineItems | = |
DraftOrder_Id |
| Events, GiftCards, Locations, SellingPlanGroups | = |
Id |
<=, >=, >, <, = |
CreatedAt | |
| FulfillmentOrders | = |
Id, Status |
<=, >=, >, <, = |
UpdatedAt | |
| FulfillmentOrders_Fulfillments, FulfillmentOrders_LineItems, FulfillmentOrders_LocationsForMove, FulfillmentOrders_MerchantRequests | = |
FulfillmentOrder_Id |
| GiftCards_Transactions | = |
GiftCard_Id |
| InventoryItems_CountryHarmonizedSystemCodes, InventoryItems_InventoryLevels | = |
InventoryItem_Id |
| Locations_InventoryLevels | = |
Location_Id |
| MarketingActivities | = |
Id, App_Id, Tactic |
<=, >=, >, <, = |
CreatedAt, UpdatedAt | |
| MarketingEvents | = |
Id, Type, App_Id |
| Markets_Catalogs | = |
Market_Id |
| Orders | = |
Id, Customer_Id, ReturnStatus, Test |
<=, >=, >, <, = |
CreatedAt, ProcessedAt, UpdatedAt | |
| Orders_Agreements, Orders_CustomerJourneySummary_Moments, Orders_CustomerJourneySummary_Moments, Orders_DiscountApplications, Orders_Fulfillments, Orders_LineItems, Orders_LocalizedFields, Orders_NonFulfillableLineItems, Orders_PaymentTerms_PaymentSchedules, Orders_Refunds, Orders_Returns, Orders_ShippingLines, Orders_Transactions | = |
Order_Id |
| Pages | = |
Id |
<=, >=, >, <, = |
PublishedAt, CreatedAt, UpdatedAt | |
| PriceLists_Prices, PriceLists_QuantityRules | = |
PriceList_Id |
| Products | = |
Id, Status, Category_Id, CombinedListingRole, HasOnlyDefaultVariant |
<=, >=, >, <, = |
PublishedAt, CreatedAt, UpdatedAt | |
| Products_BundleComponents | = |
Product_Id |
| ProductVariants | = |
Id, Product_Id, RequiresComponents, Taxable |
<=, >=, >, <, = |
UpdatedAt | |
| ProductVariants_Media, ProductVariants_ProductVariantComponents | = |
ProductVariants_Media |
| SellingPlanGroups_SellingPlans | = |
SellingPlanGroup_Id |
| StaffMembers | = |
Id, AccountType |
| TenderTransactions | = |
Id, Test |
<=, >=, >, <, = |
ProcessedAt | |
| Themes_Files | = |
Theme_Id |
Use these filters to improve performance and save API calls. You can use filters with other fields or operators, but it may increase API call usage.
Incremental Replication and Synchronization
Skyvia supports Replication with Incremental Updates for the following Shopify objects:
AbandonedCheckouts, Articles, AssignedFulfillmentOrders, Blogs, BusinessEntities_ShopifyPaymentsAccount_BankAccounts, CashTrackingSessions_CashTransactions, CheckoutProfiles, Collections, Comments, Companies, Companies_Contacts, Companies_MainContact_RoleAssignments, CompanyLocations, CompanyLocations_RoleAssignments, Customers, DraftOrders, Events, Files, FulfillmentOrders, FulfillmentOrders_Fulfillments, GiftCards, InventoryItems, InventoryItems_InventoryLevels, Locations, Locations_InventoryLevels, LocationsAvailableForDeliveryProfilesConnection, MarketingActivities, Orders, Orders_Fulfillments, Orders_Refunds, Orders_Transactions, Pages, Products, ProductVariants, ScriptTags, SellingPlanGroups, SellingPlanGroups_SellingPlans, Themes, Themes_Files, WebhookSubscriptions, Custom Objects.
Skyvia tracks only new records and doesn't track the updated records for the following objects: BusinessEntities_ShopifyPaymentsAccount_BankAccounts, CashTrackingSessions_CashTransactions, Events, Orders_Transactions, SellingPlanGroups, SellingPlanGroups_SellingPlans.
DML Operations Support
| Operation | Object |
|---|---|
| INSERT, UPDATE, DELETE | Articles, Blogs, CarrierServices, Catalogs, Collections, Companies, CompanyLocations, Customers, DeliveryCustomizations, DraftOrders, FulfillmentConstraintRules, Markets, Menus, Pages, PaymentCustomizations, PriceLists, Products, Publications, ScriptTags, Segments, SellingPlanGroups, Themes, UrlRedirects, Validations, WebhookSubscriptions,WebPresences, Custom Objects |
| INSERT, UPDATE | Files, GiftCards, MarketingActivities, Orders |
| INSERT, DELETE | CartTransforms, ProductFeeds |
| UPDATE, DELETE | DeliveryProfiles |
| UPDATE | ConsentPolicy, InventoryItems, ShopLocales |
| DELETE | Comments |
Complex Structured Objects
Some of the Shopify objects can store complex structured data. Skyvia represents this information in such tables as a JSON field Lines. You can Import data directly to the nested fields of such tables. To do this you can use our Nested Objects mapping feature in Import. Just select the Nested Objects checkbox in the integration to enable the feature. Then, in the mapping settings, you can map the fields of the nested items.
| Object | Field - Nested Object |
|---|---|
| AbandonedCheckouts | BillingAddress_Formatted - StringValueType, CustomAttributes - AttributeType, DiscountCodes - StringValueType, ShippingAddress_Formatted - StringValueType, TaxLines - TaxLineType |
| AbandonedCheckouts_LineItems | Components - AbandonedCheckoutLineItemComponentType, CustomAttributes - AttributeType |
| AdditionalFeeType | TaxLines - TaxLineType |
| AppDiscountTypes | App_Features - StringValueType |
| AppDiscountTypesNodes | App_Features - StringValueType |
| AppInstallations | AccessScopes - AccessScopeType, App_Features - StringValueType |
| Articles | Tags - StringValueType |
| AssignedFulfillmentOrders | FulfillmentHolds - FulfillmentHoldType, SupportedActions - FulfillmentOrderSupportedActionType |
| AutomaticDiscountSavedSearches | Filters - SearchFilterType |
| Blogs | Tags - StringValueType |
| BusinessEntities_ShopifyPaymentsAccount_BalanceTransactions | AdjustmentsOrders - ShopifyPaymentsAdjustmentOrderType |
| CashTrackingSessions_CashTransactions | Fees - TransactionFeeType |
| CodeDiscountSavedSearches | Filters - SearchFilterType |
| CollectionSavedSearches | Filters - SearchFilterType |
| CompanyLocations | BillingAddress_FormattedAddress - StringValueType, ShippingAddress_FormattedAddress - StringValueType |
| Customers | Addresses - MailingAddressType, CompanyContactProfiles - CompanyContactType, DefaultAddress_Formatted - StringValueType, Tags - StringValueType |
| Customers_AddressesV2 | Formatted - StringValueType |
| CustomerSavedSearches | Filters - SearchFilterType |
| DeliveryProfileLocationGroupType | CountriesInAnyZone - DeliveryCountryAndZoneType |
| DeliveryProfiles | ProfileLocationGroups - DeliveryProfileLocationGroupType |
| DiscountRedeemCodeSavedSearches | Filters - SearchFilterType |
| DraftOrderPlatformDiscountType | Allocations - DraftOrderPlatformDiscountAllocationType |
| DraftOrders | BillingAddress_Formatted - StringValueType, CustomAttributes - AttributeType, DiscountCodes - StringValueType, PlatformDiscounts - DraftOrderPlatformDiscountType, ShippingAddress_Formatted - StringValueType, Tags - StringValueType, TaxLines - TaxLineType |
| DraftOrders_LineItems | CustomAttributes - AttributeType, CustomAttributesV2 - TypedAttributeType, TaxLines - TaxLineType |
| DraftOrderSavedSearches | Filters - SearchFilterType |
| DutyType | TaxLines - TaxLineType |
| Files | FileErrors - FileErrorType |
| FileSavedSearches | Filters - SearchFilterType |
| FulfillmentHoldType | HeldByApp_Features - StringValueType |
| FulfillmentOrderLineItemFinancialSummaryType | DiscountAllocations - FinancialSummaryDiscountAllocationType |
| FulfillmentOrders | FulfillmentHolds - FulfillmentHoldType, SupportedActions - FulfillmentOrderSupportedActionType |
| FulfillmentOrders_Fulfillments | TrackingInfo - FulfillmentTrackingInfoType |
| FulfillmentOrders_LineItems | FinancialSummaries - FulfillmentOrderLineItemFinancialSummaryType, Warnings - FulfillmentOrderLineItemWarningType |
| Locations | Address_Formatted - StringValueType, SuggestedAddresses - LocationSuggestedAddressType |
| LocationsAvailableForDeliveryProfilesConnection | Address_Formatted - StringValueType, SuggestedAddresses - LocationSuggestedAddressType |
| LocationSuggestedAddressType | Formatted - StringValueType |
| MailingAddressType | Formatted - StringValueType |
| MarketingActivities | App_Features - StringValueType |
| MarketingEvents | App_Features - StringValueType |
| MenuItemType | Tags - StringValueType |
| Menus | Items - MenuItemType |
| MetafieldDefinitionTypes | SupportedValidations - MetafieldDefinitionSupportedValidationType |
| Orders | AdditionalFees - AdditionalFeeType, Alerts - ResourceAlertType, BillingAddress_Formatted - StringValueType, ChannelInformation_App_Features - StringValueType, CurrentTaxLines - TaxLineType, CustomAttributes - AttributeType, DiscountCodes - StringValueType, DisplayAddress_Formatted - StringValueType, Disputes - OrderDisputeSummaryType, MerchantEditableErrors - StringValueType, PaymentGatewayNames - StringValueType, ShippingAddress_Formatted - StringValueType, Tags - StringValueType, TaxLines - TaxLineType |
| Orders_Agreements | App_Features - StringValueType |
| Orders_Fulfillments | TrackingInfo - FulfillmentTrackingInfoType |
| Orders_LineItems | Contract_App_Features - StringValueType, CustomAttributes - AttributeType, DiscountAllocations - DiscountAllocationType, Duties - DutyType, TaxLines - TaxLineType |
| Orders_NonFulfillableLineItems | Contract_App_Features - StringValueType, CustomAttributes - AttributeType, DiscountAllocations - DiscountAllocationType, Duties - DutyType, TaxLines - TaxLineType |
| Orders_Refunds | Duties - RefundDutyType |
| Orders_Returns | ReturnShippingFees - ReturnShippingFeeType |
| Orders_ShippingLines | DiscountAllocations - DiscountAllocationType, TaxLines - TaxLineType |
| Orders_Transactions | Fees - TransactionFeeType |
| OrderSavedSearches | Filters - SearchFilterType |
| ProductBundleComponentOptionSelectionType | ComponentOption_Values - StringValueType, ParentOption_Values - StringValueType, Values - ProductBundleComponentOptionSelectionValueType |
| ProductOptionType | OptionValues - ProductOptionValueType, Values - StringValueType |
| Products | Category_AncestorIds - IdType, Category_ChildrenIds - IdType, Options - ProductOptionType, Tags - StringValueType, TestRingSize - StringValueType, TestRingSizeSm - DoubleValueType, Color - IdType |
| Products_BundleComponents | OptionSelections - ProductBundleComponentOptionSelectionType, QuantityOption_ParentOption_Values - StringValueType |
| Products_Media | MediaErrors - MediaErrorType, MediaWarnings - MediaWarningType, On_ExternalVideo_FileErrors - FileErrorType, On_MediaImage_FileErrors - FileErrorType, On_Model3d_FileErrors - FileErrorType, On_Model3d_Sources - Model3dSourceType, On_Video_FileErrors - FileErrorType, On_Video_Sources - VideoSourceType |
| ProductSavedSearches | Filters - SearchFilterType |
| ProductVariants | SelectedOptions - SelectedOptionType |
| ProductVariants_Media | MediaErrors - MediaErrorType, MediaWarnings - MediaWarningType, On_ExternalVideo_FileErrors - FileErrorType, On_MediaImage_FileErrors - FileErrorType, On_Model3d_FileErrors - FileErrorType, On_Model3d_Sources - Model3dSourceType, On_Video_FileErrors - FileErrorType, On_Video_Sources - VideoSourceType |
| ResourceAlertType | Actions - ResourceAlertActionType |
| SellingPlanGroups | Options - StringValueType |
| SellingPlanGroups_SellingPlans | Options - StringValueType |
| ShopifyFunctions | App_Features - StringValueType |
| StaffMembers | Initials - StringValueType |
| StandardMetafieldDefinitionTemplates | Validations - MetafieldDefinitionValidationType |
| UrlRedirectSavedSearches | Filters - SearchFilterType |
| WebhookSubscriptions | IncludeFields - StringValueType, MetafieldNamespaces - StringValueType |
| WebPresences | Domain_Localization_AlternateLocales - StringValueType, RootUrls - MarketWebPresenceRootUrlType |
Supported Actions
Skyvia supports all the common actions for Shopify.