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:
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:
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
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
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:
# 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"