Start Free Trial   Support

Shopify

Overview

The Lyftron Provider for Shopify offers the most natural way to access Shopify data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing Shopify data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s Shopify data provider and automatically build your data migration pipelines in minutes, not months

The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Key Features

  • Comprehensive Delta load mechanism.
  • Real-time access to Shopify.
  • Comprehensive full support of ANSI Sql to query data with ease.
  • Collaborative query processing.

Prerequisites

The user must have credentials for Shopify, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron

Connecting to Shopify

To make use of all the features of the provider, provide the AppId, Password, and ShopUrl connection properties.

Create a Private App

You can follow the procedure below to register an app and obtain the client credentials such as the AppId, Password, and ShopUrl:

  1. Log in to your Shopify from the admin page and go to Apps.
  2. Click Manage Private Apps.
  3. Click Create New Private App.
  4. In the Description section, enter the app name and contact email.
  5. In Permissions section, choose the areas of your store you want to grant to your app. (The permissions required by our provider to use all the tables and views are: read_customers, write_customers, write_draft_orders, read_draft_orders, read_fulfillments, write_fulfillments, write_inventory, read_inventory, write_marketing_events, read_marketing_events, read_orders, write_orders, read_price_rules, write_price_rules, read_product_listings, write_product_listings, read_products, write_products, read_shopify_payments_payouts)
  6. Go back to your private apps. The API Key (AppId) of your application and its password (Password) are listed for the app.

Authenticate to Shopify

 After setting the following connection properties, you are ready to connect:

  • ShopUrl: Set this to the full URL of your shop (https://yourshopname.myshopify.com).
  • AppId: Set this to the API Key in your private app settings.
  • Password: Set this to the password in your private app settings.

For more detailed information on service and user account connectivity click  Shopify Advanced Settings

Establishing a Connection with Lyftron's Quickstart Steps

Create your Shopify connection with Lyftron by following the 5 easy steps show below:

Step1. Add your connection

Click on Connect section on the left panel →  Click on Add Connection button

Step2. Select your connector

In the connector selection panel, search and click Shopify for your connection 

Step3. Enter your connection details

In the Connection String section enter the values of the below parameters. The following connection string is required to establish Shopify connection with Lyftron.

'ShopUrl=[your_shop_URL];AppId=[your_api_key];Password=[your_password]; Timeout=300;'
 
Key Value Field
Connection Name Enter your connection details Required
AppId Enter the AppId Required
ShopUrl Enter the ShopUrl Required
Password Enter the Password Required
Logfile** Use the logfile option to debug your job and provide your connection name to generate the log file.  [ConnectionConfigurationPath]\Connection_name_log.tx Optional
Verbosity** Choose verbosity 1-5 based on the severity of debugging Optional


** For more information, check the Lyftron logging and debugging section.

If you want more detailed information about how to establish a connection with Lyftron, click on Lyftron Connection Quick Start guide.

Step4. Test your connection

Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add Logfile and Verbosity parameters and check the Lyftron logging and debugging section, to debug the error.

 Step5. Save your connection

Hurray! Now you have successfully connected with the Lyftron Shopify connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize and Share your data.

Data Model

You can work with all the tables in your account using the provider. The provider connects to Shopify and gets the list of tables and the metadata for the tables by calling the appropriate Web services. Any changes you make to your Wasabi account, such as adding a new table, adding new columns, or changing the data type of a column, will immediately be reflected when you connect using the provider.

Name Type Description
CollectionListings Tables   Query and delete information regarding different collects.
Collects Tables   Query, insert, or delete information regarding different collects.
Countries Tables   Create, select, update, and delete information regarding countries.
CustomCollections Tables   Query, insert, update, or delete information regarding different custom collections.
CustomerAddresses Tables   Create, update, delete, and query customer addresses.
Customers Tables   Create, update, delete, and query customers.
DiscountCodes Tables   Create, select, update, and delete information regarding discount codes.
DraftOrders Tables   Create, update, delete, and query draft orders.
FulfillmentEvents Tables   Create, delete, and query information regarding fulfillment events.
Fulfillments Tables   Create, update, and query fulfillments.
FulfillmentServices Tables   Query, create, update, and delete information regarding different fulfillment services.
InventoryItems Tables   Query and update information regarding different inventory items.
InventoryLevels Tables   Query, create, and update information regarding different inventory levels.
MarketingEvents Tables   Create, update, delete, and query marketing events.
OrderRisks Tables   Create, update, delete, and query order risks.
Orders Tables   Create, update, delete, and query orders.
OrderTransactions Tables   Create and query transactions.
PriceRules Tables   Create, update, delete, and query price rules.
ProductListings Tables   Query and delete product listings.
Products Tables   Create, update, delete, and query products.
ProductVariants Tables   Query and delete product listings.
Provinces Tables   Query and update information regarding different provinces.
Refunds Tables   Create and query refunds.
SmartCollections Tables   Query, insert, update, or delete information regarding different smart collections.
AbandonedCheckouts Views  Query abandoned checkouts.
Events Views  Retrieve events which have happened in your shop.
Locations Views  Retrieve information regarding store locations.
NoteAttributes Views  Query note attributes belonging to an order or draft order.
OrderItemProperties Views  Query order item properties.
OrdersItems Views  Query order items.
Payouts Views  Retrieves a list of all payouts ordered by payout date, with the most recent being first.
PayoutTransactions Views  Retrieves a list of all balance transactions ordered by processing time, with the most recent being first.
ProductOptions Views  Query product options.
RefundAdjustments Views  Create and query transactions.
RefundsItems Views  Get data on OrdersItems that have been refunded.
ShippingItems Views  Query order shipping.
ShippingZones Views  Retrieve information regarding shipping zones.
Shop Views  Contains general settings and information about the shop.
TaxItems Views  Query order taxes.

Advanced Settings

To view a detailed advanced settings options, go to Shopify Advanced Settings. Complete list of the parameters you can configure in the connection string can be found by clicking Connection String Parameters.