Ganntz Tools — Overview

Revenue

—

gross · incl. tax & shipping

Orders

—

non-cancelled · created in period

Avg Order Value

—

revenue ÷ orders

Ad Spend

—

no data for period

Google · Meta · Pinterest

ROAS

—

revenue ÷ ad spend

Contribution Margin

—

after spend & COGS

Avg COGS

—

% of revenue (avg across stores)

Alert Refunds

—

CDRN · Ethoca · RDR

Customer Refunds

—

of gross revenue

Operating Costs

—

payroll, VA, banking & other

Other Income

—

service fees, cashback, referrals

Revenue & Orders over time

Revenue Orders

Loading…

Top 5 Bestsellers

#	Product	Units	Revenue
Loading…

Top 5 Newcomers Products with no prior order history

#	Product	Units	Revenue
Loading…

Revenue by Store Selected period · refund rate shown

Store	Revenue	Orders	AOV	COG%	Ad Spend	ROAS	Share & Refunds
Loading…

Ad Spend by Platform

No ad spend recorded for this period. Use "+ Enter" above to add spend.

Pending Fulfillment — 14+ Day Orders All stores · Shopify

Order	Store	Customer	Created	Days pending
Loading…

Customer service Orders · CRM · tickets · fulfillment status

read_orders, write_orders, read_customers, write_customers, read_draft_orders, read_fulfillments, read_shipping

Product editing Products · variants · inventory · locations · publishing

read_products, write_products, read_inventory, write_inventory, read_locations, read_publications, write_publications

Fulfillment Fulfillment orders · COGS · shipping · stock levels

read_orders, write_orders, read_fulfillments, write_fulfillments, read_assigned_fulfillment_orders, write_assigned_fulfillment_orders, read_merchant_managed_fulfillment_orders, write_merchant_managed_fulfillment_orders, read_inventory, read_shipping

All tools combined Recommended One token per store covers every tool on this platform

read_all_orders, read_assigned_fulfillment_orders, read_custom_fulfillment_services, read_customers, read_draft_orders, read_files, read_fulfillment_constraint_rules, read_fulfillments, read_gift_cards, read_inventory, write_inventory, read_inventory_shipments, read_inventory_shipments_received_items, read_inventory_transfers, read_locations, read_markets, read_merchant_managed_fulfillment_orders, read_metaobjects, read_order_edits, read_orders, read_payment_mandate, read_payment_notifications, read_payment_terms, read_product_feeds, read_product_listings, read_products, write_products, read_publications, write_publications, read_returns, read_shipping, read_shopify_payments_accounts, read_shopify_payments_bank_accounts, read_shopify_payments_disputes, read_shopify_payments_payouts, read_shopify_payments_provider_accounts_sensitive, read_content, read_third_party_fulfillment_orders

How to generate a Shopify access token (shpat_…)

You need: Client ID, Client Secret, and your myshopify URL — all from the custom app in the Shopify Partner / Admin dashboard.

Get a short-lived authorisation code

Open this URL in a browser (replace the placeholders), click Install app, then copy the code=… value from the redirect URL in your address bar.

https://admin.shopify.com/store/MYSHOPIFY-URL/oauth/authorize?client_id=CLIENT_ID&redirect_uri=https://example.com

Exchange the code for a permanent token in Postman

Create a new POST request to:

https://MYSHOPIFY-URL.myshopify.com/admin/oauth/access_token

Set Body → raw → JSON:

{
  "client_id": "CLIENT_ID",
  "client_secret": "CLIENT_SECRET",
  "code": "PASTE_CODE_FROM_STEP_1"
}

Send — the response contains "access_token": "shpat_…". Copy that value into the token field above.

⚠ The authorisation code from step 1 expires in 60 seconds — complete both steps in one go.

Shopify Stores

Code	Shop Name	myshopify URL	Access Code	Live URL	Country	Lang	Currency	Price Rule	Unit Format	Gender	Date Created	Permissions	Finance
Loading…

Tokens are loaded from /opt/ganntz-shared/secrets.env via systemd EnvironmentFile= — no tokens are stored in application code. A store shows Connected when both SHOPIFY_XX_DOMAIN and SHOPIFY_XX_TOKEN are present.

Source: Google Sheet

Pinterest OAuth token expires ~October 2026 — renew it before then to keep Pinterest ad spend data flowing into the sheet automatically. Go to Pinterest Ads → Settings → API Access to regenerate.

Total Spend

—

Google

—

Google

—

Overview

Platform Metrics

Activity Feed

Quick Links