You can't use this until you register with us!




Description

Obtain data from Shopify and store it in a MySQL database.


Purchasing Options



Available Actions

Download Orders

Download orders from Shopify and store them in a table in a MySQL database.


Variables

Source Parameters
shopify_connection required

Credentials to use to access Shopify.

shopify_store_id required

Name of the store with data to download.

user_params

Filters to limit the data to download. Refer to slide out help for more information.

pointer required

Datetime stamp indicating the starting point of the data to download. This field will be updated automatically after each successful Task execution. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.


Destination Parameters
mysql_connection required

MySQL database where the data will be stored.

target_table_name required

Table name, in schema.table format, where data will be stored.

table_config required

Select a Shared Config with the Shopify property to MySQL column mappings.


Download Transactions

Download transactions from Shopify and store them in a table in a MySQL database.


Variables

Source Parameters
shopify_connection required

Credentials to use to access Shopify.

shopify_store_id required

Name of the store with data to download.

orders_query required

SQL query to use to determine which orders to download transaction data for.

pointer required

Datetime stamp indicating the starting point of the data to download. This field will be updated automatically after each successful Task execution. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.

range_end_point_query

SQL query to use to determine the end point of the data to process.

user_params

Parameters to use in your SQL Script, if any. Refer to slide out help for more information.


Destination Parameters
mysql_connection required

MySQL database where the data will be stored.

target_table_name required

Table name, in schema.table format, where data will be stored.

table_config required

Select a Shared Config with the Shopify property to MySQL column mappings.