Release Notes
August 2023
The Lightspeed Retail connector now supports table blocking for all Lightspeed Retail tables. You can now choose which tables to sync and which to block from syncing to your destination. On your Connector Details page, go to the Schema tab and select or deselect the tables.
If you want to sync a child table, you must include the parent table in the sync.
September 2022
We have added two new columns, secondary_email_address
and secondary_email_useType
, to the SHIP_TO
table.
April 2020
You can now configure your Lightspeed Retail connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
January 2020
We have added five new history tables to replace the following tables:
ATTRIBUTE_VALUE_HISTORY
will replaceATTRIBUTE_VALUE
.ITEM_MATRIX_PRICE_HISTORY
will replaceITEM_MATRIX_PRICE
.ITEM_MATRIX_TAG_HISTORY
will replaceITEM_MATRIX_TAG
.ITEM_PRICE_HISTORY
will replaceITEM_PRICE
.ITEM_TAG_HISTORY
will replaceITEM_TAG
.
We will update all ten tables for three months, then discontinue the replaced tables. Be sure to update your queries with the new history table names before we remove the old tables.
August 2019
We have added a new table, SHIP_TO_PHONE_HISTORY
to support multiple phone numbers for a single SHIP_TO_HISTORY
record.
The SHIP_TO_HISTORY
table will no longer contain phone_number
and phone_use_type
columns. You need to join the two tables (SHIP_TO_PHONE_HISTORY
and SHIP_TO_HISTORY
) for this information.
February 2019
Lightspeed Retail is a cloud-based point of sale (POS) solution that is suitable for retailers.