Guide for Akeneo Multi Source Import Type

Akeneo Multi Source Import Type module allows you to seamlessly transfer data from multiple sources into your Akeneo product information management system.

Akeneo Multi Source Import Type allows the Akeneo admin to import product data from Google sheet, Dropbox, SFTP & FTP server, File, and the Public URL of CSV files into Akeneo.

Also, you can import the images using the Akeneo Image Importer module.

For importing data between one Akeneo to another you can check the Multi Akeneo Syndication module.

Note: the module for now works with Akeneo 7.x.x version.

• Import data from Google Sheets into Akeneo.
• Import data from SFTP and FTP server into Akeneo.
• Import data from the Public URL of the CSV file into Akeneo.
• Import data from Dropbox into Akeneo.

Read this blog: How to install Webkul Akeneo Connector via Composer? before starting the installation via composer.

1: GET the Access Keys: Raise a ticket.

2: Add our repository and installation script in your Akeneo composer.json

{
  "scripts": {
        "post-update-cmd": [
           "vendor/webkul/multisourceimportertypebundle/src/Webkul/MultiSourceImporterTypeBundle/install/config.sh COMPOSER=true NO_DOCKER=true"
        ],
        "post-install-cmd": [
           "vendor/webkul/multisourceimportertypebundle/src/Webkul/MultiSourceImporterTypeBundle/install/config.sh COMPOSER=true NO_DOCKER=true"
        ],
        "post-create-project-cmd": [
          "vendor/webkul/multisourceimportertypebundle/src/Webkul/MultiSourceImporterTypeBundle/install/config.sh COMPOSER=true NO_DOCKER=true"
       ]
   },
  "repositories": [{
    "type": "composer",
    "url": "https://akeneorepo.webkul.com/"
  }]
}

3: Install the extension using Composer.

composer require webkul/multisourceimportertypebundle

4: Fill the authentication.

5: Success Message

6: Clear Browser cache

Manual Installation:

Unzip the respective extension zip and then merge the “src” folder into the Akeneo project

Run the below command over the NO-DOCKER Instance from the PIM directory

./src/Webkul/MultiSourceImporterTypeBundle/install/config.sh COMPOSER=false NO_DOCKER=true

Run the below command over the DOCKER Instance from the PIM directory.

./src/Webkul/MultiSourceImporterTypeBundle/install/config.sh COMPOSER=false NO_DOCKER=false

Uninstall-Module:

Run the below command over the NO-DOCKER Instance from the PIM directory.

./src/Webkul/MultiSourceImporterTypeBundle/uninstall/uninstall.sh COMPOSER=false NO_DOCKER=true

Run the below command over the DOCKER Instance from the PIM directory.

./src/Webkul/MultiSourceImporterTypeBundle/uninstall/uninstall.sh COMPOSER=false NO_DOCKER=false

Raise a ticket if you will face any issues during installation/uninstallation.

To get the Google Sheet Credentials navigate to Google Console Developer website and log in using your Gmail ID.

After that, navigate to the Side panel and go to APIs & Services->Enable APIs & services option.

In the section that comes up, tap the Enable APIS AND SERVICES option.

Now, search for Google Sheets API and hit the enter button.

This brings up the Google Sheets API, tap on it.

Now, enable the same by tapping the Enable button.

Thereafter, tap on the Create Credentials option.

Now, select user data and then tap the Next button.

Here, give the app name, user support email, and developer contact email. Now, tap SAVE AND CONTINUE.

After that, add or remove scopes as required for the app and tap the Save and Continue button.

Now, under OAuth Client ID select the Application type, and enter the redirect URL.

After that, the credentials will be generated, tap the Done button.

Now, tap on the download button to download the JSON file on your system.

This file is to be uploaded while creating the credential for the Google Sheets at the Akeneo end using the module.

Navigate to the Dropbox Developer App Console and log in using your Gmail account.

After login, create a new app by tapping the Create app button.

Now, choose an API, and the type of access, enter the app name, and tap the Create app button.

After the app is created, you can see the API & Secret key.

For the create app you need to set the OAuth redirect URL as well.

You can set it as – https://akeneositeurl/multisource/dropbox/callback

After the successful installation of the Akeneo Multi Source Import Type module, you will find one option in the side panel of the Akeneo as shown below.

You can also check our wide range of Akeneo extensions.

Google Sheets:

Tap on the Side panel option MultiSource->Setup Credentials option and the below page appears.

Here, you can find all of the added source type credentials and if it’s the first time, then this section is empty.

Tap, on the Add Credential button in the top right-hand corner and the below section appears.

Here, choose the source type as Google Sheets, enter the name of the credential, and choose the JSON file.

Lastly, tap the Save button to save the credentials for Google Sheets.

Dropbox:

Navigate through MultiSource->Setup Credentials->Create Credentials and select the source type as Dropbox.

Then enter the name, app key, app secret and tap the Authenticate Dropbox button.

This brings a pop-up click Continue.

After that tap Allow.

Now, the Dropbox credentials are verified and you can tap the Save button to save the credentials.

FTP:

Navigate through MultiSource->Setup Credentials->Create Credentials and select the source type as FTP.

Now enter the Name for the credential, Host Name, Port, User Name, and Password. Lastly, click the Save button.

The credentials will be verified, if already using the same credentials then you will get a message for the same else if the credentials are wrong then you get the responding message for the same.

SFTP:

Navigate through MultiSource->Setup Credentials->Create Credentials and select the source type as SFTP.

Now enter the Name for the credential, Host Name, Port, User Name, and Password. Lastly, click the Save button.

If the credentials are correct then it will be saved else if the entered credentials are wrong you will get an error.

This is a sample product Google sheet file.

Here, you have to use the URL of the Google Sheet and the exact Google Sheet name to create the job.

Navigate to the Imports section in the side panel of Akeneo.

Tap the Create Import Profile button and the below section appears.

Here, enter the code for the job, label the name of the job, and then for the Job you can select –

• Multi Source Product File Import
• Multi Source Product Model File Import

For now, we will choose one and save the import job.

Now, you need to navigate to the source section of the job.

Here for the available options, the admin will choose the respective option.

• Import Source – Choose the source as Google Sheets.
• Select Credentials – Select the created credential for Google Sheets.
• Google Sheet URL – Copy and paste the Google Sheet URL from where you want to import the products.
• Google Sheet Name – Here, enter the name of the Google Sheet where you have the product data.

Save the details and then tap the Import Now button to import products into Akeneo.

This will start the import process.

And you can see the results after successful execution.

The products are imported into Akeneo.

Navigate to the Imports section in the side panel of Akeneo.

Tap the Create Import Profile button and the below section appears.

Here, enter the code for the job, label the name of the job, and then for the Job you can select –

• Multi Source Product File Import
• Multi Source Product Model File Import

For now, we will choose one and save the import job.

Now, you need to navigate to the source section of the job.

Here, select the –

• Import Source – Select it as Dropbox.
• Select Credentials – From the dropdown select the created Dropbox credentials.
• File Path – Enter the file name with the extension type as well.

Save the details and then tap the Import Now button to import products into Akeneo.

This will start the import process.

And you can see the results after successful execution.

The products are imported into Akeneo.

Navigate to the Imports section in the side panel of Akeneo.

Tap the Create Import Profile button and the below section appears.

Here, enter the code for the job, label the name of the job, and then for the Job you can select –

• Multi Source Product File Import
• Multi Source Product Model File Import

For now, we will choose one and save the import job.

Now, you need to navigate to the source section of the job.

Here, select the –

• Import Source – Select it as a Public URL.
• Public URL – Enter the URL here.

Save the details and then tap the Import Now button to import products into Akeneo.

This will start the import process.

And you can see the results after successful execution.

The products are imported into Akeneo.

Navigate to the Imports section in the side panel of Akeneo.

Tap the Create Import Profile button and the below section appears.

Here, enter the code for the job, label the name of the job, and then for the Job you can select –

• Multi Source Product File Import
• Multi Source Product Model File Import

For now, we will choose one and save the import job.

Now, you need to navigate to the source section of the job.

Below you can see the particular section for the –

FTP:

Here, select the –

• Import Source – Select it as an FTP.
• Select Credentials – Choose the created credentials as FTP.
• Choose the directory path where you have the CSV file with product data.

Save the details and then tap the Import Now button to import products into Akeneo.

SFTP:

Here, select the –

• Import Source – Select it as an SFTP.
• Select Credentials – Choose the created credentials as SFTP.
• Choose the directory path where you have the CSV file with product data.

Save the details and then tap the Import Now button to import products into Akeneo.

Navigate to the Imports section in the side panel of Akeneo.

Tap the Create Import Profile button and the below section appears.

Here, enter the code for the job, label the name of the job, and then for the Job you can select –

• Multi Source Product File Import
• Multi Source Product Model File Import

For now, we will choose one and save the import job.

Now, you need to navigate to the source section of the job.

Here, select the –

• Import Source – Choose it as a File.
• Storage – Choose the type of Local.
• File Path – Enter the file path of the CSV file.

Save the details and then tap the Import Now button to import products into Akeneo.

That was all about the Akeneo Multi Source Import Type module. Still have doubts drop us an email at [email protected].

Also, you can check our Akeneo Development services.