Daily Financials

Daily financials are the backbone of DealDome's P&L tracking. Each record captures a single day's numbers for a specific store — revenue, COGS, shipping, ad spend, transaction fees, and net profit. This gives you a granular, day-by-day view of how your business is performing.

The POST endpoint performs an upsert based on the date + store combination. If a record already exists for that date and store, it will be updated rather than duplicated.

The daily financial model

Each daily financial record represents one day of performance data for a single store.

Properties

Name
id
Type
integer
Description
Unique identifier for the record.
Name
date
Type
string
Description
The date this record covers, in YYYY-MM-DD format.
Name
store
Type
string
Description
The store identifier (e.g., your Shopify store name).
Name
revenue
Type
number
Description
Total revenue for the day.
Name
cogs
Type
number
Description
Cost of goods sold.
Name
shipping_cost
Type
number
Description
Total shipping costs for the day.
Name
ad_spend
Type
number
Description
Total advertising spend for the day.
Name
transaction_fees
Type
number
Description
Payment processor and transaction fees.
Name
net_profit
Type
number
Description
Net profit after all costs are deducted.
Name
created_at
Type
timestamp
Description
Timestamp of when the record was created.

GET/financials/daily

List daily financials

This endpoint returns daily financial records. You can filter by date range and store to drill down into specific periods or stores.

Optional attributes

Name
start
Type
string
Description
Start date in YYYY-MM-DD format.
Name
end
Type
string
Description
End date in YYYY-MM-DD format.
Name
store
Type
string
Description
Filter by store identifier.
Name
limit
Type
integer
Description
Limit the number of records returned.
Name
offset
Type
integer
Description
Offset for pagination.

Request

GET

/financials/daily

curl -G https://api.dealdome.eu/financials/daily \
  -H "Authorization: Bearer {token}" \
  -d start=2026-04-01 \
  -d end=2026-04-13 \
  -d store=my-store

Response

{
  "data": [
    {
      "id": 421,
      "date": "2026-04-13",
      "store": "my-store",
      "revenue": 1245.80,
      "cogs": 312.50,
      "shipping_cost": 89.20,
      "ad_spend": 350.00,
      "transaction_fees": 37.37,
      "net_profit": 456.73,
      "created_at": "2026-04-13T23:59:00Z"
    },
    {
      "id": 420,
      "date": "2026-04-12",
      "store": "my-store",
      "revenue": 980.40,
      "cogs": 245.10,
      "shipping_cost": 72.00,
      "ad_spend": 280.00,
      "transaction_fees": 29.41,
      "net_profit": 353.89,
      "created_at": "2026-04-12T23:59:00Z"
    }
  ]
}

POST/financials/daily

Create or update daily financials

This endpoint creates a new daily financial record or updates an existing one. The upsert is keyed on the date + store combination — if a record already exists for that pair, it gets updated with the new values.

Required attributes

Name
date
Type
string
Description
The date in YYYY-MM-DD format.
Name
store
Type
string
Description
The store identifier.
Name
revenue
Type
number
Description
Total revenue for the day.

Optional attributes

Name
cogs
Type
number
Description
Cost of goods sold.
Name
shipping_cost
Type
number
Description
Total shipping costs.
Name
ad_spend
Type
number
Description
Total ad spend.
Name
transaction_fees
Type
number
Description
Payment processor fees.
Name
net_profit
Type
number
Description
Net profit — calculated automatically if omitted.

Request

POST

/financials/daily

curl https://api.dealdome.eu/financials/daily \
  -H "Authorization: Bearer {token}" \
  -H "Content-Type: application/json" \
  -d '{
    "date": "2026-04-13",
    "store": "my-store",
    "revenue": 1245.80,
    "cogs": 312.50,
    "shipping_cost": 89.20,
    "ad_spend": 350.00,
    "transaction_fees": 37.37
  }'

Response

{
  "id": 421,
  "date": "2026-04-13",
  "store": "my-store",
  "revenue": 1245.80,
  "cogs": 312.50,
  "shipping_cost": 89.20,
  "ad_spend": 350.00,
  "transaction_fees": 37.37,
  "net_profit": 456.73,
  "created_at": "2026-04-13T23:59:00Z"
}