WooCommerce connector for Amazon AppFlow - Amazon AppFlow

WooCommerce connector for Amazon AppFlow

WooCommerce helps online merchants build commercial websites with a plugin for WordPress. If you're a WooCommerce user, then your account contains data about your site and your transactions, such as your orders, products, reviews, shipments, and more. You can use Amazon AppFlow to transfer data from WooCommerce to certain AWS services or other supported applications.

Amazon AppFlow support for WooCommerce

Amazon AppFlow supports WooCommerce as follows.

Supported as a data source?

Yes. You can use Amazon AppFlow to transfer data from WooCommerce.

Supported as a data destination?

No. You can't use Amazon AppFlow to transfer data to WooCommerce.

Before you begin

To use Amazon AppFlow to transfer data from WooCommerce to supported destinations, you must meet these requirements:

  • You have an account with WooCommerce that contains the data that you want to transfer. For more information about the WooCommerce data objects that Amazon AppFlow supports, see Supported objects.

  • In your WooCommerce account, you've created a REST API key for Amazon AppFlow. For information about how create a key, see Authentication in the WooCommerce documentation.

From the REST API key details, note the consumer key and consumer secret. You provide these values to Amazon AppFlow when you connect to your WooCommerce account.

Connecting Amazon AppFlow to your WooCommerce account

To connect Amazon AppFlow to your WooCommerce account, provide the credentials from the REST API key in your WooCommerce account so that Amazon AppFlow can access your data. If you haven't yet configured your WooCommerce account for Amazon AppFlow integration, see Before you begin.

To connect to WooCommerce
  1. Sign in to the AWS Management Console and open the Amazon AppFlow console at https://console.aws.amazon.com/appflow/.

  2. In the navigation pane on the left, choose Connections.

  3. On the Manage connections page, for Connectors, choose WooCommerce.

  4. Choose Create connection.

  5. In the Connect to WooCommerce window, enter the following information:

    • Consumer Key — The consumer key from your REST API key.

    • Consumer Secret — The consumer secret from your REST API key.

    • Instance URL — The site name that you assigned when you created your site in WooCommerce.

  6. Optionally, under Data encryption, choose Customize encryption settings (advanced) if you want to encrypt your data with a customer managed key in the AWS Key Management Service (AWS KMS).

    By default, Amazon AppFlow encrypts your data with a KMS key that AWS creates, uses, and manages for you. Choose this option if you want to encrypt your data with your own KMS key instead.

    Amazon AppFlow always encrypts your data during transit and at rest. For more information, see Data protection in Amazon AppFlow.

    If you want to use a KMS key from the current AWS account, select this key under Choose an AWS KMS key. If you want to use a KMS key from a different AWS account, enter the Amazon Resource Name (ARN) for that key.

  7. For Connection name, enter a name for your connection.

  8. Choose Connect.

  9. In the window that appears, sign in to your WooCommerce account, and grant access to Amazon AppFlow.

On the Manage connections page, your new connection appears in the Connections table. When you create a flow that uses WooCommerce as the data source, you can select this connection.

Transferring data from WooCommerce with a flow

To transfer data from WooCommerce, create an Amazon AppFlow flow, and choose WooCommerce as the data source. For the steps to create a flow, see Creating flows in Amazon AppFlow.

When you configure the flow, choose the data object that you want to transfer. For the objects that Amazon AppFlow supports for WooCommerce, see Supported objects.

Also, choose the destination where you want to transfer the data object that you selected. For more information about how to configure your destination, see Supported destinations.

Supported destinations

When you create a flow that uses WooCommerce as the data source, you can set the destination to any of the following connectors:

Supported objects

When you create a flow that uses WooCommerce as the data source, you can transfer any of the following data objects to supported destinations:

Object

Field

Data type

Supported filters

Coupon

After

DateTime

EQUAL_TO

Amount

String

Before

DateTime

EQUAL_TO

Code

String

EQUAL_TO

Context

String

EQUAL_TO

Date Created

DateTime

Date Created GMT

DateTime

Date Expires GMT

String

Date Expiry

String

Date Modified

DateTime

Date Modified GMT

DateTime

Description

String

Discount Type

String

Email Restriction

List

Exclude Sale Item

Boolean

Excluded Product Category List

List

Excluded Product ID

List

Free Shipping

Boolean

ID

Integer

Individual Use

Boolean

Limit Usage To X Item

Integer

Maximum Amount

String

Meta Data

List

Minimum Amount

String

Order

String

EQUAL_TO

Order By

String

EQUAL_TO

Product Category List

List

Product ID

List

Search

String

EQUAL_TO

Status

String

Usage Count

Integer

Usage Limit

Integer

Usage Limit Per User

Integer

Used By

List

Coupon Total

Name

