Spare Parts Catalog

Overview

The spare parts catalog is the foundation of Trazea’s inventory management system. It stores detailed information about each spare part, including references, descriptions, discontinuation status, and inventory tracking data.

Parts Data Structure

Repuesto Interface

The complete spare part data structure includes both catalog and inventory information:

src/entities/repuestos/model/types.ts:1-24

export interface Repuesto {
  id_repuesto: string;
  referencia: string;
  nombre: string;
  descontinuado: boolean;
  tipo: string;
  fecha_estimada: string | null;
  url_imagen: string | null;
  created_at: string;
  marca: string;
  descripcion: string;
  // Fields from vista_repuestos_inventario
  stock_actual?: number;
  posicion?: string;
  veces_contado?: number;
  estado_stock?: string;
  cantidad_minima?: number;
  nuevo_hasta?: string | null;
  nombre_localizacion?: string;
  fecha_creacion_repuesto?: string;
  alerta_minimo?: boolean;
  es_nuevo?: boolean;
}

Core Fields

id_repuesto

string

required

Unique identifier for the spare part

referencia

string

required

Part reference number or SKU. Must be unique in the catalog.

nombre

string

required

Part name or description

descontinuado

boolean

required

Whether the part has been discontinued by the manufacturer

tipo

string

required

Part category or type (e.g., “General”, “Electronic”, “Mechanical”)

fecha_estimada

string

Estimated availability date for discontinued or out-of-stock parts

url_imagen

string

URL to the part’s image

marca

string

required

Brand or manufacturer name (defaults to “MINCA”)

descripcion

string

Detailed description of the part

Inventory Fields

These fields come from the vista_repuestos_inventario view and provide location-specific inventory data:

stock_actual

number

Current stock level at the location

posicion

string

Physical location in the warehouse (e.g., “A-12-3”)

cantidad_minima

number

Minimum stock level before reorder alert

alerta_minimo

boolean

Whether current stock is below minimum level

nombre_localizacion

string

Name of the location where this inventory record exists

Creating Spare Parts

RepuestoFormData

When creating a new part, use the simplified form data structure:

src/entities/repuestos/model/types.ts:45-54

export interface RepuestoFormData {
  referencia: string;
  nombre: string;
  descontinuado: boolean;
  tipo: string;
  fecha_estimada?: string | null;
  url_imagen?: string | null;
  marca?: string;
  descripcion?: string;
}

Create API Function

src/entities/repuestos/api/index.ts:55-68

export async function createRepuesto(data: RepuestoFormData): Promise<Repuesto> {
  const { data: newRepuesto, error } = await supabase
    .from('repuestos')
    .insert(data)
    .select()
    .single();

  if (error) {
    console.error('Error creating repuesto:', error);
    throw new Error(error.message);
  }

  return newRepuesto;
}

Example: Creating a Part

import { createRepuesto } from '@/entities/repuestos';

const newPart = await createRepuesto({
  referencia: 'SP-12345',
  nombre: 'Brake Pad Set - Front',
  descontinuado: false,
  tipo: 'Brake System',
  marca: 'MINCA',
  descripcion: 'High-performance ceramic brake pads for front wheels',
  url_imagen: 'https://example.com/images/brake-pad.jpg'
});

Updating Spare Parts

Update API Function

src/entities/repuestos/api/index.ts:70-84

export async function updateRepuesto(id: string, data: Partial<RepuestoFormData>): Promise<Repuesto> {
  const { data: updatedRepuesto, error } = await supabase
    .from('repuestos')
    .update(data)
    .eq('id_repuesto', id)
    .select()
    .single();

  if (error) {
    console.error('Error updating repuesto:', error);
    throw new Error(error.message);
  }

  return updatedRepuesto;
}

Example: Marking a Part as Discontinued

import { updateRepuesto } from '@/entities/repuestos';

await updateRepuesto('part-uuid', {
  descontinuado: true,
  fecha_estimada: '2026-06-01' // Expected replacement date
});

Querying Spare Parts

Query Parameters

src/entities/repuestos/model/types.ts:26-35

export interface RepuestosParams {
  page?: number;
  limit?: number;
  search?: string;
  tipo?: string;
  descontinuado?: boolean;
  order_by?: keyof Repuesto;
  direction?: 'asc' | 'desc';
}

Get Repuestos API

src/entities/repuestos/api/index.ts:4-34

