Skip to content

CAT-COMMERCE: E-commerce built on Next.js, PostgreSQL, and Cloudflare Workers

An online store isn't just a pretty design. It's a database that never crashes, a checkout that never loses a sale, and a dashboard where you manage everything without depending on a developer. 35 tables, 40+ endpoints, serverless architecture that scales without you lifting a finger.

2 years of development35 tables40+ endpoints180+ components

Commerce.Zero commission.

Technical architecture — what's under the hood

It's not magic. It's engineering.

Complete technology stack

TechnologyVersionWhat it does
Next.js16.2.10Frontend with App Router, SSR, and ISR — your store loads in milliseconds and Google indexes every product
Hono4.12.27Ultra-fast API on Cloudflare Workers — your endpoints respond from the edge, close to your customers
Neon PostgreSQLServerlessServerless PostgreSQL with branching — each client has an isolated instance, no resource sharing
Drizzle ORM0.45.2Type-safe ORM with automatic migrations — zero SQL errors in production, TypeScript validates everything at compile time
NextAuth.jsv5 BetaAuthentication with Google, GitHub, and credentials — your customers log in however they prefer, with secure JWT sessions
Stripe + PolarStripe 20.1.0Two integrated payment gateways — Stripe for international sales, Polar for Peru. Verified webhooks and anti-duplicate protection on both
Cloudflare R2PushDuck 0.6.0Edge file storage — your product images are served fast with zero bandwidth costs
DeepSeek V4 FlashOpenRouterAI chatbot that knows your real catalog — recommends products, answers questions, and never returns an error even if the AI fails

// It's not magic. It's engineering.

Production-Grade Rate Limiting

8 differentiated tiers with burst detection, ban escalation, and dual adapters (in-memory dev, Cloudflare KV production). Designed for real e-commerce traffic patterns — not generic middleware. Your store keeps running even when someone tries to abuse it.

Dual Database Driver

Two simultaneous Drizzle drivers: neon-http for fast reads and neon-serverless WebSocket for atomic transactions. This allows running on Cloudflare Workers without sacrificing transactional integrity — a product with variants, images, and prices is created in a single atomic operation.

ML Recommendation Engine

Standalone microservice with TensorFlow.js that trains on real user actions: views, wishlists, carts, and purchases. Recommendations carry an explicit reason — "based on your purchases", "similar to users like you" — it's not a black box.

SEO Built Into the Framework

Structured JSON-LD (Organization, Product, BreadcrumbList), bilingual sitemap with hreflang, 72+ pages with generateMetadata, ISR on products, hero image preload. This isn't a plugin you installed — SEO is woven into every route. Google understands your store without you having to explain anything.

Chatbot That Knows Your Catalog

Before each request, it loads categories, brands, and products from the database at runtime. A 170-line system prompt with business rules, sales tone, and structured responses. If the AI fails, it returns a fallback message — never a 500 error. Your customers always get an answer.

What's already protected

  • Payment webhooks with cryptographic signature verification (Stripe)
  • 8-tier rate limiting with abuse detection and temporary banning
  • Passwords hashed with bcrypt (10 rounds) — not even we can read them
  • Input validation with Zod on ALL endpoints
  • Dual-layer admin route protection (Next.js middleware + Hono middleware)
  • Atomic transactions — stock is deducted without overselling risk
  • Partial unique index preventing duplicate payments on the same order
  • JWT sessions via Auth.js with secure cookies

What's on the roadmap

  • HTTP security headers (CSP, HSTS, X-Frame-Options) — prevent clickjacking and XSS
  • CSRF protection on custom API routes

CAT-COMMERCE by the numbers

725+TypeScript Files
35DB Tables
180+React Components
40+API Endpoints
8Rate Limit Tiers
2Payment Gateways

Product tour — this is what CAT-COMMERCE looks like in action

10 screens. What you see is what your customers will see.

Store homepage

Storefront with featured products, categories, and search — your customers find what they need in seconds.

Store homepage

Product page with variants

Product detail with images, sizes, colors, and real-time stock. No surprises.

Product page with variants

Shopping cart

Cart with summary, quantities, and shipping estimate before payment. Transparent.

Shopping cart

Stripe checkout

Checkout with Stripe Elements — your customers pay without leaving your store. Secure and fast.

Stripe checkout

Admin panel — dashboard

Dashboard with sales metrics, recent orders, and most viewed products. Everything at a glance.

Admin panel — dashboard

Admin panel — product management

Full product CRUD with per-color images, variants, and multi-currency pricing.

Admin panel — product management

Admin panel — orders

Order management with status history — from pending to delivered, every step recorded.

Admin panel — orders

Mobile store view

100% responsive — your customers shop from their phone just as easily as from a computer.

Mobile store view

Dark mode

Full dark mode across all components. Because your customers also shop at night.

Dark mode

Integrated AI chatbot

Chatbot that recommends products based on your real catalog. Like a salesperson that never sleeps.

Integrated AI chatbot

Your path to a professional store — 4-week timeline

No surprises, no fine print. Here's what happens each week.

W0

Week 0 — What you need to prepare

