Shopify + Go Fig

Operations

Connect Shopify to Go Fig for complete e-commerce analytics and financial reporting.

Shopify is the operational source of truth for millions of DTC and multi-brand ecommerce businesses, from $5M boutiques to $500M roll-ups on Shopify Plus. The problem for finance is that Shopify's analytics answer merchandising questions (which SKUs sold, what is repeat purchase rate) but do not reconcile to the general ledger, do not net refunds, discounts, gift cards, and gateway fees out to gross margin, and do not tie orders to the paid-acquisition spend that generated them. Go Fig connects via the Shopify Admin GraphQL API 2024-10, lands orders, line items, refunds, discounts, customers, products, variants, inventory, fulfillments, and the full finance summary endpoint in your Financial Intelligence Graph, and joins to paid-acquisition channels (Meta, Google, TikTok, Klaviyo), accounting (QuickBooks, NetSuite, Xero), and subscription systems (Stripe, Recharge). Celeste and your AI financial analysts can then produce true contribution margin by SKU, cohort LTV and payback at the customer level, channel-level CAC reconciled to realized orders, and a daily Shopify-to-bank reconciliation for month-end close. Shopify Plus multi-store configurations are supported natively.

Connect Shopify See All Integrations

Key facts

API: Shopify Admin GraphQL 2024-10
Grain: Order, line item, customer, product, variant
Multi-store: Shopify Plus multi-store supported
Sync cadence: 15-minute incremental (webhook-driven)
Historical backfill: Full store history from launch

SOC 2 Type II · All integrations

What you can do with Shopify data in Go Fig

True SKU contribution margin

Calculate gross margin by SKU and variant net of refunds, discounts, gift cards, payment-processing fees, shipping costs, and COGS from your accounting system so merchandising decisions reflect real profit, not gross revenue.

Cohort LTV and payback

Segment customer cohorts by first-order month, acquisition channel, or product line and calculate LTV, retention, and payback using the full order history joined to Shopify Pay, Klaviyo, and paid-media spend.

Daily Shopify-to-bank reconciliation

Automate the daily reconciliation from Shopify gross sales through refunds, gateway fees, and chargebacks to the actual deposit in your bank account, eliminating the most time-consuming task in DTC month-end close.

Data available from Shopify

Go Fig extracts and normalizes the following data from your Shopify account:

Orders and order line items

Refunds and return line items

Discounts and discount codes

Customers and customer tags

Products, variants, and collections

Inventory levels by location

Fulfillments and tracking

Gift cards and store credit

Transactions and payment gateway fees

Draft orders and abandoned checkouts

Shipping rates and zones

Shopify Payments payouts and disputes

How to connect Shopify

Install the Go Fig app from the Shopify App Store

Open the Shopify App Store, search for Go Fig, and click Add app. You will be redirected to your Shopify admin to approve read-only scopes for orders, customers, products, inventory, fulfillments, and reports. Shopify Plus organizations can grant access to multiple stores in one flow.

Select stores and historical backfill window

Multi-brand Shopify Plus setups typically have 3 to 15 stores. Pick which stores belong in finance reporting (usually all of them for consolidated reporting) and whether to backfill full history or just the last 24 months. Full history backfill can take several hours on large stores but gives you a forever cohort LTV curve from the store's launch date.

Map Shopify accounts to the chart of accounts

Shopify's finance summary breaks revenue, discounts, refunds, shipping, tax, and gateway fees into standard lines. Go Fig pre-suggests a mapping from those lines to your QuickBooks, NetSuite, or Xero chart-of-accounts based on typical DTC configurations. Review and override where your chart uses non-standard account naming.

Join to paid media and accounting for closed-loop economics

If Meta Ads, Google Ads, TikTok Marketing, Klaviyo, or your accounting connector is live, Go Fig ties Shopify orders to paid-acquisition spend by UTM, GCLID, FBCLID, and customer email. The Shopify starter dashboard populates on first sync with contribution margin by SKU, cohort LTV, channel-level ROAS, and daily bank reconciliation.

Authentication: OAuth 2.0 via Shopify App Store. Scopes requested are read_orders, read_customers, read_products, read_inventory, read_fulfillments, and read_reports. For Shopify Plus merchants, the same OAuth flow grants access to multiple stores under one Organization. The app is published on the Shopify App Store so no custom app setup is required.

Common Questions About Shopify Integration

How does Go Fig reconcile Shopify orders to bank deposits?

Shopify Payments bundles multiple orders into a single bank deposit, net of refunds, chargebacks, and processing fees, on a 1 to 3 day delay depending on your country and payout schedule. Go Fig pulls the Shopify Payments payout endpoint, which maps each deposit to the underlying order IDs, refunds, and fees. Joined to your bank feed (via QuickBooks, NetSuite, or Xero bank sync), the daily reconciliation runs automatically. Variances over $100 or 1 percent are flagged for review.

Can Go Fig calculate true contribution margin by SKU?

Yes, provided COGS is available in your accounting system or imported as a CSV. Go Fig combines order-level revenue with Shopify-level discounts, refunds, shipping costs, and gateway fees, plus SKU-level COGS from QuickBooks, NetSuite, or Xero (or an uploaded spreadsheet), to produce a contribution margin line for every SKU, variant, and collection. Celeste can answer 'which SKUs lost margin after the discount campaign' in natural language.

How does Go Fig handle multi-currency Shopify stores?

Shopify Markets supports multi-currency presentment and settlement, and Go Fig captures both the presentment currency (what the customer paid in) and the settlement currency (what you received). All revenue is normalized to your reporting currency at the daily exchange rate, with the original-currency values preserved as columns so finance can drill back to the original transaction.

Does Go Fig support Shopify Plus multi-store and B2B?

Yes. Shopify Plus Organizations with multiple stores are connected via one OAuth, and Go Fig preserves store ID as a column so consolidated and per-brand reporting both work cleanly. Shopify B2B orders (company, location, payment terms, net 30 invoicing) are captured at full detail, so finance can track DTC and wholesale channels side by side in one Financial Intelligence Graph.

What is the sync cadence and historical backfill?

Go Fig subscribes to Shopify webhooks for orders, refunds, fulfillments, and inventory, so critical events land in the Financial Intelligence Graph within seconds. A reconciling incremental sync runs every 15 minutes to catch any missed webhooks. Historical backfill covers the store's full history from launch and stores it permanently, which is the basis for the forever-cohort LTV view that finance teams typically cannot produce inside Shopify's own analytics.