export async function getRepuestos(params: RepuestosParams = {}): Promise<PaginatedRepuestosResponse> {
  const {
    page = 1,
    limit = 10,
    search,
    tipo,
    descontinuado,
    order_by = 'fecha_ingreso_inventario',
    direction = 'desc',
  } = params;

  const offset = (page - 1) * limit;

  let query = supabase
    .from('repuestos')
    .select('*', { count: 'exact' });

  if (search) {
    query = query.or(`nombre.ilike.%${search}%,referencia.ilike.%${search}%`);
  }

  if (tipo && tipo !== 'all') {
    query = query.eq('tipo', tipo);
  }

  if (descontinuado !== undefined) {
    query = query.eq('descontinuado', descontinuado);
  }

  query = query.order(order_by, { ascending: direction === 'asc' });
  query = query.range(offset, offset + limit - 1);

Example: Searching for Parts

import { getRepuestos } from '@/entities/repuestos';

// Search for brake-related parts
const results = await getRepuestos({
  search: 'brake',
  tipo: 'Brake System',
  descontinuado: false,
  page: 1,
  limit: 20
});

console.log(`Found ${results.total_count} parts`);
results.items.forEach(part => {
  console.log(`${part.referencia}: ${part.nombre}`);
});

Part Types and Categories

Organize your catalog using the tipo field:

General

General maintenance parts

Electronic

Electronic components

Mechanical

Mechanical parts and assemblies

Brake System

Brake components

Engine

Engine parts

Suspension

Suspension components

You can define custom part types based on your business needs. The tipo field accepts any string value.

Discontinued Parts

Managing Discontinued Items

When marking a part as discontinued, always provide a fecha_estimada if a replacement is expected or an alternative should be considered.

Discontinued parts remain in the catalog but are flagged:

// Mark as discontinued
await updateRepuesto(partId, {
  descontinuado: true,
  fecha_estimada: null // No replacement expected
});

// Query only active parts
const activeParts = await getRepuestos({
  descontinuado: false
});

// Query only discontinued parts
const discontinuedParts = await getRepuestos({
  descontinuado: true
});

Discontinued Part Workflow

Notification

When a manufacturer discontinues a part, update the descontinuado flag to true.

Set Estimated Date

If a replacement part is coming, set fecha_estimada to the expected availability date.

Inventory Check

Check current inventory levels across all locations to plan for the transition.

Customer Communication

Notify relevant parties about the discontinuation and any alternatives.

Deleting Spare Parts

Destructive Operation: Deleting a part removes it permanently from the catalog. This may affect historical records and inventory tracking.

src/entities/repuestos/api/index.ts:86-96

export async function deleteRepuesto(id: string): Promise<void> {
  const { error } = await supabase
    .from('repuestos')
    .delete()
    .eq('id_repuesto', id);

  if (error) {
    console.error('Error deleting repuesto:', error);
    throw new Error(error.message);
  }
}

Best Practice: Instead of deleting parts, mark them as descontinuado = true. This preserves historical data and maintains referential integrity.

Bulk Operations

For bulk import of spare parts, see the Excel Import Guide.

Best Practices

Reference Numbers

Use consistent reference number formats
Include manufacturer part numbers when available
Add internal codes for easy identification
Ensure references are unique across the catalog

Descriptions

Write clear, searchable part names
Include key specifications in the description
Use consistent terminology
Add compatibility information where relevant

Images

Use high-quality product images
Host images on a reliable CDN
Include multiple angles if possible
Optimize images for web display

Categorization

Define a clear part type taxonomy
Use consistent type names
Don’t create too many categories
Group related parts together

Excel Import

Bulk import spare parts from Excel spreadsheets

Inventory Management

Manage stock levels and inventory operations

Get Started

Core Features

Architecture

Guides

Deployment

Spare Parts Catalog

Overview

Parts Data Structure

Repuesto Interface

Core Fields

Inventory Fields

Creating Spare Parts

RepuestoFormData

Create API Function

Example: Creating a Part

Updating Spare Parts

Update API Function

Example: Marking a Part as Discontinued

Querying Spare Parts

Query Parameters

Get Repuestos API

Example: Searching for Parts

Part Types and Categories

General

Electronic

Mechanical

Brake System

Engine

Suspension

Discontinued Parts

Managing Discontinued Items

Discontinued Part Workflow

Deleting Spare Parts

Bulk Operations

Best Practices

Excel Import

Inventory Management

Build docs developers (and LLMs) love

Get Started

Core Features

Architecture

Guides

Deployment

​Overview

​Parts Data Structure

​Repuesto Interface

​Core Fields

​Inventory Fields

​Creating Spare Parts

​RepuestoFormData

​Create API Function

​Example: Creating a Part

​Updating Spare Parts

​Update API Function

​Example: Marking a Part as Discontinued

​Querying Spare Parts

​Query Parameters

​Get Repuestos API

​Example: Searching for Parts

​Part Types and Categories

General

Electronic

Mechanical

Brake System

Engine

Suspension

​Discontinued Parts

​Managing Discontinued Items

​Discontinued Part Workflow

​Deleting Spare Parts

​Bulk Operations

​Best Practices

​Related Topics

Excel Import

Inventory Management

Build docs developers (and LLMs) love

Overview

Parts Data Structure

Repuesto Interface

Core Fields

Inventory Fields

Creating Spare Parts

RepuestoFormData

Create API Function

Example: Creating a Part

Updating Spare Parts

Update API Function

Example: Marking a Part as Discontinued

Querying Spare Parts

Query Parameters

Get Repuestos API

Example: Searching for Parts

Part Types and Categories

Discontinued Parts

Managing Discontinued Items

Discontinued Part Workflow

Deleting Spare Parts

Bulk Operations

Best Practices

Related Topics