Inventory Management

Overview

The inventory management system in Yoneily is built around product galleries that support images, pricing, stock levels, and categorization. Each product is represented as a gallery item with comprehensive tracking capabilities.

Product Gallery Structure

Gallery Fields

Field	Type	Description
`id_galeria`	int	Unique product identifier
`texto_galeria`	varchar(255)	Product name/title
`descripcion`	text	Detailed product description
`thumbnails`	text	Main product image filename
`url`	varchar(255)	SEO-friendly URL slug
`claves`	varchar(255)	Keywords/tags for search
`publicar`	int	Publication status (0=hidden, 1=published)
`precio`	double	Product price
`garantia`	varchar(255)	Warranty information
`cantidad`	int	Total quantity received
`cantidad_existente`	int	Current stock level
`cantidad_alerta`	int	Low stock alert threshold
`prod_vendidos`	int	Total units sold
`locale_id_local`	int	Store/vendor association
`usuario_id_usuario`	int	User who created the product
`fechacre_galeria`	timestamp	Creation date
`excluir`	tinyint	Exclude from listings

Product Management Workflows

Adding Products

Navigate to Product Management

Access Galleries > Add from the admin panel

Enter Product Details

Fill in the required information:

Product Name (texto_galeria) - required
Description - required
Keywords (claves) - required for SEO
Price - product cost
Warranty - warranty terms

Upload Product Image

Select a product image (thumbnails field):Supported formats: JPG, JPEG, PNG, GIFProcessing:

Original stored in /files/galeria/otras/
Thumbnail (124x124) generated in /files/galeria/thumbnails/
Display version (600x480) in /files/galeria/normal/

Set Stock Levels

Define inventory quantities:

Initial Quantity (cantidad) - total received
Alert Threshold (cantidad_alerta) - low stock warning
System automatically sets cantidad_existente = cantidad
System initializes prod_vendidos = 0

Assign to Store

Select the associated store/vendor (auto-filled for vendor users)

Attach Additional Images (Optional)

Add multiple product images through the file attachment system

Image Processing

Yoneily automatically generates multiple image sizes for optimal display:

$image = new SimpleImage();
$image->load($original_file_path);
if($image->getWidth() > 124){
    $image->resizeToWidth(124);
}
if($image->getHeight() > 124){
    $image->resizeToHeight(124);
}
$image->save($thumbnail_path);

URL Generation

Products automatically generate SEO-friendly URLs: Formula: texto_galeria + claves (slugified and deduplicated) Example:

Product Name: “Mesa de Madera”
Keywords: “artesanal roble”
Generated URL: mesa-de-madera-artesanal-roble
If duplicate: mesa-de-madera-artesanal-roble_1

URLs are automatically generated in the beforeSave() model method, ensuring uniqueness across the system.

Stock Management

Stock Tracking Fields

cantidad
cantidad_existente
cantidad_alerta
prod_vendidos

Total Quantity ReceivedThe original inventory count when the product was added or restocked.

Stock Updates on Sale

When a product is sold, the system automatically:

Validates stock availability (cantidad_existente > 0)

Decrements inventory:

$cantidad_existente = $cantidad_existente - $cantidad_vendida

Increments sold counter:

$prod_vendidos = $prod_vendidos + $cantidad_vendida

Updates database via Gallery->updateAll()

Products with cantidad_existente = 0 are automatically prevented from being purchased.

Product Editing

Edit Workflow

Navigate to Galleries > Index
Select product to edit
Modify fields:
- Product information
- Description and keywords
- Price and warranty
- Stock quantities (resets cantidad_existente to new cantidad)
Upload new image (optional)
- New image replaces old thumbnail/normal versions
- Original is preserved in /otras/ directory
Save changes

Product Visibility

Publication Status

Control product visibility with the publicar field:

Activate Product

Route: /galleries/activa/{id}Sets publicar = 1 to make product visible to customers

Deactivate Product

Route: /galleries/desactiva/{id}Sets publicar = 0 to hide product from public view

Use Cases for Deactivation:

Out of stock items (temporarily)
Seasonal products
Products under review
Testing new listings

Field	Description
`id_categorias`	Category ID
`nombre_categorias`	Category name
`categorias_id_categorias`	Parent category (for subcategories)
`usuario_id_usuario`	User who created category

Multiple Images

File Attachments

Products support multiple images through the file attachment system: Join Table: archivos_galleries Fields:

files_id_file - Reference to file in archivos table
galerias_id_galeria - Reference to product

Supported Media Types:

Images: JPG, JPEG, PNG, GIF
Audio: MP3
Flash: SWF, FLV

Deleting Images

