MySQL AppiWorks

for Shopify

Interact with MySQL directly from Shopify

What is MySQL AppiWorks?

MySQL AppiWorks for Shopify is a HubSpot extension that integrates Shopify and a MySQL database. It helps users export data from Shopify to MySQL.

Setup Configuration

After installation is successful, sign in to Shopify, and in the sidebar, you can find the MySQL AppiWorks under the Apps section.

Click on MySQL AppiWorks.
Click on Get Started

Setup Service Configuration

Authorize with the Shopify account and establish a connection with Shopify.
After Authorization, click on the Create New Service button.

Setup the Export service

Enter your service name
Add a short description about your service (optional)
In this example, we will export Shopify Products to the MySQL products table.

Choose your Shopify object.

Choose the MySQL connection
Choose the MySQL table to export.
Visit the following page for steps to set up the MySQL Connection

Setup MySQL Connection

Setup the mapping between Shopify object fields and your MySQL table fields.

Enable/disable manual export execution.
Activate the Service.
Finally, save your service.

Execute export service

From the sidebar, navigate to Shopify Object. In this example, go to Products.
Choose the products to export.
Click on the 3 dots button (shown in the right side image)
Click on MySQL AppiWorks App.

You can see the service you have configured for the products object.
Click on the Execute button next to the service name to run the service.
On execution it will export all the selected products to MySQL table.

Visit any MySQL client to verify the export.
You can see that the Shopify Products are exported now.

Report abuse