March 2026


Shopify: History tables for 19 streams

We've added history table support across 19 Shopify and Shopify Plus streams. History tables use an SCD Type 4 (Slowly Changing Dimensions) approach — your main table always reflects the latest state, while a separate append-only history table records every change over time.

Each history table is protected and runs in append mode, so existing rows are never overwritten or deleted. Every sync captures a snapshot of changed records, letting you reconstruct the state of any entity at any point in time.

This is useful for:

  • Tracking price changes on products and variants
  • Auditing customer profile updates
  • Monitoring inventory level movements across locations
  • Analyzing order lifecycle changes

To learn more about history tables and slowly changing dimensions, see our blog post on Slowly Changing Dimensions.

Changelog

19 total changes

Table/columnChange typeNotes
abandoned_checkout_historyNew tableAbandoned checkout changes over time
collection_historyNew tableProduct collection updates
company_historyNew tableB2B company profile changes
customer_historyNew tableCustomer profile updates
customer_metafield_historyNew tableCustomer metafield changes
discount_code_historyNew tableDiscount code modifications
draft_order_historyNew tableDraft order changes
fulfillment_order_historyNew tableFulfillment status transitions
inventory_item_historyNew tableInventory item attribute changes
inventory_level_historyNew tableStock level changes across locations
line_item_group_historyNew tableLine item group modifications
order_historyNew tableOrder lifecycle changes
order_metafield_historyNew tableOrder metafield changes
order_return_historyNew tableReturn status and detail changes
price_rule_historyNew tablePricing rule updates
product_historyNew tableProduct detail changes
product_image_historyNew tableProduct image updates
product_metafield_historyNew tableProduct metafield changes
product_variant_historyNew tableVariant-level changes (price, SKU, etc.)

How to enable

Enabling Shopify history tables in Weld
  1. Go to Settings → Connectors and select your Shopify connection.
  2. In the table selection panel, search for history.
  3. Select the history tables you need and save.

Weld will begin appending historical snapshots on the next sync.


New features

New Connector: Klarna

Full sync support for transaction, payout, and payout_summary streams.

Klarna connector documentation →

3 total changes

Table/columnChange typeNotes
transactionNew table
payoutNew table
payout_summaryNew table

New Connector: PayPal

Sync balances, invoices, transactions, billing_plans, subscriptions, and disputes from PayPal.

PayPal connector documentation →

6 total changes

Table/columnChange typeNotes
balancesNew table
invoicesNew table
transactionsNew table
billing_plansNew table
subscriptionsNew table
disputesNew table

Model Import & Export (with dbt support)

You can now import and export SQL models as zip files through the UI or API. Weld automatically detects and converts dbt projects (dbt_project.yml) into Weld-native dependencies.

Model Import & Export documentation →

Usage Dashboard & Forecasting

A new Usage Dashboard for tracking Monthly Active Rows (MAR) and synced rows, with historical usage trends and AI-driven consumption forecasting.

Retired Stream Tags

Data streams deprecated by their platform are now visually tagged as "Retired" in the Weld UI.

CDC for Free Trials

Change Data Capture (CDC) replication is now enabled for free trial accounts, with engine improvements to prevent timestamp collisions and improve data ordering.


Connector updates

  • API Upgrade: Upgraded to the v23 API.
  • New Stream: Added SEARCH_TERM_STATS.
  • Quality Scores: Added quality_info (including Quality Scores) to ad group criteria.

2 total changes

Table/columnChange typeNew nameNotes
SEARCH_TERM_STATSNew table
ad_group_criteria
columnNew Columnquality_infoIncludes Quality Scores

Google Search Console & Reddit Ads

Custom reporting capabilities for both platforms — configure your own dimensions, aggregations, and breakdowns in integration settings.

Amazon Selling Partner & Amazon Ads

  • Upgraded to the searchOrders API for more reliable order syncing.
  • Added unified hourly campaign reports, associated orders, and new buyer details (email, name, PO number).

4 total changes

Table/columnChange typeNew nameNotes
order
columnNew Columnbuyer_email
columnNew Columnbuyer_name
columnNew Columnpurchase_order_number
hourly_campaign_reportNew tableUnified hourly campaign reports

Shopify

  • Optimized incremental syncs for faster product updates.
  • Added lineItem details to order agreements and featured_media_id to products.

2 total changes

Table/columnChange typeNew nameNotes
order_agreement
columnNew ColumnlineItemLine item details on order agreements
product
columnNew Columnfeatured_media_id

HubSpot

  • New Stream: account_details.
  • Expanded Marketing Email content.
  • Support for generic v4 Custom Objects association tables.

1 total change

Table/columnChange typeNotes
account_detailsNew table

Facebook Ads & Microsoft Ads

  • Added multi-account backfill support.
  • Improved API resilience to prevent transient errors from failing syncs.
  • Fixed Microsoft Ads report parsing to natively exclude headers and footers.

TikTok Shop

  • New Stream: STATEMENT_TRANSACTION_REPORT — fixes empty legacy finance tables.

1 total change

Table/columnChange typeNotes
STATEMENT_TRANSACTION_REPORTNew tableReplaces legacy finance tables

Zendesk

  • Added ticket_side_conversation and ticket_side_conversation_event streams.

2 total changes

Table/columnChange typeNotes
ticket_side_conversationNew table
ticket_side_conversation_eventNew table

GoHighLevel

  • Added conversation and message streams.

2 total changes

Table/columnChange typeNotes
conversationNew table
messageNew table

AppLovin

  • Added daily and hourly advertiser_campaign_report streams.

2 total changes

Table/columnChange typeNotes
advertiser_campaign_report_dailyNew table
advertiser_campaign_report_hourlyNew table

Xero

  • Added toggle for advanced plan features and more granular permission scopes.

Platform & destination improvements

Smarter Reverse ETL

Row-level destination errors are now tolerated and logged rather than triggering a complete sync failure. Excel table replacements are dramatically faster.

BigQuery zero-downtime updates

Atomic swap mechanism for BigQuery when table partitioning changes — tables are created and swapped seamlessly with no downtime. Includes automatic cleanup for temporary tables.

Snowflake reliability

Fixed a timeout issue causing a dead loop when syncing large files, and added intelligent upload retries.

Postgres optimization

Prevented timeouts during massive MERGE operations and optimized full syncs to skip temporary primary key overhead.


Bug fixes

  • Fixed pagination limits and API timeouts across GoHighLevel, Netvisor, Mixpanel, and the Facebook Graph API.
  • Fixed timestamp parsing bug where trailing spaces or newlines (e.g. from HubSpot) broke column formatting.
  • Fixed Amazon Vendor Central connection form incorrectly blocking standard Seller authentication.
  • Resolved Snapchat Ads start/end time conflicts in reports.
  • System notifications for sync errors now re-alert after 24 hours if left undismissed.

Was this page helpful?