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 |
|---|---|
| orders | Orders, line items, discounts, location and status. |
| payments | Payments, payment method and processing fee. |
| refunds | Refunds by payment. |
| items | Catalog items and variations. |
| discounts | Discount types. |
| locations | Sales locations. |
| customers | Customers (personal-data columns are hashed on load). |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | Sandbox |
| Developer | Airbyte (community), run inside DataxLand |
| License | ELv2 |
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.
| Metric | Definition | Unit |
|---|---|---|
| Net revenue | Line 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 orders | Orders that were not cancelled (standard status other than cancelled). | Count |
| Average order value | Line revenue after discounts divided by valid orders.= line_net_total / Valid orders | Currency |
| Units sold | Total quantity of products in the order lines of valid orders. | Count |
| Payment fees | Marketplace transaction fees and payment gateway fees, allocated to lines by line revenue. | Currency |
| Return rate | Returned orders divided by valid orders.= returned_orders / Valid orders | Ratio (%) |
| Contribution margin | Net 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 cost | Currency |
Connect Square in 3 steps
- 1
Get an access token
In the Square Developer Dashboard, create an application and copy the production access token.
- 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
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
Connect Square and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes