Commerce Tools

📘

Check out the API docs here for more information.

Set up

---

Regions
You must select one of the regions from the dropdown. If you would like to retrieve data from multiple regions, these will have to be done in separate sources (for more details please read docs here).

Generating Credentials

1. An API Client must first be created in the Merchant Center. To do this, please follow these instructions.
2. You must choose the appropriate scope for the API Client (see below).
3. Store the client_id, secret, scope, API URL, and Auth URL in a safe location

Scope
The scope determines which reports can be accessed. Read more about scopes here.

Necessary scopes:

• Orders - view_orders:{projectKey}
• Orders Daily - view_orders:{projectKey}
• Payments- view_payments:{projectKey}
• Payments Daily- view_payments:{projectKey}
• Products - view_products:{projectKey}
• Products Daily - view_products:{projectKey}
• Product Types - view_products:{projectKey}
• Categories - view_products:{projectKey}
• Types - view_types:{projectKey}
• States - view_states:{projectKey}

Features

---

Reports detail

---

Limitations

---

❗️

10k row limit per extract

Due to a limitation with CommerceTools, on Orders, Products and Payments; each extract will be limited to 10k rows. If have more rows to ingest, simply keep running the extract on append, relying on the incremental logic to fill up the data.

When setting up the schedule, make sure to schedule the extracts with time intervals small enough to ensure that more than 10k rows would not be available per extract.