Move Commercetools data anywhere it matters.

Commercetools is a cloud-based headless commerce platform that provides APIs to power e-commerce sales and similar functions for large businesses. Both the company and platform are called Commercetools. The company is headquartered in Munich, Germany with additional offices in Berlin, Germany; Jena, Germany; Amsterdam, Netherlands; London, England and etc. Through its investor REWE Group, it is associated with the omnichannel order fulfillment software solutions providers fulfillmenttools and the payment transactions provider paymenttools. Its clients include Audi, Bang & Olufsen, Carhartt and Nuts.com.

Sync Commercetools free Read the docs

Source

Commercetools

Snowflake
BigQuery
Postgres
Databricks
Claude

Streams: 5
Destinations: 50+
Standard support: 0.3.11

Overview

What is the Airbyte Commercetools connector?

The Airbyte Commercetools connector extracts data from Commercetools and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes 5 streams you can select per connection.

01
Sync to your warehouse
Land 5 Commercetools tables in 50+ destinations on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
One authorization
Authenticate Commercetools once and Airbyte keeps every scheduled sync running on it.
04
Cloud or self-hosted
Run the Commercetools connector on OSS.

5 streams

Every table you can sync from Commercetools

Customers
Sync modes FullIncr.
Orders
Sync modes FullIncr.
Products
Sync modes FullIncr.
DiscountCodes
Sync modes FullIncr.
Payments
Sync modes FullIncr.

Customers
Sync modes	FullIncr.

Orders
Sync modes	FullIncr.

Products
Sync modes	FullIncr.

DiscountCodes
Sync modes	FullIncr.

Payments
Sync modes	FullIncr.

Setup

Live in ten steps

First, you need to obtain your Commercetools credentials, which include the client ID, client secret, project key, and API URL. You can find these credentials in your Commercetools account under the "API Clients" section.
Once you have your Commercetools credentials, go to the Airbyte dashboard and click on "Sources" on the left-hand side menu.
Click on the "Commercetools" source connector and then click on "Create new connection."
In the "Connection Configuration" page, enter your Commercetools credentials in the appropriate fields. Make sure to enter the correct API URL for your Commercetools account.
Click on "Test Connection" to ensure that Airbyte can connect to your Commercetools account.
If the connection is successful, click on "Save & Continue."
In the "Sync Configuration" page, you can configure how often you want Airbyte to sync data from your Commercetools account. You can also choose which data you want to sync.
Once you have configured the sync settings, click on "Save & Continue."
Finally, click on "Create Connection" to create the Commercetools source connector on Airbyte.
You can now use the Commercetools source connector to extract data from your Commercetools account and load it into your destination data warehouse or data lake.

Configuration fields

Commercetools configuration fields
Field	Type	Description
client_id*	string	Id of API Client.
client_secret*	string	The password of secret of API Client.
host*	string	The cloud provider your shop is hosted. See: https://docs.commercetools.com/api/authorization
project_key*	string	The project key
region*	string	The region of the platform.
start_date*	string	Not documented.