New Source: WooCommerce

[sherifnada]

Tell us about the new connector you’d like to have

https://developer.woocommerce.com/

WooCommerce seems to also expose its MySQL db which means we might be able to just use the mysql source connector instead of building a whole dedicated connector.

Describe the context around this new connector

Describe the alternative you are considering or using

[karinakuz]

Integration Vetting

Webhook-based? (no/partially/yes)
if partially, mention which endpoints are webhook-based
no

Available authentication modes (API key/Oauth/other)
REST API keys https://woocommerce.github.io/woocommerce-rest-api-docs/#libraries-and-tools

Connecting to the data source
what kind of API is it? (SOAP/GraphQL/REST/other)
WooCommerce (WC) 2.6+ is fully integrated with the WordPress REST API. This allows WC data to be created, read, updated, and deleted using requests in JSON format and using WordPress REST API Authentication methods and standard HTTP verbs which are understood by most HTTP clients.
https://woocommerce.github.io/woocommerce-rest-api-docs/#introduction

is there an SDK available? Can we connect with HTTP requests directly?
no

If this is a database/datalake/pubsub source, does it have a JDBC driver or Java SDK?-->
MySQL DB, have ODBC driver https://woocommerce-store-manager-doc.emagicone.com/1-quick-start-guide/1-3-direct-connection-to-mysql-database?AVGAFFILIATE=55741&__c=1

Creating an account
Select one of the below options
self-service free account available?_ If yes then create it using integration-test@airbyte.io (you should be getting emails sent to this email address)
sandbox is only for payment tasting.

self-service paid account available? Please mention the cost of the various tiers and any recommendation about which tier we should buy_. Don't create the account right now.
WooCommerce plugin could be installed only if WordPress account has a Business plan and we have two variants 1) Plan Subscription: $300 per year ($25 per month billed annually) or 2) Plan Subscription: $33 per month.

How to populate the account with data?
Can it be done entirely through the API?
yes

Will it require some work through the UI? If so, what is required?
no

Will it require performing some paid action like running an Ad campaign? If so, please note the action needed, estimated cost, and estimated effort in hours. If a task will take more than 4 hours, please break it down into smaller tasks each of which take no more than 4 hours
no

Do you need any actions from Airbyte to populate the account with data? If so, please tag @ sherifnada for support
no

Available streams for sync
If this is an API connector:
Provide a link to the reference docs
https://woocommerce.github.io/woocommerce-rest-api-docs/#

List all coupons https://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-coupons
List all customers https://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-customers
List all orders https://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-orders
List all refunds https://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-refunds
List all products https://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-products
List all reports https://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-reports

Please mention if any of the endpoints are asynchronous (meaning we have to make a request, wait for the server to compute a response, then make another request to obtain the result)
no

if this is a source where the schema is dynamic/not fixed e.g: database, mention the data model of the connector i.e: relational, document-based, graph-based, etc.
yes

Do any streams support incremental sync?
not necessary to mention all of them, just saying “none”, “some”, or “all” is sufficient. If only some streams, please mention which ones support incremental sync-->
partially (except List all reports)

[marcosmarxm]

Closed by #5955