SEOCatalog is a structured database of directories.
Project: SEOcatalog (seocatalog.com.ua)
Type: SEO platform / catalog of sites + applications and "cart" (like a small online store)
What has been done:
1) Site "from scratch" with fast SSR
• Architecture implemented on Cloudflare Pages Functions (server-side rendering of pages).
• Pages are delivered with ready HTML markup (SSR), making the site fast and well-indexed.
• Code structure — MVC: controllers gather data, views render HTML, shared components are reused.
2) Catalog with sections, cards, and filters
• Main catalog page + section pages (themes) + card pages (site details).
• Filtering and sorting (including price range) with correct behavior for SEO:
– for pages with filters, robots noindex, follow is set
– for "clean" pages — index, follow
• Prepared canonical URLs to avoid duplicates in search.
3) Cart and order placement (like in e-commerce)
• Added scenario for selecting sites into the "cart".
• Implemented order placement form with validation (name, contact, comment, list of items).
• On the backend side — normalization of fields, protection against incorrect data, length restrictions, stable processing.
4) Integration with Google Sheets (CRM-like backend)
• Connected Google Apps Script API as an "admin panel" without a separate backend:
– requests for adding a new catalog → drafts sheet
– orders from the cart → orders sheet
• Access token + checks to prevent writing to the table without authorization.
• Logs and statuses of orders/applications are stored in the table for manual processing by the manager.
5) SEO optimization "for search"
• Meta tags: title/description, OpenGraph, Twitter Card.
• Dublin Core metadata to enhance document structure.
• JSON-LD (Schema.org) for improving understanding of cards by search engines/AI:
– Organization/LocalBusiness depending on the type of card
– sameAs (official website), url, description, address (if available)
• Generation of sitemap.xml through a function (for indexing and fast crawling).
6) UX and mobile adaptation
• Unified UI layer on main.css + site-ui.js: modals, menus/filters, page behavior.
• Fixing mobile nuances (scroll/overlays, "no-scroll" state, filter panels).
• Page templates designed as "long-read", neat typography, correct headings, lists.
7) Documentation for quick work with the project
• A register of functions and correspondences "route → file → controller/view" (function-registry.md) is maintained,
to quickly find the necessary place for edits without sifting through the entire archive.
Result for the business
• The owner receives a fast SEO-friendly catalog/store-like product, where:
– the client can select items (sites), add them to the cart, send an order
– the manager receives everything in Google Sheets, without a complicated admin panel
– search well indexes pages thanks to SSR, meta-data, sitemap, and schema.org
• The solution is easy to scale: adding sections, new fields to cards, new payment/cabinet scenarios.
Type: SEO platform / catalog of sites + applications and "cart" (like a small online store)
What has been done:
1) Site "from scratch" with fast SSR
• Architecture implemented on Cloudflare Pages Functions (server-side rendering of pages).
• Pages are delivered with ready HTML markup (SSR), making the site fast and well-indexed.
• Code structure — MVC: controllers gather data, views render HTML, shared components are reused.
2) Catalog with sections, cards, and filters
• Main catalog page + section pages (themes) + card pages (site details).
• Filtering and sorting (including price range) with correct behavior for SEO:
– for pages with filters, robots noindex, follow is set
– for "clean" pages — index, follow
• Prepared canonical URLs to avoid duplicates in search.
3) Cart and order placement (like in e-commerce)
• Added scenario for selecting sites into the "cart".
• Implemented order placement form with validation (name, contact, comment, list of items).
• On the backend side — normalization of fields, protection against incorrect data, length restrictions, stable processing.
4) Integration with Google Sheets (CRM-like backend)
• Connected Google Apps Script API as an "admin panel" without a separate backend:
– requests for adding a new catalog → drafts sheet
– orders from the cart → orders sheet
• Access token + checks to prevent writing to the table without authorization.
• Logs and statuses of orders/applications are stored in the table for manual processing by the manager.
5) SEO optimization "for search"
• Meta tags: title/description, OpenGraph, Twitter Card.
• Dublin Core metadata to enhance document structure.
• JSON-LD (Schema.org) for improving understanding of cards by search engines/AI:
– Organization/LocalBusiness depending on the type of card
– sameAs (official website), url, description, address (if available)
• Generation of sitemap.xml through a function (for indexing and fast crawling).
6) UX and mobile adaptation
• Unified UI layer on main.css + site-ui.js: modals, menus/filters, page behavior.
• Fixing mobile nuances (scroll/overlays, "no-scroll" state, filter panels).
• Page templates designed as "long-read", neat typography, correct headings, lists.
7) Documentation for quick work with the project
• A register of functions and correspondences "route → file → controller/view" (function-registry.md) is maintained,
to quickly find the necessary place for edits without sifting through the entire archive.
Result for the business
• The owner receives a fast SEO-friendly catalog/store-like product, where:
– the client can select items (sites), add them to the cart, send an order
– the manager receives everything in Google Sheets, without a complicated admin panel
– search well indexes pages thanks to SSR, meta-data, sitemap, and schema.org
• The solution is easy to scale: adding sections, new fields to cards, new payment/cabinet scenarios.
Kyiv 
Available for hire
Offer work