Import your store data from Shopify
Using the Shopify Import, you can pull in the following data:
More options are being added now!
To start, you will need your Shopify shop URL. Take a look at your Shopify store, and you may see something like this: awesome-socks.myshopfy.com - from that you would just need to copy awesome-socks to put into the first authorization prompt:
After that, you will be shown a window from Shopify, asking for you to authorize Parabola to access your Shopify store. If you have done this before, and/or if you are logged into Shopify in your browser, this step may be done automatically.
After that is done, you can select what data to import!
You can have as many separate Shopify accounts authorized in a single flow as you need, and each Shopify Import can pull from whichever auth you want, allowing you to pull data from across many different accounts if needed!
You can edit your authorizations at any time by doing the following:
The Edit Accounts menu is also how you can switch which account a step is pulling from.
This is a simple option that pulls in 1 row, containing the balance of your shop, and the currency that it is set to.
This option will pull in 1 row for every customer that you have in your Shopify store records. The default columns will only pull in the default address for each customer. Because customers may have more than one address, you can elect to also import any additional addresses. If you choose to import these additional addresses, any customer with more than a single address will show up on multiple rows. For example, if your customer Juanita has 3 addresses in your system, then you will see 3 rows for Juanita, with the address information being the only data that is different for each of her rows.
This is a simple option that will pull in all of your locations for this shop. The data is formatted as one row per location.
Shopify orders have a lot of information available, so this option has a few controls that you can use to get the exact data that you need. The default settings will pull in your open orders with the default set of columns.
Including more data:
Let's explore what each include option does:
The Import defaults to pulling in the default columns, so that each order is represented in a single row. These are the most basic columns that reference an order. You can optionally choose one more option to import. Each of these options can have multiple pieces of data in it that are associated with each order. So, when you choose one of these additional options, you may see some orders are now represented across more than one column.
Some of the options, such as refunds and line items, will have more options within them. These options allow you to pull in even more data, which can cause each order to be represented across even more columns! For example, if your have 1 order that has 3 refunds attached to it, then you will have 3 rows representing that order. 1 row for each refund within the order.
Adding in additional columns:
The next set of options allows you to add in additional columns for each order. Parabola shows your orders without this data initially to reduce the number of columns that you are working with. Orders have a lot of columns!
You can choose to add in as many of these sets of columns as you would like. Each option adds in a set of additional columns that relate to the order. Things like shipping address, customer, or payment details.
Adding these options in will only increase your columns, and will not increase your row count.
Filtering down your rows imported:
You have 3 options for how to filter which orders are pulled in. You can filter by status, financial status, or fulfillment status.
Each of these options can be added or removed, and each has an option for any, which will not filter out anything. Click into each to see what options are available!