Skip to main content

​
Overview

The materials catalog contains 168 items organized into 5 categories. Each material includes details about packaging, approximate weight, and ordering information.

​
Catalog Summary

  • Materias Primas (Raw Materials): 40 items
  • Esencias (Fragrances): 82 items
  • Varios (Miscellaneous): 21 items
  • Envases Vacíos (Empty Containers): 14 items
  • Colores (Colors): 11 items

​
Materias Primas (40)

Raw materials used in production.

​
Notable Raw Materials

​
Sosa Liquida
kgs
Heaviest raw material at 250 kgs per 200lts container
​
Conservador Db20 Recuperador (LA)
Lt
Smallest packaging at 1 Lt bottle
​
Adbs
kgs
High density at 220 kgs per 200lts

​
Esencias (82)

Fragrances and scents for products.

​
Fragrance Categories

Floral (16): Alaska, Almendra, Azahar, Clavel, Flores Blancas, Flores Frescas, Fresia, Gardenia, Jazmin, Lavanda Francesa, Lavanda Inglesa, Lila, Magnolia, Nardo, Orquidea, Rosas, Violeta Fresh/Clean (12): Aqua Fresh, Baby, Bebe Fresh, Blue Softener, Brisas, Fresh Power, Lluvia, Marine, Ocean, Primavera, Spring, Talco Fruit (14): Cereza, Coco, Durazno, Fresa, Mango, Manzana, Melon, Mora, Naranja, Pina, Sandía, Uva, Zarzamora Citrus (6): Citronela, Citrus, Lemon Fresh, Limon, Limon Fresco, Yuzu Herbal/Wood (9): Amaderado, Cedar Wood, Cuero, Eucalipto, Herbal, Hierbas Frescas, Pachuli, Pino, Pino Suave, Sandalo Special (6): Amor, Canela, Charm-24, Cocktail, Miel, New Car, White Musk
Most fragrances come in standard 20kg/20lts containers. Exceptions:
  • Charm-24: 50kg/50lts (bulk)
  • Lavanda Francesa: 50kg/50lts (bulk)
  • Amor: 5kg/5lts (small)
  • Fresia: 5kg/5lts (small)
  • New Car: 5kg/5lts (small)
  • Spring: 1.95kg/4lts (smallest)

​
Varios (21)

Miscellaneous items including chemicals, lab supplies, and packaging materials.

​
Subcategories

Chemicals (10):
  • Amonaco, Antiginscal, Alcohol Cetilico, Base Insecticida, Citrico, Gyrgen, Optgin, Tinopal CBS-X, Tripolifosfato, Urea
Lab Equipment (4):
  • Jarras, Pesalejías, Probetas, Tiras pH
Bulk Materials (5):
  • Sal Industrial (50kgs), Sebo Destilado (200lts), Silica Gel (25kgs), Zeolita (25kgs), Zeolita Cargada (25kgs)
Other (2):
  • Past. Tikilín 1” (100kgs box), Rollos de Ticket
Items marked with “Pzas” (pieces) are ordered by quantity, not weight.

​
Envases Vacíos (14)

Empty containers for packaging finished products.

​
Container Types

Large Containers (3):
​
Contenedor de 1,000 Lts
Pzas
Largest container at 70 kgs per unit (1,000 liter capacity)
​
Tambo De Metal 200 Lts
Pzas
Metal drum, 20 kgs per unit
​
Tambo De Plastico 200 Lts
Pzas
Available in open or closed versions, 10 kgs per unit
Medium Containers (5):
  • Garrafon 10 Lts c/Tapa (24-pack)
  • Garrafon 20 Lts c/Tapa (12-pack)
  • Cubeta Blanca 19 Lts Tapa (20-pack)
  • Cubeta Blanca 19 Lts Sin Tapa (20-pack)
  • Cubeta Amarilla 19 Lts (20-pack)
Small Containers (4):
  • Botella nueva de 1 Lt (150-pack)
  • Bolsa Polietileno 10kg (200-pack)
  • Caja Carton Suavizante 1L (12-pack)
  • Caja Carton Detergente 1kg (12-pack)
Accessories (2):
  • Tapa Garrafon 20 Lts (50-pack, 0.5 kgs)

​
Colores (11)

Pigments and dyes for product coloring.
#NombreUnidad BasePeso Aprox.Envase
1Amarillo Fluoresc.kgs2020lts
2Amarillo Huevokgs2020lts
3Azulkgs2020lts
4Azul Brillantekgs2020lts
5Azul Marinokgs2020lts
6Color Moradolts2020lts
7Naranjakgs2020lts
8Pigmento Rojolts2020lts
9Rosakgs2020lts
10Rojokgs2020lts
11Verdekgs2020lts

​
Color Palette

Yellow (2): Amarillo Fluoresc., Amarillo Huevo Blue (3): Azul, Azul Brillante, Azul Marino Red Spectrum (3): Naranja, Pigmento Rojo, Rosa, Rojo Other (3): Color Morado, Verde
All colors come in standard 20kg/20lts containers.Note: “Color Morado” and “Pigmento Rojo” use “lts” (liters) as base unit instead of “kgs”.

​
Database Schema

Materials are stored in the materiales table: 
CREATE TABLE materiales (
  id               uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  codigo           text UNIQUE,
  nombre           text NOT NULL,
  categoria        categoria_enum NOT NULL,
  unidad_base      text NOT NULL DEFAULT 'kgs',
  peso_aproximado  numeric,
  envase           text,
  orden            integer NOT NULL
);

CREATE TYPE categoria_enum AS ENUM (
  'materia_prima', 'esencia', 'varios', 'envase_vacio', 'color'
);

​
Querying Materials

Get all materials by category: 
SELECT * FROM materiales 
WHERE categoria = 'esencia' 
ORDER BY orden;
Search by name: 
SELECT * FROM materiales 
WHERE nombre ILIKE '%lavanda%';
Get materials with specific packaging: 
SELECT * FROM materiales 
WHERE envase = '200lts' 
ORDER BY categoria, orden;

​
Usage Notes

​
Ordering

  1. Kilograms vs Pieces: Check unidad_base field:
    • kgs or Lt: Order by weight
    • Pzas or Paquete: Order by quantity
  2. Container Sizes: The peso_aproximado field indicates container size, not unit price
  3. Legacy Codes: Some materials have codigo values (legacy system), but most use only nombre

​
Display Order

Materials are sorted by the orden field within each category: 
const materials = await supabase
  .from('materiales')
  .select('*')
  .eq('categoria', 'esencia')
  .order('orden', { ascending: true });

​
Material Availability

All materials in this catalog are available for ordering. Future versions may include an activo field to mark discontinued items.

​
Statistics

​
Packaging Distribution

  • 200lts containers: 32 materials (most common for raw materials)
  • 20lts containers: 95 materials (standard for fragrances/colors)
  • 25kgs bags/containers: 7 materials
  • 50kgs bags/containers: 4 materials
  • Piece-based: 7 materials (lab equipment, tickets)
  • Package-based: 6 materials (empty containers)

​
Weight Ranges

  • Heaviest: Sosa Liquida (250 kgs), Glicerina (250 kgs)
  • Lightest: Conservador Db20 (1 Lt bottle), Spring (1.95 kgs)
  • Most common: 20 kgs / 20lts (95 items)

​
Unit Types

  • kgs: 138 materials (82%)
  • Lt: 5 materials (3%)
  • lts: 2 materials (1%)
  • Pzas: 7 materials (4%)
  • Paquete: 5 materials (3%)
  • Piezas: 2 materials (1%)

Build docs developers (and LLMs) love

Get started for freeTalk to us