Release Notes

April 2025

Effective April 19, 2025 we use a new April 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 prevent or resolve data integrity issues.

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.

36 total changes • 36 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ADD_ON_SERVICE`
column	Primary Key Change	`add_on_service` 🔑	`add_on_service`	No longer a primary key.
column	Primary Key Change		`product_id` 🔑	New primary key.
`FEED_ITEM_DETAIL`
column	Primary Key Change	`mart_id` 🔑	`mart_id`	No longer a primary key.
`FULFILLMENT_ORDER_SHIPMENT`
column	Primary Key Change	`tracking_no` 🔑	`tracking_no`	No longer a primary key.
`FULFILLMENT_ORDER_SHIPMENT_DATE`
column	Primary Key Change	`datetype_id` 🔑	`datetype_id`	No longer a primary key.
column	Primary Key Change		`seller_order_id` 🔑	New primary key.
`FULFILLMENT_ORDER_SHIPMENT_LINE`
column	Primary Key Change	`fulfiller_line_id` 🔑	`fulfiller_line_id`	No longer a primary key.
column	Primary Key Change	`shipment_line_no` 🔑	`shipment_line_no`	No longer a primary key.
column	Primary Key Change		`index` 🔑	New primary key.
column	Primary Key Change		`seller_order_id` 🔑	New primary key.
`FULFILLMENT_ORDER_STATUS`
column	Primary Key Change	`order_channel_id` 🔑	`order_channel_id`	No longer a primary key.
`ITEM_SEARCH`
table	Discontinued Table	`ITEM_SEARCH`
`ITEM_SEARCH_CATEGORY`
table	Discontinued Table	`ITEM_SEARCH_CATEGORY`
`ITEM_SEARCH_DATA_VARIANT_VALUE`
table	Discontinued Table	`ITEM_SEARCH_DATA_VARIANT_VALUE`
`ITEM_SEARCH_IMAGE`
table	Discontinued Table	`ITEM_SEARCH_IMAGE`
`ITEM_SEARCH_PROPERTY_VARIANT_DATA`
table	Discontinued Table	`ITEM_SEARCH_PROPERTY_VARIANT_DATA`
`ITEM_SEARCH_PROPERTY_VARIANT_META`
table	Discontinued Table	`ITEM_SEARCH_PROPERTY_VARIANT_META`
`ITEM_UNPUBLISHED_REASON`
column	Primary Key Change	`unpublished_reason` 🔑	`unpublished_reason`	No longer a primary key.
`RETURN_LINE`
column	Primary Key Change		`customer_order_id` 🔑	New primary key.
`RETURN_LINE_GROUP`
column	Primary Key Change		`customer_order_id` 🔑	New primary key.
`RETURN_LINE_GROUP_CARRIER_INFO_LIST`
column	Rename Column	`index` 🔑	`return_line_label_index` 🔑
column	Primary Key Change		`customer_order_id` 🔑	New primary key.
column	Primary Key Change		`return_line_group_index` 🔑	New primary key.
`RETURN_LINE_LABEL`
column	Primary Key Change		`customer_order_id` 🔑	New primary key.
`RETURN_ORDER_LINE`
column	Primary Key Change	`purchase_order_id` 🔑	`purchase_order_id`	No longer a primary key.
`RETURN_ORDER_LINE_CHARGE_REFERENCE`
column	Primary Key Change		`return_order_line_index` 🔑	New primary key.
`RETURN_ORDER_LINE_CHARGE_TAX`
column	Primary Key Change		`return_order_line_index` 🔑	New primary key.
`RETURN_ORDER_LINE_TRACKING_REFERENCE`
column	Rename Column	`return_order_tracking_index` 🔑	`return_order_line_tracking_detail_index` 🔑
column	Primary Key Change		`return_order_line_index` 🔑	New primary key.
`SHIPPING_CONFIGURATION`
column	Primary Key Change	`partner_id` 🔑	`partner_id`	No longer a primary key.
column	Primary Key Change		`_fivetran_id` 🔑	New primary key.
`SHIPPING_CONFIGURATION_CATEGORY`
column	Discontinued Column	`partner_id` 🔑		No longer a primary key.
column	Primary Key Change		`shipping_configuration_fivetran_id` 🔑	New primary key.
`SHIPPING_CONFIGURATION_DETAIL`
column	Discontinued Column	`partner_id` 🔑		No longer a primary key.
column	Discontinued Column	`partner_name` 🔑		No longer a primary key.
column	Primary Key Change		`shipping_configuration_fivetran_id` 🔑	New primary key.

November 2024

Lite connectors are now available for the following sources: