Cin7

Cin7 is a cloud-based inventory management and point-of-sale platform that helps product businesses manage stock, orders, suppliers, and sales across multiple channels. It combines inventory control, order management, and financial tracking in one place. Connecting Cin7 to Coupler.io lets you pull that data into your reporting and analytics tools automatically.

Why connect Cin7 to Coupler.io?

• Sync sales, purchases, inventory, and customer data into Google Sheets, BigQuery, Excel, or Looker Studio without manual exports

• Combine Cin7 entities — for example, join Sales with Products to analyze revenue by SKU, or Append purchase records across multiple accounts

• Send Cin7 data to AI destinations like ChatGPT, Claude, or Gemini for demand forecasting, supplier analysis, or sales commentary

• Keep dashboards and reports up to date on a schedule without touching Cin7

Prerequisites

Before connecting, make sure you have:

• A Cin7 account with API access enabled (available on most paid plans)

• Your Cin7 API Username and API Key — find these in Cin7 under Settings > Integrations > API

• Sufficient permissions to access the entities you want to export (e.g., sales, purchases, inventory)

Quick start

If you want a broad view of your inventory and sales performance, start by adding the Sales, Products, and Product availabilities entities in a single data flow. Use the Join transformation to combine them by product ID.

How to connect

1

Create a new data flow in Coupler.io. Log in to your Coupler.io account, go to Data flows, and click Add data flow. Search for Cin7 and select it as your source.

2

Enter your Cin7 API credentials. In the source settings, paste your API Username and API Key. You can find these in Cin7 under Settings > Integrations > API. Click Save.

3

Select the entity you want to import. Choose from the list of available entities — such as Sales, Products, Customers, or Purchase lists. Each entity is a separate source block; add more source blocks to the same data flow if you need multiple entities.

4

Choose your destination. Select where you want your data to land — Google Sheets, BigQuery, Excel, Looker Studio, or an AI destination like ChatGPT or Claude. Configure the destination settings.

5

Run your data flow. Click Run to execute a manual sync and verify the data looks correct before setting up a schedule.

Available entities

Entity	Description
Accounts	Chart of accounts for financial tracking
Bank accounts	Bank account details used in transactions
Attribute sets	Product attribute groupings
Brands	Product brand information
Carriers	Shipping and delivery carrier details
Customers	Customer contact information
Deals	Sales deals and opportunities
Leads	Sales lead information
Locations	Warehouse and storage location data
Opportunities	Sales pipeline data
Product availabilities	Real-time stock levels by location
Product categories	Category classifications and hierarchies
Product families	Product family groupings
Products	Full product catalog with SKUs and pricing
Purchase lists	Purchase order records
Purchases	Purchase transaction history
Sale lists	Sales order records
Sales	Sales transaction and performance data
Suppliers	Vendor and supplier contact details
Taxes	Tax codes and rate configurations