Rawlings Sporting Goods Company Inc: Digital Commerce & Master Data Coordinator

The gap in what exists

Many mid-sized companies like Rawlings lack dedicated internal tooling for master data management, relying on manual processes or spreadsheets, creating a gap for custom, integrated solutions.

Wedge to win

Offer a bespoke, AI-powered data management system and process implementation tailored specifically to Rawlings' product catalog and e-commerce platform, delivering faster and more accurate data than manual methods or generic tools.

Reputation value (worth doing free for proof) — 70/100

Delivering a custom digital commerce and master data solution for a known brand like Rawlings would provide strong proof-of-work for future B2B SaaS or service engagements in data management and e-commerce.

Likely monetization

fixed-price project/retainer (service engagement)

Incumbents to beat

Manual processes / spreadsheetsGeneric PIM (Product Information Management) systems (e.g., Akeneo, Salsify - potentially too expensive/complex for Rawlings' specific need)

You are an expert full-stack developer with a strong understanding of data management and e-commerce systems. Your task is to design and develop a custom 'Digital Commerce & Master Data Coordinator' system for Rawlings Sporting Goods. This system will maintain accurate and consistent product data for their e-commerce operations. The core objective is to create a robust, user-friendly system for data ingestion, validation, enrichment, and synchronization with their existing e-commerce platform(s).

Use Next.js 16 App Router, React 19, Tailwind v4, and Neon Postgres for the backend, hosted on Vercel. Employ the AI SDK v6 with Gemini for any potential data enrichment or classification tasks where applicable (e.g., auto-tagging product features).

Develop the following core modules:
1.  **Data Ingestion & Transformation:** A Python-based service (or Node.js script) that can accept product data feeds (CSV, XML, JSON) and parse them into a standardized schema for a Neon Postgres database. It should include basic data cleaning and normalization rules.
2.  **Web-based Data Management UI:** A Next.js application for internal Rawlings staff to view, edit, validate, and enrich product data. This UI must include robust search, filtering, and bulk-editing capabilities. Implement clear data validation rules to ensure data consistency.
3.  **E-commerce Synchronization Module:** A service (Node.js) that can push approved product data from the master database to a target e-commerce platform's API (assume a generic REST API for now, like Shopify or Magento, requiring API key authentication). Include error handling and logging.
4.  **Reporting & Dashboards:** A simple dashboard in the Next.js app showing data quality metrics, synchronization status, and pending data tasks.

**MVP Scope for initial delivery:** Focus on getting the core data model defined, a simple CSV ingestion process working, and a basic UI for viewing and editing product names, descriptions, and SKUs. The e-commerce sync should be mocked initially. The goal is to prove the ability to centralize and manage data effectively.

**Build and Verify Gate:** Ensure the Next.js application is fully responsive. All backend services must be containerized (e.g., Dockerfile) and ready for deployment. Provide clear instructions for local setup and deployment to Vercel. Include unit and integration tests for critical data processing and API interaction logic. Document the data schema, API endpoints, and user flows.