Configuring Seal Subscriptions Exports

Overview

After connecting Seal, use the Export Builder to create exports by data type. Each export can include one or more tabs — Subscriptions, Subscription Items, Billing Attempts, Invoices, Fulfillment Orders, or Subscription Rules — and writes to a single Google Sheets spreadsheet, BigQuery dataset, or Excel file.

Prerequisites

• Seal Subscriptions connected (see Connecting Seal Subscriptions)
• A Google Sheets, BigQuery, or Microsoft Excel destination configured

Create an export

1. Go to Export Builder and create a new export.
2. Select Seal Subscriptions as the source and choose your connected shop.
3. Select a destination (Google Sheets, BigQuery, or Excel).
4. Give the export a name.
5. On the configuration page, choose a date range and select the data tabs and columns you want.
6. Save the export and run it manually to validate the output.

Available data tabs

Each tab writes to its own sheet tab, Excel worksheet, or BigQuery table.

• Subscriptions: subscription records with customer, shipping, billing address, payment metadata, delivery method, status, and intervals.
• Subscription Items: line items on each subscription — product, variant, quantity, pricing, discounts, and selling plan.
• Billing Attempts: scheduled and completed billing attempts, including status and error details.
• Invoices: recurring-invoice rows nested under each subscription (flattened; includes a full JSON payload column).
• Fulfillment Orders: prepaid fulfillment orders nested under each subscription (flattened; includes a full JSON payload column).
• Subscription Rules: Seal subscription rules / selling plans linked to products and variants.

Enable only the tabs you need. Subscription-derived tabs are fetched together from Seal in one pass, then written separately for each enabled tab.

Full column lists: Seal Subscriptions data reference.

Available export fields

Use column selection in each tab to choose fields. Full column lists and descriptions: Seal Subscriptions data reference.

Selecting detail-only subscription fields (customer id, card details, delivery method, nested invoices/fulfillment arrays, tags, and related) triggers per-subscription enrichment and can slow large exports.

Date presets

Seal exports support the same date range presets available in other exporters:

• Since last export — incremental; uses the timestamp of the last successful run as the start point.
• Today, Yesterday, Last 7 days, Last 30 days, etc. — fixed windows recalculated at run time.
• This month / Last month / This quarter — calendar-aligned windows.
• Maximum — last 2 years; useful for initial loads.
• Custom range: pick exact From and To dates (maximum 1 year). One-time only: scheduled runs are paused while this is selected. Use Run now. Subscription Rules still export in full (they are not date-filtered).

Filter subscriptions by

• Order placed date (default) — scans subscriptions and keeps those whose order_placed falls in the range.
• Billing date — uses Seal’s subscriptions-by-billing-date API to return subscriptions that have at least one billing attempt in the range. Prefer this for large shops or upcoming-charge reporting.

Column selection

For each tab, use the column picker to select only the fields you need. Selecting fewer columns keeps your destination leaner and exports faster.

Some Subscriptions fields (such as customer_id, notes, tags, card details) and the Invoices / Fulfillment Orders tabs may make the export take longer.

Add the Date Exported column (exportDate) to any tab to record the timestamp when each export ran — useful for tracking data freshness in dashboards.

Append vs replace

• Replace: overwrites the tab output on every run. Best for Subscriptions and Subscription Rules snapshot-style tabs.
• Append: adds new rows to existing output without removing old rows. Useful for Billing Attempts when combined with Since last export.

Editing an export

You can change date preset, selected columns, and append settings from the export detail page at any time. Changes take effect on the next run.

Scheduling

After validating a manual run, set up a schedule from the export detail page. Choose a frequency (daily, weekly, etc.) and a time of day. SyncRange will run the export automatically.

See Setting Export Schedules for full details.