Shopify is a subscription to a software service that offers you to create a website and use their shopping cart solution to sell, ship, and manage your products. Using their service, you can get access to an easy to use admin panel where you can add products, process orders and enter store data.
Connecting to Shopify¶
Mammoth allows you to connect to your Shopify account and get the data into Mammoth.
Select API & Databases from the ‘Add Data’ menu and click on Shopify.
Click on New Connection and enter your shop url. Click on connect and log in into your Shopify account.
Select the account and click on Next.
Once your Shopify account is connected with Mammoth, you will be presented with a list of tables and views in that database.
Select the desired table to get a preview.
Write a SQL query or run a test query and preview the result.
Click on Next.
After you have selected the table you want to work on, you get options to schedule data imports as discussed in the next section.
Scheduling your Data Pulls¶
You can start retrieving the data now or at a specific time. Further schedule the data imports to get the latest data from your Database at a certain time interval - just once, daily, weekly or monthly.
On every data pull from your Database, you also have options to - Replace all data, Add new data since data pull, or Replace with new data since new pull.
On choosing options Add new data since data pull or Replace with new data since new pull, you will get an option to choose a unique sequence column. Using this column, on refresh, Mammoth will pick up all the rows that have greater value in this column than the previous data pull.