# Best Practices ## Recommended setup


Separate Sales from Sale lists	Use Sales for revenue and margin reporting, and Sale lists for product-level order analysis. Mixing them up leads to double-counting or mismatched totals.
Join entities on shared IDs	Most Cin7 entities share common identifiers (product ID, customer ID, supplier ID). Use Coupler.io's Join transformation to combine Sales + Products or Customers + Sale lists instead of exporting everything separately and stitching it in a spreadsheet.
Use Append for multi-account setups	If your business runs multiple Cin7 accounts (e.g., by region or brand), add each as a separate source block and use the Append transformation to consolidate all records into one destination.
Start with a focused entity set	Don't pull all 20 entities on day one. Start with the 3-4 most business-critical ones (typically Sales, Products, Product availabilities, and Customers), validate the data, then expand.

## Data refresh and scheduling


Sync Product availabilities frequently	Stock levels change throughout the day. If you rely on availability data for decisions, schedule this entity to refresh every hour or every few hours rather than once daily.
Store historical snapshots for inventory	The Cin7 API returns current stock levels, not historical ones. If you need trend data, configure Coupler.io to append new runs rather than overwrite, so each sync adds a dated row to your history.
Sync CRM entities less often	Leads, Deals, and Opportunities change slowly. A daily or twice-daily refresh is usually enough and keeps you well within Cin7's API rate limits.

## Performance optimization


Split high-volume entities into their own data flows	Sales and Purchase transaction tables can get large. Running them as standalone data flows prevents timeouts and makes it easier to debug issues independently of your other entities.
Send large datasets to BigQuery, not Sheets	If you're pulling years of sales or purchase history, Google Sheets will hit row limits quickly. Route high-volume Cin7 entities to BigQuery or another warehouse destination instead.

## Common pitfalls {% hint style="danger" %} Don't use Purchase lists and Purchases interchangeably. Purchase lists are line-item records; Purchases are transaction summaries. Aggregating the wrong one will give you inflated or incomplete cost figures. {% endhint %} {% columns %} {% column %} **Do** * Validate totals against Cin7's own reports after the first run * Use the Join transformation to enrich Sales data with product and customer details * Check that your API user role has access to every module you're syncing * Store dated inventory snapshots using append mode {% endcolumn %} {% column %} **Don't** * Pull all entities at once without checking which ones your Cin7 plan supports * Rely on a single daily sync for inventory data if stock accuracy is critical * Overwrite historical sales data — use append mode to preserve transaction history * Assume CRM entities will have data if you haven't enabled Cin7's CRM module {% endcolumn %} {% endcolumns %}