CsvToRefenceEntity

Migrate data from CustomEntityBundle, or initialize data from an ERP/MDM, to Akeneo Reference Entities records (available since 3.0), using CSV file import.

Installation

git clone [email protected]:akeneo/CsvToRefenceEntity.git csv_to_reference_entity
cd csv_to_reference_entity
composer install

Setup

Note: to setup this tool, you'll need a valid API Client ID and its API Client secret from your Akeneo PIM instance. Read the dedicated documentation to proceed: https://api.akeneo.com/getting-started-admin.html

Back in tool, you need to copy the .env file:

cp .env .env.local

Then open .env.local to define the needed configuration vars:

AKENEO_API_BASE_URI=http://your-akeneo-pim-instance.com
AKENEO_API_CLIENT_ID=123456789abcdefghijklmnopqrstuvwxyz
AKENEO_API_CLIENT_SECRET=123456789abcdefghijklmnopqrstuvwxyz
AKENEO_API_USERNAME=admin
AKENEO_API_PASSWORD=admin

How to Use

1) Create Reference Entities in your PIM instance

In your PIM instance, you will need to create your structure for your records. In short, you'll need to create your reference entity first, to define their attributes, if they have a value per channel/locale, etc.

2) Generate your .csv file

The only required field is the code. Regarding attributes, it depends on whether they have a value per channel/locale (we use the same structure as for products):

• For attribute without value per channel/locale:
  • <attribute_code>, eg. description
• For attribute with value per channel:
  • <attribute_code>-<channel_code>, eg. description-ecommerce
• For attribute with value per locale
  • <attribute_code>-<locale_code>, eg. description-en_US
• For attribute with value per channel and per locale:
  • <attribute_code>-<locale_code>-<channel_code>, eg. description-en_US-mobile (locale first)

So, let's imagine this structure for the brand reference entity:

• A code
• A description with one value per locale
• Some tags (an attribute with multiple options)

This would be a valid file:

code;description-en_US;description-fr_FR;tags
ikea;A famous scandinavian brand;Une célèbre marque scandinave;family,nordic
made.com;A famous english brand;Une célèbre marque anglaise;design,online

3) Import your file

Once you have your .csv file, you can import it with this syntax:

php bin/console app:import <csv_file_path> <reference_entity_code>

So if you want to import your records in the .csv file located in /tmp/file.csv for your brand reference entity:

php bin/console app:import /tmp/file.csv brand