Skip to main content

Documentation Index

Fetch the complete documentation index at: https://mintlify.com/sergio-salcedo-dev/excel-product-manager/llms.txt

Use this file to discover all available pages before exploring further.

This guide walks you through cloning the repository, installing dependencies, configuring your environment, and launching the development server — everything you need to have the full Preoc Product Manager dashboard running at http://localhost:3000 in under five minutes.
1

Prerequisites

Make sure you have Node.js 18 or later installed on your machine. The LTS release is recommended and available at https://nodejs.org.The AI search features (CYPE Precios lookup and Gemini market search) require a Google Gemini API key. You can generate one for free at https://aistudio.google.com — no billing setup is needed for the free tier.
2

Clone the Repository

Clone the project from GitHub and move into the project directory:
git clone https://github.com/sergio-salcedo-dev/excel-product-manager.git
cd excel-product-manager
3

Install Dependencies

Install all required packages using your preferred package manager:
npm install
4

Configure Environment Variables

Create a .env.local file in the project root and add the following variables:
.env.local
GEMINI_API_KEY="your_gemini_api_key_here"
APP_URL="http://localhost:3000"
Replace your_gemini_api_key_here with the API key you generated in Google AI Studio (https://aistudio.google.com). The APP_URL should remain http://localhost:3000 for local development.
5

Start the Dev Server

Launch the Next.js development server:
npm run dev
Open http://localhost:3000 in your browser. The Preoc Product Manager dashboard loads immediately — no database migrations or seed scripts required.

What You’ll See

Once the app loads you are greeted by a two-panel dashboard. The left sidebar contains a category filter list that lets you narrow the product table by construction trade (e.g., masonry, concrete, finishes) along with an advanced filter panel for refining results by unit type or price range. The main area displays a paginated product table pre-loaded with 20 default Spanish construction products, giving you a representative dataset to explore immediately. Above the table a toolbar exposes four primary actions: Add (opens a product form), Import Excel (ingests an .xlsx workbook), Export Data (downloads the current catalog as a spreadsheet), and the AI Search button that opens the CYPE Precios and Gemini search panel.
The app ships with 20 default construction products so you can explore the interface, test filters, and try the Excel export immediately — no data setup or seed scripts needed before you begin.

Next Steps

Manage Products

Learn how to add, edit, and delete products, use category filters, and paginate through large catalogs.

Import & Export Excel

Bulk-load products from an existing .xlsx workbook or export your catalog for use in procurement and take-off workflows.

AI-Powered Search

Query CYPE Precios unit prices or ask Google Gemini for real-time market pricing and product alternatives.

Configure Environment

Explore all available environment variables, deployment targets, and production build options.

Build docs developers (and LLMs) love