Image deletion is permanent and uses a direct SQL query to remove records from both archivos and archivos_galleries tables.

Delete Route: /galleries/deleteimg/{gallery_id}/{file_id}

Store/Vendor Filtering

Vendor View

When vendors log in, they see only their own products:

$user = $this->Session->read('Auth.User.locale_id_local');
if(!empty($user)){
    $conditions = array('Gallery.locale_id_local' => $user);
}

Benefits:

Data isolation between vendors
Simplified inventory view
Faster query performance

Administrator View

Administrators see products from all stores with no filtering applied.

Product Listing

Pagination

Products are displayed with pagination: Settings:

10 products per page
Ordered by fechacre_galeria DESC (newest first)
Includes related data:
- User information
- Store/locale details
- Categories
- Attached files

Store Lookup (AJAX)

The system provides an autocomplete store search: Endpoint: /galleries/verlocal Parameters: term (search query) Returns: JSON array of matching stores

[
  {
    "id": 1,
    "value": "El Punto Artesanal de Magdaleno"
  }
]

Product Deletion

Delete Workflow

Select Product

Navigate to product listing and choose product to delete

Confirm Deletion

Click delete button (usually shows confirmation)

Cascade Delete

System removes:

Product record from galleries table
Associated category links
File attachments (metadata, not physical files)

Redirect

Return to product listing with success message

Search & Filtering

Product Discovery

Products can be found through:

Category Browse - Navigate category hierarchy
Keyword Search - Search using claves field
Store Filter - View products by vendor
URL Direct Access - SEO-friendly URLs

Keywords (`claves`)

Keywords improve product discoverability: Best Practices:

Use descriptive terms
Include material types
Add color variations
Specify product categories
Include brand names (if applicable)

Example:

Product: Handcrafted Wooden Chair
Keywords: madera artesanal silla roble comedor

Sales Tracking

View product sales and revenue

Galleries

Manage multimedia content

User Management

Vendor access control

Technical Details

Model Relationships

Gallery Model Associations:

beLongsTo:
  - User (creator)
  - Locale (store)

hasAndBelongsToMany:
  - Archivo (files)
  - Category (categories)

hasMany:
  - Newsgalleries (news associations)

Image Upload Behavior

The Gallery model uses MeioUpload behavior:

'MeioUpload' => array(
    'thumbnails' => array(
        'dir' => 'files{DS}galeria/otras',
        'create_directory' => true,
        'thumbnailQuality' => 50,
        'useImageMagick' => true,
        'allowed_mime' => ['image/gif', 'image/jpeg', 'image/pjpeg', 'image/png'],
        'allowed_ext' => ['.jpg', '.jpeg', '.png', '.gif']
    )
)

Validation Rules

texto_galeria (Product Name)

Required field (notEmpty)
Used in URL generation
No maximum length enforced

descripcion (Description)

Required field (notEmpty)
Text field for detailed information

claves (Keywords)

Required field (notEmpty)
Used in URL generation and search

locale_id_local (Store)

Required field (notEmpty)
Must reference existing locale

Get Started

Core Features

User Guides

​Overview

​Product Gallery Structure

​Gallery Fields

​Product Management Workflows

​Adding Products

​Image Processing

​URL Generation

​Stock Management

​Stock Tracking Fields

​Stock Updates on Sale

​Product Editing

​Edit Workflow

​Product Visibility

​Publication Status

Activate Product

Deactivate Product

​Categories

​Category Structure

​Category Relationships

​Multiple Images

​File Attachments

​Deleting Images

​Store/Vendor Filtering

​Vendor View

​Administrator View

​Product Listing

​Pagination

​Store Lookup (AJAX)

​Product Deletion

​Delete Workflow

​Search & Filtering

​Product Discovery

​Keywords (claves)

​Related Features

Sales Tracking

Galleries

User Management

​Technical Details

​Model Relationships

​Image Upload Behavior

​Validation Rules

Build docs developers (and LLMs) love

Overview

Product Gallery Structure

Gallery Fields

Product Management Workflows

Adding Products

Image Processing

URL Generation

Stock Management

Stock Tracking Fields

Stock Updates on Sale

Product Editing

Edit Workflow

Product Visibility

Publication Status

Categories

Category Structure

Category Relationships

Multiple Images

File Attachments

Deleting Images

Store/Vendor Filtering

Vendor View

Administrator View

Product Listing

Pagination

Store Lookup (AJAX)

Product Deletion

Delete Workflow

Search & Filtering

Product Discovery

Keywords (`claves`)

Related Features

Technical Details

Model Relationships

Image Upload Behavior

Validation Rules