Shopify V2
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.
Backup: Skyvia Backup supports Shopify backup.
Query: Skyvia Query supports Shopify.
Establishing Connection
To create a connection to Shopify V2, specify the store and access token.
Getting Access Token for Admin API Access Token Authentication
To obtain the access token, you need to create a custom app. Sign in to your admin Shopify account and perform the following steps:
-
In the menu on the left, click Apps.
-
Click App and sales channel settings.
-
On the top of the page, click Develop apps.
-
On the top of the page, click Create app.
-
Specify custom app name, for example, SkyviaCustomApp.
- Select the App developer account and click Create app.
-
Click Configure Admin API scopes.
- Select checkboxes for the scopes you want to work with. You may select all the scopes.
- Below the list of scopes, click Save.
- Click the API Credentials tab.
-
On this tab, under Access tokens, click Install app.
- Click Install to confirm the app installation.
-
Click Reveal token once.
- Copy the revealed token and store it somewhere safe.
Creating Connection
To establish connection using Admin API 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 box, select Admin API Access Token.
-
Paste your custom app Access Token.
Connector Specifics
Filtering Specifics
Campaign Monitor 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 | = |
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 |
| Disputes | = |
Id, Status |
| 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 | = |
Id, Status |
| 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.