# FAQ

<details>

<summary>Can I connect multiple Square accounts to Coupler.io?</summary>

Yes. Each Square account requires its own connection in Coupler.io. When setting up a data flow, you can add a new Square connection for a different account. If you want to combine data from multiple accounts in one report, pull each account into a separate data flow and use the Append transformation to merge the results.

</details>

<details>

<summary>What's the difference between Orders and Payments in Square?</summary>

Orders represent what was purchased — they include line items, applied discounts, taxes, and the order total. Payments represent the actual money collected — they include the payment method, amount charged, and transaction status. One order can have multiple payments (e.g., split tender). For revenue reporting, use both entities joined on order\_id.

</details>

<details>

<summary>Why are my revenue numbers 100 times larger than expected?</summary>

Square returns all monetary values in the smallest currency unit (cents for USD). A value of `2500` means $25.00. You need to divide amount fields by 100 in your destination or transformation step. This applies to total\_money, amount\_money, and all other money fields across Orders, Payments, and Refunds.

</details>

<details>

<summary>Does the start date apply to all entities?</summary>

No. The start date filters time-based entities — Orders, Payments, Refunds, Shifts, and similar transactional data. Catalog entities like Items, Categories, Taxes, Discounts, and Modifier lists return all records regardless of the start date you set.

</details>

<details>

<summary>Can I get data for a specific location only?</summary>

Coupler.io pulls data for all locations under the authorized Square account. You can filter by location\_id in your destination (e.g., using a filter in Google Sheets or a WHERE clause in BigQuery) after the data lands. Every entity includes a location\_id field you can use for this.

</details>

<details>

<summary>How do I track loyalty points for my customers?</summary>

Use the **Loyalties** entity to get loyalty account balances and lifetime points. Join it with the **Customers** entity on customer\_id to attach names and contact details to each loyalty account. This gives you a complete view of your most engaged customers.

</details>

<details>

<summary>Can I use Square data with AI tools like ChatGPT or Claude?</summary>

Yes. Coupler.io supports AI destinations including ChatGPT, Claude, Gemini, Cursor, Perplexity, and OpenClaw. You can send Square Orders, Customers, or Payments data directly to these tools to generate summaries, identify trends, or answer natural language questions about your business.

</details>

<details>

<summary>How do I calculate total labor cost from Square data?</summary>

Join the **Shifts** entity with **Team member wages** on employee\_id. Multiply the shift duration (end\_at minus start\_at, in hours) by the wage rate to calculate labor cost per shift. Use the Aggregate transformation to sum costs by location or date range.

</details>

{% hint style="info" %}
For field-level details on each entity, see the [Data Overview](https://docs.coupler.io/sources/category/ecommerce/square/data-overview) article. If you're running into connection or data problems, check [Common Issues](https://docs.coupler.io/sources/category/ecommerce/square/common-issues). For setup recommendations specific to Square, visit [Best Practices](https://docs.coupler.io/sources/category/ecommerce/square/best-practices).
{% endhint %}