String

Slug

String

Total

String

Customer Total

Name

String

Slug

String

Total

String

Order

After

DateTime

EQUAL_TO

Before

DateTime

EQUAL_TO

Billing

Struct

Cart Hash

String

Cart Tax

String

Context

String

EQUAL_TO

Coupon Line

List

Created Via

String

Currency

String

Currency Symbol

String

Customer

Integer

EQUAL_TO

Customer IP Address

String

Customer Id

Integer

Customer Note

String

Customer User Agent

String

DP

Integer

EQUAL_TO

Date Completed

DateTime

Date Completed GMT

DateTime

Date Created

DateTime

Date Created GMT

DateTime

Date Modified

DateTime

Date Modified GMT

DateTime

Date Paid

DateTime

Date Paid GMT

DateTime

Discount Tax

String

Discount Total

String

Fee Line

List

ID

Integer

Is Editable

Boolean

Line Item

List

Meta Data

List

Needs Payment

Boolean

Needs Processing

Boolean

Number

String

Order

String

EQUAL_TO

Order By

String

EQUAL_TO

Order Key

String

Parent ID

Integer

Payment Method

String

Payment Method Title

String

Payment Url

String

Prices Include Tax

Boolean

Product

Integer

EQUAL_TO

Refund

List

Search

String

EQUAL_TO

Set Paid

Boolean

Shipping

Struct

Shipping Line

List

Shipping Tax

String

Shipping Total

String

Status

String

Tax Line

List

Total

String

Total Tax

String

Transaction ID

String

Version

String

Order Total

Name

String

Slug

String

Total

String

Payment Gateway

Connection Url

String

Description

String

Enabled

Boolean

ID

String

Method Description

String

Method Support

List

Method Title

String

Needs Setup

Boolean

Order

Integer

Post Install Script

List

Required Settings Key

List

Setting

Struct

Settings Url

String

Setup Help Text

String

Title

String

Product

After

DateTime

EQUAL_TO

Attribute List

List

Average Rating

String

Backorder

String

Backordered

Boolean

Backorders Allowed

Boolean

Before

DateTime

EQUAL_TO

Button Text

String

Catalog Visibility

String

Category List

List

Context

String

EQUAL_TO

Date Created

DateTime

Date Created GMT

DateTime

Date Modified

DateTime

Date Modified GMT

DateTime

Date On Sale From

DateTime

Date On Sale From GMT

DateTime

Date On Sale To

DateTime

Date On Sale To GMT

DateTime

Default Attribute List

List

Description

String

Dimension

Struct

Download

List

Download Expiry

Integer

Download Limit

Integer

Downloadable

Boolean

External Url

String

Featured

Boolean

EQUAL_TO

Grouped Product List

List

Has Option

Boolean

ID

Integer

Image List

List

Jetpack Likes Enabled

Boolean

Jetpack Publicize Connection

List

Jetpack Sharing Enabled

Boolean

List of Cross Sell ID

List

List of Jetpack Related Post

List

List of Upsell ID

List

Low Stock Amount

Integer

Manage Stock

Boolean

Menu Order

Integer

Meta Data

List

Name

String

On Sale

Boolean

EQUAL_TO

Order

String

EQUAL_TO

Order By

String

EQUAL_TO

Parent ID

Integer

Permalink

String

Price

String

Price Html

String

Purchasable

Boolean

Purchase Note

String

Rating Count

Integer

Regular Price

String

Related ID

List

Reviews Allowed

Boolean

Sale Price

String

Search

String

EQUAL_TO

Shipping Class

String

EQUAL_TO

Shipping Class ID

Integer

Shipping Required

Boolean

Shipping Taxable

Boolean

Short Description

String

Sku

String

EQUAL_TO

Slug

String

EQUAL_TO

Sold Individually

Boolean

Status

String

EQUAL_TO

Stock Quantity

Integer

Stock Status

String

EQUAL_TO

Tag

List

Tag

String

EQUAL_TO

Tax Class

String

EQUAL_TO

Tax Status

String

Total Sale

Integer

Type

String

EQUAL_TO

Variation List

List

Virtual

Boolean

Weight

String

Product Attribute

Context

String

EQUAL_TO

Has Archive

Boolean

ID

Integer

Name

String

Order By

String

Slug

String

Type

String

Product Attribute Term

Context

String

EQUAL_TO

Count

Integer

Description

String

Hide Empty

Boolean

EQUAL_TO

ID

Integer

Menu Order

Integer

Name

String

Order

String

EQUAL_TO

Order By

String

EQUAL_TO

Parent

Integer

EQUAL_TO

Product

Integer

EQUAL_TO

Search

String

EQUAL_TO

Slug

String

EQUAL_TO

Product Category

Context

String

EQUAL_TO

