Shopify Integration

A comprehensive accounting-first integration for Shopify stores, providing revenue recognition, bank reconciliation, fee tracking, and financial reporting.

What Gets Synced

Data Description
Orders Revenue recognition with journal entries
Payouts Bank reconciliation matching
Products Inventory and COGS tracking
Customers Customer balances and AR aging
Refunds Refund journal entries
Gift Cards Liability tracking
Disputes Reserve management

Connect Shopify

Option 1: OAuth (Recommended)

From the Integrations page in DayZero, enter your Shopify shop domain and click Connect Shopify. You'll be redirected to Shopify to authorize access.

Or via API:

bash
curl "https://api.ondayzero.com/api/v1/shopify/install-url?shop=your-store" \
  -H "Authorization: Bearer dz_your_token_here" \
  -H "x-business-id: YOUR_BUSINESS_ID"

The response includes an install_url. Redirect the merchant to that URL to begin the OAuth flow. After authorization, DayZero registers webhooks and begins syncing.

Option 2: Manual Access Token

If you have a Shopify custom app access token:

bash
curl -X POST "https://api.ondayzero.com/api/v1/shopify/setup" \
  -H "Authorization: Bearer dz_your_token_here" \
  -H "x-business-id: YOUR_BUSINESS_ID" \
  -H "Content-Type: application/json" \
  -d '{"shop": "your-store.myshopify.com", "access_token": "shpat_..."}'

Automatic Accounting

When an order is placed, DayZero automatically creates journal entries for:

  • Revenue: Debit AR / Credit Sales Revenue
  • COGS: Debit COGS / Credit Inventory (if tracked)
  • Tax: Debit AR / Credit Sales Tax Payable
  • Fees: Debit Processing Fees / Credit Cash

Payout Reconciliation

Shopify payouts are matched against bank deposits for reconciliation. Each payout includes a breakdown of orders, refunds, fees, and adjustments.

Sync Status

bash
curl "https://api.ondayzero.com/api/v1/shopify/status" \
  -H "Authorization: Bearer dz_your_token_here" \
  -H "x-business-id: YOUR_BUSINESS_ID"

Returns connection health, order/product counts, and last sync timestamp.

Disconnect

bash
curl -X DELETE "https://api.ondayzero.com/api/v1/shopify/disconnect" \
  -H "Authorization: Bearer dz_your_token_here" \
  -H "x-business-id: YOUR_BUSINESS_ID"

Revokes the access token, removes webhooks, and clears the integration from the business.

Manual Import

To re-import products or pull all orders on demand:

bash
# Import products
curl -X PUT "https://api.ondayzero.com/api/v1/shopify/import" \
  -H "Authorization: Bearer dz_your_token_here" \
  -H "x-business-id: YOUR_BUSINESS_ID"

# Import orders
curl -X POST "https://api.ondayzero.com/api/v1/shopify/import-orders" \
  -H "Authorization: Bearer dz_your_token_here" \
  -H "x-business-id: YOUR_BUSINESS_ID"