AppsPricingBlogTry it
Shopify  logo
MySQL logo

Connect Shopify to MySQL

Use 8 documented Shopify triggers to run 10 documented MySQL actions.

8 source triggers
10 target actions
Reverse direction supported

Why Connect Shopify & MySQL?

Start with a Shopify event

Choose from 8 documented triggers, including Collection Updated (Instant), New Abandoned Cart, New Article.

Run a MySQL action

Send the event into one of 10 documented actions, such as Execute SQL Query, Create Row, Delete Row.

Map and review the workflow

Choose the fields and conditions for the workflow, then test the result before activation.

Available Triggers & Actions

Shopify  logo

Shopify

Triggers (8)

Collection Updated (Instant)

Emit new event whenever a collection is updated, including whenever products are added or removed from a collection.

webhook
New Abandoned Cart

Emit new event each time a user abandons their cart.

polling
New Article

Emit new event for each new article in a blog.

polling
New Customer Data Request

Emit new customer data requests for data via a GDPR request.

polling
New Event Emitted (Instant)

Emit new event for each new Shopify event.

webhook
New Page

Emit new event for each new page published.

polling
New product added to custom collection

Emit new event each time a product is added to a custom collection.

polling
New Product Created (Instant)

Emit new event for each product added to a store.

webhook

Actions (24)

Add Products to Custom Collection

Adds a product or products to a custom collection. See the documentation

Add Tags

Add tags. See the documentation

Bulk Import

Execute bulk mutations by uploading a JSONL file containing mutation variables. See the documentation

Create Article

Create a new blog article. See the documentation

Create Blog

Create a new blog. See the documentation

Create Custom Collection

Create a new custom collection. See the documentation

Create Metafield

Creates a metafield belonging to a resource. See the documentation

Create Metaobject

Creates a metaobject. See the documentation

Create Page

Create a new page. See the documentation

Create Product

Create a new product. See the documentation

Create Product Variant

Create a new product variant. See the documentation

Create Smart Collection

Creates a smart collection. You can fill in any number of rules by selecting more than one option in each prop.See the documentation

Delete Article

Delete an existing blog article. See the documentation

Delete Blog

Delete an existing blog. See the documentation

Delete Metafield

Deletes a metafield belonging to a resource. See the documentation

Delete Page

Delete an existing page. See the documentation

Get Articles

Retrieve a list of all articles from a blog. See the documentation

Get Assigned Fulfillment Orders

Retrieve a list of fulfillment orders assigned to a merchant location. See the documentation

Get Customer

Retrieve a single customer by ID. See the documentation

Get Customers

Retrieve a list of customers. See the documentation

Get Draft Order

Retrieve a single draft order by ID. See the documentation

Get Draft Orders

Retrieve a list of draft orders. See the documentation

Get Fulfillment

Retrieve a fulfillment, including tracking info, status, and delivery timestamps. See the documentation

Get Fulfillment Order

Retrieve a single fulfillment order by ID. See the documentation

MySQL logo

MySQL

Triggers (5)

New Column

Emit new event when you add a new column to a table. See the docs here

polling
New or Updated Row

Emit new event when you add or modify a new row in a table. See the docs here

polling
New Row

Emit new event when you add a new row to a table. See the docs here

polling
New Row (Custom Query)

Emit new event when new rows are returned from a custom query. See the docs here

polling
New Table

Emit new event when a new table is added to a database. See the docs here

polling

Actions (10)

Execute SQL Query

Execute a custom MySQL query. See our docs to learn more about working with SQL in Mazaal AI.

Create Row

Adds a new row. See the docs here

Delete Row

Delete an existing row. See the docs here

Execute Query

Find row(s) via a custom query. See the docs here

Execute Stored Procedure

Execute Stored Procedure. See the docs here

Find Row

Finds a row in a table via a lookup column. See the docs here

List Stored Procedure Options

Retrieves available options for the Stored Procedure field.

List Table Options

Retrieves available options for the Table field.

Query SQL Database

Execute a SQL Query. See our docs to learn more about working with SQL in Mazaal AI.

Update Row

Updates an existing row. See the docs here

Integration Features

8 documented Shopify triggers
10 documented MySQL actions
Configurable field mapping
Conditional workflow steps
Execution monitoring
A supported MySQL to Shopify direction

Capability Examples

Shopify trigger → MySQL action

Catalog example
Shopify Shopify

Collection Updated (Instant)

MySQLMySQL

Execute SQL Query

MySQL trigger → Shopify action

Reverse direction
MySQLMySQL

New Column

Shopify Shopify

Add Products to Custom Collection

How It Works

1

Connect Apps

Authenticate your Shopify and MySQL accounts

2

Choose a Trigger

Select a documented Shopify event

3

Choose an Action

Select the documented MySQL operation to run

Test and Review

Verify field mapping and provider responses before activation

Frequently Asked Questions

Integration Benefits

Trigger-driven Workflows

Start the supported direction from one of 8 documented Shopify triggers.

Automated Actions

Run one of 10 documented MySQL actions after the selected trigger fires.

Provider Authentication

Review the authentication requirements published by each provider before activating the workflow.

Guided Configuration

Select a documented trigger, choose a target action, and map the fields required by the workflow.

Field Mapping

Map the fields exposed by the selected trigger and action, then review the required provider inputs.

Execution Review

Test the workflow and review provider responses before relying on it in production.

MySQL logoShopify  logo

Reverse Integration Available

Also connect MySQL to Shopify for bidirectional automation

View Integration
Shopify  logo

All Shopify Integrations

Explore all available Shopify connections

View All Integrations
MySQL logo

All MySQL Integrations

Explore all available MySQL connections

View All Integrations

Ready to Connect Shopify & MySQL?

Build this supported workflow in Mazaal AI and test it with your own provider accounts.

Get Started Free