Technical Implementation

How SP-Dashboard securely connects to and synchronizes data from the Etsy API

Secure Authentication

SP-Dashboard uses OAuth 2.0 with PKCE (Proof Key for Code Exchange) to securely authenticate with SilversagaPatternsFR's Etsy shop. Tokens are stored as environment variables and automatically refreshed to maintain continuous access.

Required API Scopes:

  • transactions_rView transaction history
  • listings_rAccess product listings
  • shops_rRead shop information
  • receipts_rReview order receipts

Intelligent Data Synchronization

Sync Process

  • • Incremental sync every 15 minutes
  • • Cursor-based pagination for efficiency
  • • Only fetches new/updated orders
  • • Automatic retry with exponential backoff

Data Processing

  • • All amounts stored as cents (integers)
  • • SKU mapping for product tracking
  • • Optimized database indexes
  • • Daily sales aggregations

Responsible API Usage

Daily Limit

9,500

of 10,000 QPD (95% safety)

Per Second

10

Maximum QPS respected

Monitoring

Live

Real-time usage tracking

Full Etsy API Compliance

  • Respects rate limits (10 QPS, 10,000 QPD)
  • Uses only official Etsy API v3 endpoints
  • PKCE-enhanced OAuth 2.0 authentication
  • Automatic retry with exponential backoff
  • No automated listing modifications

Technical Architecture

Frontend

Next.js 14 with TypeScript

Backend

Node.js sync worker with Effect framework

Database

PostgreSQL with Kysely ORM