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 replace ATTRIBUTE_VALUE.
• ITEM_MATRIX_PRICE_HISTORY will replace ITEM_MATRIX_PRICE.
• ITEM_MATRIX_TAG_HISTORY will replace ITEM_MATRIX_TAG.
• ITEM_PRICE_HISTORY will replace ITEM_PRICE.
• ITEM_TAG_HISTORY will replace ITEM_TAG.

We will update all ten tables for three months, then deprecate 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.

Read our Lightspeed Retail connector documentation.