You prepare:

  • High-quality photos of your products (800x800 px minimum)
  • Your brand logo in SVG or PNG with transparent background
  • Your domain (or we'll help you buy one)
  • 3-5 main categories to organize your catalog
  • ID document to verify your payment gateway account
W1

Week 1 — Foundation

What we do

We set up your CAT-COMMERCE instance: isolated database, domain, SSL, payment gateway, and admin panel. We load your first categories and test products so you can see how the system works.

What you see

Your online store with your domain, your logo, and your categories. No real products yet — this is the skeleton we build everything on.

W2

Week 2 — Catalog and design

What we do

We prepare your admin panel with your store's structure: categories, brand, colors, and typography. We teach you how to load your products from the panel — drag images, set prices, and write descriptions. If you'd rather have us load them, we use part of your included engineering hours (each hour handles ~15-20 products depending on complexity). Ideally, you load them yourself: nobody knows your products better than you.

What you see

Your store with the structure ready, design applied, and example products loaded. The admin panel is operational for you to start loading your products or for us to do it using your engineering hours.

W3

Week 3 — Payments, shipping, and automations

What we do

We activate Stripe and Polar in production mode. We configure shipping zones, taxes, and transactional emails (purchase confirmation, shipping notification). We test the complete purchase flow 3 times.

What you see

Your fully functional store. You can make a test purchase end-to-end — from cart to email confirmation — and see your admin panel update in real time.

W4

Week 4 — Launch

What we do

Final technical SEO tweaks, sitemap, robots.txt, and hreflang. We test speed with Lighthouse (target: 90+). We deliver full admin panel access and a 1-hour training session.

What you see

Your store ready to receive real customers. Indexed on Google, payments working, and you knowing exactly how to manage everything from the panel. No dependency on anyone.

Frequently asked questions about CAT-COMMERCE

How long does it take for a payment to reflect in my account?
Stripe transfers to your bank account in 7 business days (first payment may take up to 14 days for verification). Polar transfers in 2-3 business days. Both are automatic — you just sell, the money arrives on its own. In your admin panel, you see each payment in real time the moment the customer completes the purchase.
Can I change plans after signing up?
Yes, at any time. If your store grows and you need more monthly development hours, you upgrade and pay the pro-rated difference for the month. If you need to downgrade, give us 15 days' notice and we'll adjust starting the following month. No penalties, no fine print.
What happens if I'm late with a monthly payment?
You have a 7-day grace period with no penalty. On day 8, your store is fully paused until payment is regularized. Your data remains intact, and upon reactivation, everything is back within hours. If you need to cancel, we deliver a full data export in JSON and CSV. No strings attached.
How customizable is my store's design?
Very. We change colors, typography, product page layout, section order, hero banners. What we WON'T do is turn CAT-COMMERCE into something it's not — if you need a completely unique design from scratch, that's custom web development (which we also do). CAT-COMMERCE gives you a professional store with your visual identity, not a generic clone.
How many products can I have? Does the store slow down with many?
The architecture is designed to scale. PostgreSQL with optimized indexes handles 10,000+ products without performance degradation. Catalog pages use ISR (Incremental Static Regeneration) — they rebuild every 5 minutes, not on every visit. The current search uses PostgreSQL ILIKE (functional up to ~50k products). For massive catalogs, full-text search with tsvector is on the roadmap for future versions.
Can I sell digital products in addition to physical ones?
Yes. CAT-COMMERCE supports both types. For digital products (ebooks, courses, software), we set up automatic email delivery with a download link the moment payment is confirmed. If your business model is hybrid (physical + digital), the system handles both in the same catalog seamlessly. Subscriptions and memberships are on the roadmap for a future version.
How deep is the SEO? Isn't it just adding meta tags?
CAT-COMMERCE SEO isn't a plugin — it's built into the framework. It includes: structured JSON-LD (Organization, Product, BreadcrumbList, FAQPage), bilingual sitemap.xml with automatic hreflang, typed generateMetadata across 72+ pages, ISR with revalidate=300 on products, complete OpenGraph and Twitter Cards, canonical URLs, semantic breadcrumbs, and hero image preload. Google sees your store as a professional web application, not a generic site.
How does my store look on mobile?
Every CAT-COMMERCE component was designed mobile-first. Images are optimized with next/image (WebP/AVIF automatic, lazy loading). Stripe Checkout is natively responsive. The admin panel also works on tablets — you can manage orders from your phone while you're in the warehouse. We test on iPhone SE, Pixel, and Android tablets.
What happens if my store grows to 10,000 products or more?
The architecture scales horizontally. Cloudflare Workers handle traffic at the global edge. Neon PostgreSQL scales without downtime. We add additional indexes and increase ISR frequency on demand. The real limit isn't technical — it's business. If you reach 10,000 products, you're running a serious operation, and we adjust the plan accordingly.
If I ever want to leave, can I take my data with me?
100%. Your data is yours. We deliver a complete export in JSON and CSV: products with images, orders with history, customers with contact info, reviews — everything. No proprietary formats, no excuses. We keep your instance active for 30 days after cancellation in case you change your mind. We don't do vendor lock-in — if the product is good, you stay because you want to, not because you're trapped.

Commerce.Zero commission.

Stop depending on a marketplace. Your domain, your rules.

CAT-COMMERCE is your own software on your own domain — you're not renting space on someone else's platform. Zero commissions, no dependency on anyone's algorithm.

Includes: serverless hosting (Cloudflare Workers), isolated PostgreSQL database, admin dashboard, technical SEO, and 4-10 engineering hours per month. All for $200/month for the first 3 months.