jansoganci/etsy-shop-intelligence

Shop Intelligence for Etsy is an analytics dashboard for Etsy sellers who want a clearer view of what drives their sales, without setting up a full business intelligence system. It is built for sellers who already export their Etsy sales reports and connect Google Analytics, and it pulls both together into one place. The Etsy side of the dashboard works from exported Etsy CSV reports, covering things like revenue and fees, order counts and average order value, repeat buyer rate, top listings by revenue and units sold, sales broken down by country, and how much coupons are helping or hurting margin. The Google Analytics side connects to GA4 data and shows traffic overview numbers, daily traffic trends, where visitors come from, top pages, and visitor countries and devices. The project also includes an early placeholder for combining the two data sources later, for example comparing which listings get a lot of traffic but few sales. The app is built with React and TypeScript on the frontend using Vite, Apache ECharts for charts, and Papa Parse for reading CSV files. The backend runs on Cloudflare Functions with Cloudflare D1 as the database, and the whole app is hosted on Cloudflare Pages. Google Analytics data is synced in through a Google service account. The README recommends keeping the code in a public GitHub repository while keeping the actual deployed dashboard with real shop data private, protected by Cloudflare Access behind an email login. Running the project locally involves installing dependencies with npm, then either running a plain development server for UI work or building the project and running it through Wrangler for a more production accurate Cloudflare Pages preview. Setting it up for real use requires copying example environment and configuration files and filling in personal Cloudflare, database, and Google Analytics credentials, none of which should ever be committed to the repository. The README is thorough about listing exactly which files must stay private, including CSV exports, service account files, and any files containing real database IDs. Combined analytics and direct Etsy API integration are listed as planned or optional future work. The README notes the project currently has no license and asks whoever publishes it to add one.