Commercetools

Commercetools is a cloud-native, headless commerce platform used by mid-market and enterprise brands to manage their product catalog, orders, customers, and payments. It provides a flexible API-first approach to building commerce experiences across any channel.

Connecting Commercetools to Coupler.io lets you pull your store data into spreadsheets, BI tools, or AI assistants — without writing a single line of code.

Why connect Commercetools to Coupler.io?

• Sync orders, customers, products, payments, and discount codes into Google Sheets, Excel, BigQuery, Looker Studio, or AI destinations like ChatGPT, Claude, or Gemini
• Combine multiple entities — for example, join orders with payments to track revenue and fulfillment in one view
• Schedule automatic refreshes so your reports always reflect the latest store data
• Append data from multiple Commercetools projects into a single destination for consolidated reporting

Prerequisites

Before connecting, make sure you have:

• A Commercetools account with at least one active project
• A Client ID, Client Secret, Project Key, and Region for your project — these come from an API client you create in the Commercetools Merchant Center
• The API client must have read scopes for the entities you want to export (e.g., view_orders, view_customers, view_products)

Quick start

Create your API client in the Commercetools Merchant Center under Settings → Developer settings → API clients. Give it only the view scopes you need — this keeps access minimal and secure.

1

Create a new data flow in Coupler.io and select Commercetools as the source.

2

Enter your API credentials. You'll need your Client ID, Client Secret, Project Key, and Region. These are available on the API client detail page in the Merchant Center.

3

Select the entity you want to export — Customers, Orders, Products, Payments, or Discount codes.

4

Set a start date using the date picker to control how far back Coupler.io pulls data.

5

Choose your destination — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination such as Claude, ChatGPT, or Gemini.

6

Run the data flow manually to confirm everything is connected and data is loading correctly.

Available entities

Entity	Description
Customers	Contact details, preferences, and account data
Orders	Line items, pricing, shipping, and fulfillment status
Payments	Transactions, payment methods, and processing status
Products	Catalog data including descriptions, pricing, and inventory
Discount codes	Promotional codes, discount rules, usage counts, and validity periods