Release Notes
August 2025
Effective August 18, 2025 we use a new August 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.
We are updating the connector schema to enhance its usability.
3 total changes • 0 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
RETURN | |||||
column | New Column | grand_total_formatted_value | |||
column | New Column | grand_total_value | |||
column | New Column | grand_total_value_in_cent |
Effective August 25, 2025 we use a new August 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.
We are updating the connector schema to enhance its usability.
2 total changes • 2 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ORDER_LINE | |||||
column | Discontinued Column | order_updated_at 🔑 | No longer primary key | ||
ORDERS | |||||
column | Primary Key Change | updated_at 🔑 | updated_at | No longer primary key |
June 2025
We have changed the sync strategy for the ORDERS
and PRODUCT_VARIANT
tables. We now re-import the ORDERS
table weekly and the PRODUCT_VARIANT
table daily.
January 2025
Lite connectors are now available for the following sources:
- Ashby
- Bing Webmaster Tools
- Canvas Data 2 by Instructure
- Centra
- Cloudbeds
- CloudTalk
- Cornerstone
- Deposco
- Donus
- G2
- Hilti On!Track
- Jama Software
- Khoros Marketing
- Leap CRM
- Qmatic Data Connect
- Quorum
- ShareASale
- Venminder
- Workleap Officevibe
- Zoho Inventory
Effective January 30, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.
We have made these schema changes to improve schema usability.
39 total changes • 0 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CAMPAIGN | |||||
table | New Table | CAMPAIGN | |||
CAMPAIGN_VARIANT | |||||
table | New Table | CAMPAIGN_VARIANT | |||
LOWEST_PRICE | |||||
table | New Table | LOWEST_PRICE | |||
LOWEST_PRICE_MARKET | |||||
table | New Table | LOWEST_PRICE_MARKET | |||
MARKET | |||||
table | New Table | MARKET | |||
MARKET_ASSIGNED_TO_COUNTRY | |||||
table | New Table | MARKET_ASSIGNED_TO_COUNTRY | |||
ORDER_LINE | |||||
column | New Column | line_campaign_discount_conversion_date | |||
column | New Column | line_campaign_discount_conversion_rate | |||
column | New Column | line_campaign_discount_formatted_value | |||
column | New Column | line_campaign_discount_percent | |||
column | New Column | line_campaign_discount_value | |||
column | New Column | line_campaign_discount_value_in_cents | |||
column | New Column | line_campaign_fixed_price_conversion_date | |||
column | New Column | line_campaign_fixed_price_conversion_rate | |||
column | New Column | line_campaign_fixed_price_formatted_value | |||
column | New Column | line_campaign_fixed_price_value | |||
column | New Column | line_campaign_fixed_price_value_in_cents | |||
column | New Column | line_campaign_id | |||
column | New Column | line_campaign_name | |||
column | New Column | line_campaign_original_discount_conversion_date | |||
column | New Column | line_campaign_original_discount_conversion_rate | |||
column | New Column | line_campaign_original_discount_formatted_value | |||
column | New Column | line_campaign_original_discount_value | |||
column | New Column | line_campaign_original_discount_value_in_cents | |||
column | New Column | line_campaign_show_news | |||
column | New Column | line_campaign_show_sale | |||
column | New Column | line_campaign_start_at | |||
column | New Column | line_campaign_stop_at | |||
column | New Column | line_campaign_type | |||
column | New Column | line_value_conversion_date | |||
column | New Column | line_value_conversion_rate | |||
column | New Column | line_value_formatted_value | |||
column | New Column | line_value_value | |||
column | New Column | line_value_value_in_cents | |||
ORDERS | |||||
column | New Column | billing_address_country_id | |||
column | New Column | shipping_address_country_id | |||
PRODUCT_VARIANT | |||||
column | New Column | external_id | |||
PRODUCT_VARIANT_DISPLAY | |||||
table | New Table | PRODUCT_VARIANT_DISPLAY | |||
PRODUCT_VARIANT_MEDIA | |||||
table | New Table | PRODUCT_VARIANT_MEDIA |