synolia / prestaneo

Prestaneo is a Prestashop import addon allowing to import catalogs and product data, from the Akeneo standard CSV files.

![alt text][logo] [logo]: http://www.synolia.com/wp-content/uploads/2016/03/Prestaneo-by-Synolia1.jpg "Prestaneo : Akeneo to prestashop by Synolia"

PRESTANEO by Synolia

Prestaneo is a Prestashop addon allowing to import catalogs and product data, from the Akeneo standard CSV files.

How it works

Prestaneo reads standard CSV files from the Akeneo exports in order to import data into your PrestaShop database. These data exchanges allow to import:

• Categories
• Products
• Media (Images, PDF files...)
• Attributes, characteristics & declinations

Features

• Plug and Play: We payed particular attention to make the code as “transparent” as possible. It was thought as a real new application, so it can’t interfere with the native code of Prestashop.
• Totally flexible: We added plenty of configurations. We didn't write any specific value in our code: no hard coding.
• Manual or automatic: You can either upload and import your CSV files from the Prestashop back-office or simply let the automatic cron tasks run different import with CSV files located in a directory of your server.
• Fast import: Prestaneo uses CSV files and optimized SQL requests to be even more efficient.
• Multi-site: Prestaneo is natively compatible with the “multi-store” and the “multi-language” features of Prestashop.

Requirements

Prestaneo is designed to work on Prestashop 1.5 & Prestashop 1.6 based on generated CSV files from Akeneo 1.3+

PHP : PHP 5.3+

Synolia recommends to work with the [Akeneo Enhanced Connector Bundle] (https://github.com/akeneo-labs/EnhancedConnectorBundle) in order to be more efficient in your interfaces. This bundle allows you to go further to select the right data to export.

How to install

Manually

Prestaneo's installation is rather simple ! You only need to follow theses few steps:

• Copy the module’s files in the “modules” folder of Prestashop
• Launch the install process from your Prestashop Back-office
• Enjoy your fully parameterized Prestaneo instance !

Configuration and usage

Multiple configurations are available in the addon graphic interface:

• General configurations. Here you can:
  • Manage the IP of entities that can call the automatic tasks URLs.
  • Define the ftp or sftp connection information.
  • Define the distant server path for each of CSV files.
• Settings: you can choose which of the status you want to show on the dashboard.
• CSV settings: choose enclosure and delimiter of your CSV files.
• Import settings:
  • Set a default value of stock for your products
  • Reset combinations before import them
  • Reset images before import them
  • Reset features before import them
• Other settings are mappings between CSV columns and Prestashop attributes.

About Synolia

Founded in 2004, [Synolia] (http://www.synolia.com) is a French e-commerce & CRM company based in Lyon and Paris. With more than 650 projects in both B2B and B2C, Synolia is specialized in designing and delivering the best customer experience.

Synolia provides the most innovative solutions and is a certified partner of Akeneo, Magento, OroCRM, PrestaShop Salesfusion, SugarCRM, Qlik, Zendesk. Our ambition is to make each project a new success-story.

prestaneo's Issues

Update Stock not possible

How do you update product stock?

Mapping for required fields is hardcoded

In the product import of the following fields is "hardcoded"

• reference
• name
• price

eg. it is not possible to map SKU > reference

Fatal error

When I install the module I get this error:

Fatal error in module file: /var/www/vhosts/myshop.com/httpdocs/modules/prestaneo/models/core/CronJobsSync.php:
Class 'CronJobs' not found

I saw that version 0.1.4 had solved the problems with cron

• 0.1.4 (2016-08-16)

• ** Fixed bugs: **
• • https cron url

How can I solve it? My version of prestashop is 1.6.0.14.

Thanks

Import of attributes and attribute values leads to duplicate content

Hi

I found another issue where I would appreciate to get some clarification on:

after importing attributes without any error I do an import of the attribute values - works ok!

after repeating those steps (there might be some changes?) there are duplicates in the attribute values (always the last one) and some (random?) attributes could not be found.

Do you have any idea?

Import of Categories not working

FATAL ERROR : Property Category->name is empty

code;label-en_US;label-de_DE;label-fr_FR;parent
design_touchpanel;"Design Touch Panel";"Design Touchpanel";"Écran tactile Design";XYZ

Variant Group vs Product Mapping

When importing with Prestaneo, under "Import of variant" I am uploading a CSV exported from Akeneo's Variant Groups, and under "Import of product" I am uploading a CSV exported from Akeneo Products.

Some aspects of this work ... the result in PrestaShop is that PrestaShop Products (which correspond to Akeneo Variant Groups) are created with the correct Combinations (which correspond to Akeneo Products) . However, the "description" and "short_description" fields from the Akeneo Products export seem to be lost, and are not imported into PrestaShop.

Prestaneo's mapping configuration only allows me to associate "description" and "short_description" fields for the "Import of product" section, but it seems like these should be associated with the "Import of variant" section, since Akeneo Variant Groups correspond to Prestashop Products, which is where this information should reside.

Any guidance on how to get product description and short description into PrestaShop is greatly appreciated!

Imported Products Not Linked to Categories

Thanks for this module, it's working well in importing Akeneo data (I previously opened and then closed my own ticket, finding that the problem was mine, not the module's).

But I'm seeing what looks like a real issue now: Importing categories works well and maps Akeneo category codes to PS category IDs. However, importing products does not seem to map them to their corresponding categories in PS.

Could you test this functionality on your end to determine if it's really a bug? And if so, could you provide advice on where to troubleshoot?

Category "active" field will not sync if it contains "0"

Hi

If you want to enable "active" / "inactive" category sync prestashop expects a "0" or "1" in order to set the state correctly.

This situation will not be handled properly by prestaneo. See PR

Does not work with prestashop 1.7

Sadly it seems that this modul is not ready for prestashop 1.7.

Combinations with multiple Images will be reset to only one image

I do not know how to explain this behavior since it is quite lot going on during an import ;-)

However during an import all combination images - eg. with 1 combination = 8 products à 4 images == 32 images - are stored correctly in the database in product_attribute_image. but after while (during import and I cannot 100% identify the cause, I assume it is related to product cover function or similar) those images get reduced to only 8 images.

a quick solution is provided from the fork. any feedback on this behavior appreciated

Importing into Akeneo feature

Hi!

First thanks for this amazing PS module :-)

I'm configuring a web store that uses Prestashop. There are a lot of products there so I'd like to know if there's some easy way to export from Prestashop and import the store products into the Akeneo software.

I tried to export the PS catalog (products) using the export button but the fields are a bit different from Akeneo. So I enabled the Catalog in CSV format PS module with some custom field names but it's exporting no products.

Do you know an easy way to export from Prestashop and import the store products into Akeneo?

Thanks for the support.

Best regards.