WooCommerce Connector Setup

Version 23.0.8517

WooCommerce Connector Setup

The WooCommerce connector allows you to integrate WooCommerce into your data flow by pushing or pulling data from WooCommerce. Follow the steps below to connect CData Arc to WooCommerce.

Establish a Connection

To allow Arc to use data from WooCommerce, you must first establish a connection to WooCommerce. There are two ways to establish this connection:

  • Add a WooCommerce connector to your flow. Then, in the settings pane, click Create next to the Connection drop-down list.
  • Open the Arc Settings page, then open the Connections tab. Click Add, select WooCommerce, and click Next.


  • The login process is only required the first time the connection is created.
  • Connections to WooCommerce can be re-used across multiple WooCommerce connectors.

Enter Connection Settings

After opening a new connection dialogue, follow these steps:

  1. Enter the connection information:
    • Name —the static name of the connection. Set this as desired.
    • Type —this is always set to WooCommerce.
    • Auth Scheme —the authentication scheme to use for the connection. Options are Basic, OAuth 1.0 One Legged, and OAuth 2.0.
  2. Enter the connection information for your chosen authentication scheme:

Basic Auth

  1. In the User field, enter the username to use for logging in.

  2. In the Password field, enter the password for the user you enter.

  3. Continue to Finalize Connection.

OAuth 1.0 One Legged

  1. Open the WooCommerce Settings page.

  2. Open the Advanced tab.

  3. Under the REST API section, click Add key.

  4. Provide the requested information and click Generate API Key.

  5. Copy the values for Consumer key and Consumer secret from WooCommerce and enter them in your Arc connection.

  6. Continue to Finalize Connection.

OAuth 2.0

First, follow these steps to configure OAuth 2.0 for your WordPress server:

  1. Download the OAuth 2.0 Server plugin.

  2. Extract the plugin archive and copy the oauth2-provider folder to the wp-content\plugins folder.

  3. Activate the plugin in the WordPress admin interface.

Next, open the WordPress admin interface and follow these steps:

  1. Open the OAuth Server page.

  2. Click Add New Client.

  3. Provide the requested information and click Create Client.

  4. Copy the value for Client Key into the OAuth Client Id field in Arc.

  5. Copy the value for Client Secret into the OAuth Client Secret field in Arc.

  6. Continue to Finalize Connection.

Finalize Connection

  1. If needed, click Advanced to open the drop-down menu of advanced connection settings. These should not be needed in most cases.

  2. Click Test Connection to ensure that Arc can connect to WooCommerce with the provided information. If an error occurs, check all fields and try again.

  3. Click Add Connection to finalize the connection.

  4. In the Connection drop-down list of the connector configuration pane, select the newly-created connection.

  5. Click Save Changes.

Select an Action

After establishing a connection to WooCommerce, you must choose the action that the WooCommerce connector will perform. The table below outlines each action and where it belongs in an Arc flow.

Action Description Position in Flow
Upsert Inserts or updates WooCommerce data. By default, if a record already exists in WooCommerce, an update is performed on the existing data in WooCommerce using the values provided from the input. End
Lookup Retrieves a value from WooCommerce and inserts that value into an already-existing Arc message in the flow.
The Lookup Query determines what value the connector will retrieve from WooCommerce. It should be formatted as a SQL query against the WooCommerce tables.
Select Retrieves data from WooCommerce and brings it into Arc.
You can use the Filter panel to add filters to the Select. These filters function similarly to WHERE clauses in SQL.
Execute Stored Procedures Treats data coming into the connector as input for a stored procedure, and then passes the result down the flow.
You can click the Show Sample Data button to provide sample inputs to the selected Stored Procedure and preview the results.