Integrate the MySQL API with the WooCommerce API

Setup the MySQL API trigger to run a workflow which integrates with the WooCommerce API. Pipedream's integration platform allows you to integrate MySQL and WooCommerce remarkably fast. Free for developers.

Popular Ways to Connect MySQL with WooCommerce#

Create Customer with WooCommerce API on New Column from MySQL API

MySQL + WooCommerce

Try it

Create Customer with WooCommerce API on New or Updated Row from MySQL API

MySQL + WooCommerce

Try it

Create Customer with WooCommerce API on New Row (Custom Query) from MySQL API

MySQL + WooCommerce

Try it

Create Customer with WooCommerce API on New Row from MySQL API

MySQL + WooCommerce

Try it

Create Customer with WooCommerce API on New Table from MySQL API

MySQL + WooCommerce

Try it

Popular MySQL and WooCommerce Triggers#

New Coupon Event (Instant) from the WooCommerce API

Emit new event each time the specified coupon event(s) occur

Try it

New Column from the MySQL API

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

Try it

New Customer Event (Instant) from the WooCommerce API

Emit new event each time the specified customer event(s) occur

Try it

New or Updated Row from the MySQL API

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

Try it

New Order Event (Instant) from the WooCommerce API

Emit new event each time the specified order event(s) occur

Try it

Popular MySQL and WooCommerce Actions#

Create Row with the MySQL API

Adds a new row. See the docs here

Try it

Create Customer with the WooCommerce API

Creates a new customer. See the docs

Try it

Delete Row with the MySQL API

Delete an existing row. See the docs here

Try it

Create Order with the WooCommerce API

Creates a new order. See the docs

Try it

Execute Query with the MySQL API

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

Try it

Overview of MySQL#

The MySQL application on Pipedream enables direct interaction with your MySQL databases, allowing you to perform CRUD operations—create, read, update, delete—on your data with ease. You can leverage these capabilities to automate data synchronization, report generation, and event-based triggers that kick off workflows in other apps. With Pipedream's serverless platform, you can connect MySQL to hundreds of other services without managing infrastructure, crafting complex code, or handling authentication.

Connect MySQL#

import mysql from '@pipedream/mysql';

export default defineComponent({
  props: {
    mysql,
  },
  async run({steps, $}) {
    // Component source code:
    // https://github.com/PipedreamHQ/pipedream/tree/master/components/mysql

    const queryObj = {
      sql: "SELECT NOW()",
      values: [], // Ignored since query does not contain placeholders
    };
    const { rows } = await this.mysql.executeQuery(queryObj);
    return rows;
  },
});

Overview of WooCommerce#

WooCommerce is a customizable, open-source eCommerce platform built on WordPress. With the WooCommerce API, you can tap into the heart of your eCommerce store to read, create, update, and delete products, orders, and customers. On Pipedream, you can harness this API to automate routine tasks, sync data across platforms, and enhance customer experiences. By connecting WooCommerce to a wide array of apps and services, you can streamline operations, trigger personalized marketing, and analyze your sales data with greater ease.

Connect WooCommerce#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    woocommerce: {
      type: "app",
      app: "woocommerce",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://${this.woocommerce.$auth.url}/wp-json/wc/v2/orders`,
      auth: {
        username: `${this.woocommerce.$auth.key}`,
        password: `${this.woocommerce.$auth.secret}`,
      },
    })
  },
})