# Akeneo PIM

> Product Information Management for e-commerce.

- Category: E-Commerce & Business
- Difficulty: advanced
- Components: akeneo, mysql, elasticsearch
- Tags: akeneo, pim, products, catalog
- Source: https://docker.recipes/ecommerce/akeneo

## Overview

Akeneo PIM (Product Information Management) is an open-source platform designed to centralize, manage, and enrich product data for e-commerce businesses. Founded in 2013, Akeneo has become a leading solution for companies struggling with scattered product information across multiple systems, channels, and languages. The platform excels at creating a single source of truth for product catalogs, managing complex attribute structures, handling multilingual content, and facilitating collaboration between marketing, merchandising, and technical teams.

This Docker stack combines Akeneo PIM with MySQL 8.0 for robust relational data storage and Elasticsearch 7.17 for powerful search and indexing capabilities. MySQL handles the core PIM data including product attributes, categories, user permissions, and system configurations, while Elasticsearch provides fast full-text search across product catalogs, faceted navigation, and real-time indexing of product updates. This architecture enables Akeneo to deliver sub-second search responses even with catalogs containing hundreds of thousands of SKUs.

This configuration is ideal for mid-to-large e-commerce businesses, retailers with complex product catalogs, and organizations managing multi-brand or multi-regional product portfolios. Companies dealing with rich product data like fashion retailers, electronics distributors, or B2B manufacturers will benefit most from Akeneo's advanced attribute management, media handling, and channel-specific product variations. The stack supports enterprise workflows including product approval processes, automated data quality rules, and API-driven integrations with existing ERP and e-commerce systems.

## Features

- Advanced product attribute management with support for text, number, date, media, and custom attribute types
- Multi-channel publishing with channel-specific product variations, pricing, and availability rules
- Built-in Digital Asset Management (DAM) for organizing product images, videos, and documents
- Elasticsearch-powered product search with faceted filtering, relevance scoring, and instant results
- MySQL 8.0 InnoDB storage with ACID compliance ensuring data consistency during bulk imports and updates
- RESTful and GraphQL APIs for integrating with e-commerce platforms like Magento, Shopify, and custom systems
- Multi-locale support with translation workflows and locale-specific product information management
- Data quality management with automated validation rules, completeness tracking, and quality scoring

## Use cases

- Fashion and apparel retailers managing seasonal collections with size, color, and style variations across multiple brands
- Electronics distributors centralizing technical specifications, compatibility matrices, and multilingual product documentation
- B2B manufacturers providing different product catalogs and pricing structures for various customer segments and regions
- Multi-brand retailers maintaining consistent product data across owned brands while preserving brand-specific attributes
- International e-commerce companies managing product localization for different markets and regulatory requirements
- Marketplace sellers consolidating product information from multiple suppliers into standardized catalog formats
- Omnichannel retailers synchronizing product data between online stores, mobile apps, print catalogs, and physical locations

## Prerequisites

- Minimum 4GB RAM recommended due to Elasticsearch memory requirements and Akeneo's resource-intensive operations
- Docker and Docker Compose installed with sufficient disk space for product media assets and search indices
- Port 8080 available for Akeneo web interface access
- Understanding of product information management concepts including attributes, families, categories, and channels
- Basic knowledge of MySQL database administration for backup, optimization, and user management tasks
- Familiarity with Elasticsearch concepts for search configuration and index management

## docker-compose.yml

```yaml
services:
  akeneo:
    image: akeneo/pim-community-dev:latest
    container_name: akeneo
    restart: unless-stopped
    environment:
      APP_ENV: prod
      DATABASE_URL: mysql://${DB_USER}:${DB_PASSWORD}@mysql:3306/${DB_NAME}
    volumes:
      - akeneo_var:/srv/pim/var
    ports:
      - "8080:80"
    depends_on:
      - mysql
      - elasticsearch
    networks:
      - akeneo

  mysql:
    image: mysql:8.0
    container_name: akeneo-mysql
    environment:
      MYSQL_ROOT_PASSWORD: ${DB_ROOT_PASSWORD}
      MYSQL_DATABASE: ${DB_NAME}
      MYSQL_USER: ${DB_USER}
      MYSQL_PASSWORD: ${DB_PASSWORD}
    volumes:
      - mysql_data:/var/lib/mysql
    networks:
      - akeneo

  elasticsearch:
    image: docker.elastic.co/elasticsearch/elasticsearch:7.17.0
    container_name: akeneo-es
    environment:
      - discovery.type=single-node
    volumes:
      - es_data:/usr/share/elasticsearch/data
    networks:
      - akeneo

volumes:
  akeneo_var:
  mysql_data:
  es_data:

networks:
  akeneo:
    driver: bridge
```

## .env

```bash
DB_ROOT_PASSWORD=rootpassword
DB_NAME=akeneo
DB_USER=akeneo
DB_PASSWORD=changeme
```

## Usage notes

- Docs: https://docs.akeneo.com/
- Access at http://localhost:8080 - resource intensive (4GB+ RAM)
- Product Information Management for multi-channel e-commerce
- Centralize product data: attributes, categories, media, translations
- Connect to e-commerce platforms via connectors (Magento, Shopify)
- Enterprise features: workflows, assets DAM, API rate limits

## Troubleshooting

- Elasticsearch bootstrap check failures on startup: Increase vm.max_map_count with 'sudo sysctl -w vm.max_map_count=262144' on Docker host
- Akeneo shows database connection errors: Verify MySQL container is fully started and DATABASE_URL environment variable matches MySQL credentials exactly
- Product search returns no results after data import: Check Elasticsearch indices are properly created by running Akeneo's search index rebuild command
- Akeneo web interface loads slowly or times out: Increase PHP memory limits and ensure adequate system resources, consider adjusting MySQL query cache settings
- File upload errors for product images: Verify akeneo_var volume has sufficient space and proper permissions for web server write access
- MySQL container fails to start with data directory errors: Remove mysql_data volume and restart to initialize fresh database, then restore from backup

