FAQ

Can I connect multiple Square accounts to Coupler.io?

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.

What's the difference between Orders and Payments in Square?

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.

Why are my revenue numbers 100 times larger than expected?

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.

Does the start date apply to all entities?

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.

Can I get data for a specific location only?

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.

How do I track loyalty points for my customers?

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.

Can I use Square data with AI tools like ChatGPT or Claude?

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.

How do I calculate total labor cost from Square data?

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.

For field-level details on each entity, see the Data Overview article. If you're running into connection or data problems, check Common Issues. For setup recommendations specific to Square, visit Best Practices.