Count

Integer

Description

String

Display

String

Hide Empty

Boolean

EQUAL_TO

ID

Integer

Image

Struct

Menu Order

Integer

Name

String

Order

String

EQUAL_TO

Order By

String

EQUAL_TO

Parent

Integer

EQUAL_TO

Product

Integer

EQUAL_TO

Search

String

EQUAL_TO

Slug

String

EQUAL_TO

Product Review

After

DateTime

EQUAL_TO

Before

DateTime

EQUAL_TO

Context

String

EQUAL_TO

Date Created

DateTime

Date Created GMT

DateTime

ID

Integer

Order

String

EQUAL_TO

Order By

String

EQUAL_TO

Product ID

Integer

Product Name

String

Product Permalink

String

Rating

Integer

Review

String

Reviewer

String

Reviewer Avatar URL

Struct

Reviewer Email

String

Search

String

EQUAL_TO

Status

String

EQUAL_TO

Verified

Boolean

Product Shipping Class

Context

String

EQUAL_TO

Count

Integer

Description

String

Hide Empty

Boolean

EQUAL_TO

ID

Integer

Name

String

Order

String

EQUAL_TO

Order By

String

EQUAL_TO

Product

Integer

EQUAL_TO

Search

String

EQUAL_TO

Slug

String

EQUAL_TO

Product Tag

Context

String

EQUAL_TO

Count

Integer

Description

String

Hide Empty

Boolean

EQUAL_TO

ID

Integer

Name

String

Order

String

EQUAL_TO

Order By

String

EQUAL_TO

Product

Integer

EQUAL_TO

Search

String

EQUAL_TO

Slug

String

EQUAL_TO

Product Total

Name

String

Slug

String

Total

String

Product Variation

After

DateTime

EQUAL_TO

Backorder

String

Backordered

Boolean

Backorders Allowed

Boolean

Before

DateTime

EQUAL_TO

Context

String

EQUAL_TO

Date Created

DateTime

Date Created GMT

DateTime

Date Modified

DateTime

Date Modified GMT

DateTime

Date On Sale From

DateTime

Date On Sale From GMT

DateTime

Date On Sale To

DateTime

Date On Sale To GMT

DateTime

Description

String

Dimension

Struct

Download

List

Download Expiry

Integer

Download Limit

Integer

Downloadable

Boolean

ID

Integer

Image

Struct

List of attribute

List

Low Stock Amount

Integer

MAX Price

String

EQUAL_TO

MIN Price

String

EQUAL_TO

Manage Stock

Boolean

Menu Order

Integer

Meta Data

List

On Sale

Boolean

EQUAL_TO

Order

String

EQUAL_TO

Order By

String

EQUAL_TO

Permalink

String

Price

String

Purchasable

Boolean

Regular Price

String

Sale Price

String

Search

String

EQUAL_TO

Shipping Class

String

Shipping Class ID

Integer

Sku

String

EQUAL_TO

Slug

String

EQUAL_TO

Status

String

EQUAL_TO

Stock Quantity

Integer

Stock Status

String

EQUAL_TO

Tax Class

String

EQUAL_TO

Tax Status

String

Virtual

Boolean

Weight

String

Report

Description

String

Slug

String

Review Total

Name

String

Slug

String

Total

String

Sale Report

Average Sale

String

Context

String

EQUAL_TO

Date Max

Date

EQUAL_TO

Date Min

Date

EQUAL_TO

Net Sale

String

Period

String

EQUAL_TO

Total

Struct

Total Customer

Integer

Total Discount

Integer

Total Item

Integer

Total Order

Integer

Total Refund

Integer

Total Sale

String

Total Shipping

String

Total Tax

String

Totals Grouped By

String

Shipping Method

Description

String

ID

String

Title

String

Shipping Zone

ID

Integer

EQUAL_TO

Name

String

Order

Integer

Shipping Zone Location

Code

String

Type

String

Shipping Zone Method

Enabled

Boolean

ID

Integer

EQUAL_TO

Instance ID

Integer

Method Description

String

Method ID

String

Method Title

String

Order

Integer

Setting

Struct

Title

String

Tax Class

Name

String

Slug

String

Tax Rate

Cities

List

City

String

Class

String

EQUAL_TO

Compound

Boolean

Context

String

EQUAL_TO

Country

String

ID

Integer

Name

String

Order

Integer

EQUAL_TO

Order By

String

EQUAL_TO

Postcode

List

Postcode

String

Priority

Integer

Rate

String

Shipping

Boolean

State

String

Top Seller Report

Context

String

EQUAL_TO

Date Max

Date

EQUAL_TO

Date Min

Date

EQUAL_TO

Name

String

Period

String

EQUAL_TO

Product ID

Integer

Quantity

Integer