Skip to content

Finance and payments

Connect Square to DataxLand

The Square connector reads orders, payments, refunds, catalog items, discounts, locations and customers from your Square account. For shops and cafes on Square POS, Si maps orders and payments to the standard retail model, so net revenue, average order value, payment fees and contribution margin for each location are on the dashboard, next to your online channels if you also sell through a website or marketplaces.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with Square

  • Compare net revenue and average ticket size across locations, day by day.
  • See how much of each month's revenue goes to payment fees.
  • Join dish or item cost prices from Google Sheets to get contribution margin by item.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
ordersOrders, line items, discounts, location and status.
paymentsPayments, payment method and processing fee.
refundsRefunds by payment.
itemsCatalog items and variations.
discountsDiscount types.
locationsSales locations.
customersCustomers (personal-data columns are hashed on load).

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inSandbox
DeveloperAirbyte (community), run inside DataxLand
LicenseELv2

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
GMV (gross merchandise value)Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds).Currency
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count
Average order valueLine revenue after discounts divided by valid orders.= line_net_total / Valid ordersCurrency
Units soldTotal quantity of products in the order lines of valid orders.Count
Payment feesMarketplace transaction fees and payment gateway fees, allocated to lines by line revenue.Currency
Return rateReturned orders divided by valid orders.= returned_orders / Valid ordersRatio (%)
Contribution marginNet revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return costCurrency

Connect Square in 3 steps

  1. 1

    Get an access token

    In the Square Developer Dashboard, create an application and copy the production access token.

  2. 2

    Add the source

    In the workspace choose Add source, find Square in the connector library, choose API key authentication, paste the token, turn off Sandbox, pick a start date and click Test connection.

  3. 3

    Choose streams and review

    Pick orders, payments, refunds and items; orders and payments load incrementally. Si proposes a mapping, and you approve before the build.

Limits and caveats

  • This is a community connector from the Airbyte library (ELv2 license) run inside DataxLand.
  • DataxLand does not run the Square sign-in for you; use an access token (the form also accepts an OAuth client and refresh token from your own app).
  • Square has no cost prices; add them from Excel or Google Sheets to get contribution margin.

Frequently asked questions

Does it change orders or items?

No. DataxLand only reads data from Square.

What about multiple locations?

One Square account covers all its locations; dashboards split by location.

Can I try it with a sandbox account?

Yes. Turn on the Sandbox option and use a sandbox environment token.

Dashboard templates that use this source

Ask Si about your Square data →All data sources →

Connect Square and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes