Release Notes

June 2025

Effective June 6, 2025 we use a new June 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.

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.

18 total changes • 17 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ARRIVAL_LINE_ITEM`
column	Primary Key Change	`arrival_id`	`arrival_id` 🔑	Added to primary key.
`CONNECTOR_ENTITY`
column	Primary Key Change	`connector_id`	`connector_id` 🔑	Added to primary key.
`FULFILLMENT_LINE_ITEM`
column	Primary Key Change	`fulfillment_id`	`fulfillment_id` 🔑	Added to primary key.
column	Primary Key Change	`sku`	`sku` 🔑	Added to primary key.
column	New Column		`bundle_quantity_partial`
`FULFILLMENT_LINE_ITEM_BUNDLE_QUANTITY_PARTIAL`
table	Discontinued Table	`FULFILLMENT_LINE_ITEM_BUNDLE_QUANTITY_PARTIAL`		Data is available in the `bundle_quantity_partial` column of the `FULFILLMENT_LINE_ITEM` table.
`FULFILLMENT_TRACKING_NUMBER`
column	Primary Key Change	`fulfillment_id`	`fulfillment_id` 🔑	Added to primary key.
`FULFILLMENT_TRACKING_URL`
column	Primary Key Change	`fulfillment_id`	`fulfillment_id` 🔑	Added to primary key.
`ORDER_DISCOUNT`
column	Primary Key Change	`line_item_id` 🔑	`line_item_id`	No longer a primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`PRODUCT_PUBLISHED`
column	Primary Key Change	`sku` 🔑	`sku`	No longer a primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`PURCHASE_LINE_ITEM`
column	Primary Key Change	`purchase_id`	`purchase_id` 🔑	Added to primary key.
`RECEIPT_LINE_ITEM`
column	Primary Key Change	`receipt_id`	`receipt_id` 🔑	Added to primary key.
`SHIPMENT_LINE_ITEM`
column	Primary Key Change	`shipment_id`	`shipment_id` 🔑	Added to primary key.
`SHIPPING_METHOD_MAPPED_METHOD`
column	Primary Key Change	`shipping_method_id`	`shipping_method_id` 🔑	Added to primary key.
`SUPPLIER_CONTACT`
column	Primary Key Change	`supplier_id`	`supplier_id` 🔑	Added to primary key.
`TRANSFER_LINE_ITEM`
column	Primary Key Change	`transfer_id`	`transfer_id` 🔑	Added to primary key.

December 2024

Lite connectors are now available for the following sources: