Release Notes

April 2023

We have changed the sync strategy for the SHIFT table to improve the accuracy and reliability of its data. We now perform a to capture the 90-day-old historical records on a weekly basis. Even though this might temporarily slow down your syncs and increase your MAR consumption, this change in the sync strategy ensures that the data in the SHIFT table has no discrepancies and errors.

May 2022

We have changed the composite key of the ORDER_LINE_ITEM_MODIFIER table. The new composite key is a combination of the uid and order_line_item_id columns. Be sure to update your queries.

July 2021

We now use the id column as the primary key in the DISPUTE table. We will deprecate the dispute_id column from the DISPUTE table after October 15, 2021, to support Square's API changes. Be sure to update your queries. For more information about Disputes, see .

June 2021

We have updated our OAuth scopes to support the Disputes endpoint of the Square API. You must re-authorize the connector. On your Connector Details page, go to the Setup tab, click Edit connection details, and then click Re-authorize connection. See for more information.

March 2021

We have updated our OAuth scopes to support the Cash Drawer, Loyalty, and Labor-Shift endpoints of the Square API. You must re-authorize the connector. On your Connector Details page, go to the Setup tab, click Edit connection details, and then click Re-authorize connection. See for more information.

We have added a new table, SHIFTS. See for more information.

We have added two new tables, CASH_DRAWER and CASH_DRAWER_EVENT. See for more information.

We have added two new tables, DISPUTES and DISPUTES_EVIDENCE. See for more information.

We have added six new tables:

LOYALTY_PROGRAM
LOYALTY_PROGRAM_ACCRUAL_RULE
LOYALTY_PROGRAM_REWARD_TIER
LOYALTY_ACCOUNT
LOYALTY_ACCOUNT_MAPPING
LOYALTY_REWARD

See for more information.

January 2021

We have added a new column, customer_id, to the ORDER table. See for more information.

We have added two new columns, present_at_location_ids and absent_at_location_ids, to the CATALOG_OBJECT table.

August 2020

We have added two new tables, PAYMENT and CARD_PAYMENT_DETAILS.

We have added a new column, payment_id, to the REFUND table.

We have added two new columns, card_type and prepaid_type, to the CARD table.

January 2020

We can now delete records with no OrdersFulfillments from the ORDER_FULFILLMENT table.
You can now configure your Square connector through the . This feature is in BETA and available only for Standard and Enterprise accounts.

August 2019

We have added the following fields to the ORDER table:
- order_source_name
- return_amount
- net_amount
- rounding_adjustment
- created_at
- updated_at
- closed_at
- state
- total_service_charge_money
We have added the uid field to the following tables:
- ORDER_LINE_ITEM
- ORDER_LINE_ITEM_DISCOUNT
- ORDER_LINE_ITEM_MODIFIER
- ORDER_LINE_ITEM_TAX
We have added the order_id field to the TENDER and REFUND tables.
We have added the following tables to the Square schema:
- ORDER_RETURN
- ORDER_RETURN_DISCOUNT
- ORDER_RETURN_LINE_ITEM
- ORDER_RETURN_LINE_ITEM_MODIFIER
- ORDER_RETURN_SERVICE_CHARGE
- ORDER_RETURN_TAX
- ORDER_SERVICE_CHARGE
In order to incorporate , we will deprecate the TRANSACTION table in the future. All the data in the TRANSACTION table will be available in the ORDER table.

April 2019

is a financial services, merchant services aggregator, and mobile payment company.