Release Notes
November 2025
Effective November 21, 2025 we use a new November 2025 schema. Review the latest ERD to better understand the schema changes.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 fix a bug.
17 total changes • 17 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ARRIVAL_LINE_ITEM | |||||
| column | Type Change | quantity | Data type changed from LONG to DOUBLE. | ||
| column | Type Change | received_quantity | Data type changed from LONG to DOUBLE. | ||
FULFILLMENT_LINE_ITEM | |||||
| column | Type Change | bundle_quantity | Data type changed from INSTANT to STRING. | ||
| column | Type Change | quantity | Data type changed from LONG to DOUBLE. | ||
ORDER_LINE_ITEM | |||||
| column | Type Change | quantity | Data type changed from LONG to DOUBLE. | ||
PRODUCT_BUNDLE_ITEM | |||||
| column | Type Change | quantity | Data type changed from LONG to DOUBLE. | ||
PURCHASE_COST | |||||
| column | Type Change | quantity | Data type changed from LONG to DOUBLE. | ||
PURCHASE_LINE_ITEM | |||||
| column | Type Change | quantity | Data type changed from LONG to DOUBLE. | ||
| column | Type Change | received_quantity | Data type changed from LONG to DOUBLE. | ||
| column | Type Change | shipped_quantity | Data type changed from LONG to DOUBLE. | ||
RECEIPT_LINE_ITEM | |||||
| column | Type Change | quantity | Data type changed from LONG to DOUBLE. | ||
SHIPMENT_LINE_ITEM | |||||
| column | Type Change | bundle_quantity | Data type changed from LONG to DOUBLE. | ||
| column | Type Change | quantity | Data type changed from LONG to DOUBLE. | ||
| column | Type Change | shipped_quantity | Data type changed from LONG to DOUBLE. | ||
TRANSFER_LINE_ITEM | |||||
| column | Type Change | quantity | Data type changed from LONG to DOUBLE. | ||
| column | Type Change | received_quantity | Data type changed from LONG to DOUBLE. | ||
| column | Type Change | shipped_quantity | Data type changed from LONG to DOUBLE. | ||
Effective November 28, 2025 we use a new November 2025 schema. Review the latest ERD to better understand the schema changes.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 fix a bug.
1 total changes • 1 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
INVENTORY | |||||
| column | Type Change | quantity | Data type changed from LONG to DOUBLE. | ||
June 2025
Effective June 6, 2025 we use a new June 2025 schema. Review the latest ERD to better understand the schema changes.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.
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: