WooCommerce Akeneo PIM Connector

Check out the following video tutorials below:

• Works with simple and variable products.
• Push Product data via the export job.
• Export all the categories and attributes from Akeneo to WooCommerce.
• Import Categories to Akeneo from WooCommerce
• Module support Multi-Credentials Feature.
• Import Products to Akeneo from WooCommerce
•  Association Mapping for Upsell and Crossell products for Export
• Also, export product images along with other product information.
• Import Variations and Attribute values for products to Akeneo from WooCommerce
• Filter data to be Imported based on Category, family, Completeness, Time conditions, Identifier(SKU), Language, and Currency.
• Add Association Mapping for Upsell and Cross-sell products for Export.
• Import Attributes to Akeneo from WooCommerce
• Import Attributes terms to Akeneo from WooCommerce
• This module is compatible with the latest Akeneo version 7.0.x
• Map the product fields between WooCommerce and Akeneo
• The source code is fully open for customization.

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

{
  "scripts": {
        "post-update-cmd": [
           
"vendor/webkul/woocommercebundle/composer_install.sh"
        ],
        "post-install-cmd": [
           
"vendor/webkul/woocommercebundle/composer_install.sh"
        ],
        "post-create-project-cmd": [
         
"vendor/webkul/woocommercebundle/composer_install.sh"
       ]
   },
  "repositories": [{
    "type": "composer",
    "url": "https://akeneorepo.webkul.com/"
  }]
}

composer require webkul/woocommercebundle

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

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

Please follow these steps for installing the WooCommerce Akeneo PIM Connector module in your Akeneo PIM platform.

Step 1 – Unzip the respective extension zip then merge the “src” folder into akeneo project root directory.

Ste 2 – Goto config/Bundles.php then add line:

 Webkul\WooCommerceBundle\WooCommerceBundle::class => ['all' => true],

in the return array.

Step 3 – Copy the “config” folder into akeneo project root directory for routing.

To run the Quick export in Akeneo 5.0.x, you need to run the below command.

Install composer dependency

php -d memory_limit=4G /usr/local/bin/composer --prefer-dist --no-scripts require navneetbhardwaj/akeneo-quickexport-configurator;

Webkul\QuickExportConfiguratorBundle\QuickExportConfiguratorBundle::class => ['all' => true],

wk_quick_expoort:
    resource: "@QuickExportConfiguratorBundle/Resources/config/routing.yml"
    prefix: /

Step 4 – Run this command after ssh to your akeneo server by the terminal

 rm -rf var/cache/ && php bin/console woocommerce:setup:install --env=prod;

Docker Installation Command :

For Akeneo 5

alias docker_php='docker-compose run -u www-data --rm php php';
alias docker_yarn='docker-compose run -u node --rm node yarn';
docker_php bin/console cache:clear --env=prod;
docker_php bin/console pim:installer:assets --symlink --clean --env=prod;
docker_php bin/console d:s:u --force;
docker_yarn run webpack;
docker_yarn run update-extensions;
docker_yarn run less;

For Akeneo 4

alias docker_php='docker-compose run -u www-data --rm php php';
alias docker_yarn='docker-compose run -u node --rm node yarn';
docker_php bin/console cache:clear --env=prod;
docker_php bin/console pim:installer:assets --symlink --clean --env=prod;
docker_php bin/console d:s:u --force;
docker_yarn run webpack;
docker_yarn run less;

5. If you are using php-fpm. Then you need to restart the php-fpm services and apache web server.

For Akeneo 5

sudo service php-fpm7.4 restart

sudo service php-fpm7.3 restart

Please follow these steps for installing the WooCommerce Akeneo PIM Connector module in your Akeneo PIM platform.

Step 1 – Unzip the respective extension zip then merge the “src” folder into the Akeneo project root directory.

Step 2 – Goto app/AppKernel.php then add line

      new Webkul\WooCommerceBundle\WooCommerceBundle(),

in function registerProjectBundles()

Step 3 – Goto app/config/routing.yml then add these lines at top of file woo_commerce: resource:

woo_commerce:
        resource: "@WooCommerceBundle/Resources/config/routing.yml"
        prefix:   /

Step 4 – You have to navigate first to Akeneo installation directory (Ex: cd /opt/bitnami/apps/akeneo/htdocs). After SSH, you have to run the command to your Akeneo server by the terminal.

 rm -rf var/cache/ && php bin/console woocommerce:setup:install --env=prod;

Step 5 – If you are using php-fpm. Then you need to restart the php-fpm services.

sudo service php-fpm7.2 restart

Fix regarding long attribute slug

• If you want to export, long attribute slug to woocommerce. so you need to do some changes on the WooCommerce end.
• Go To Directory: wp-content/plugins/woocommerce/includes/wc-attribute-functions.php
• Go to line no 486 and change 28 to <= 200

The admin can easily generate API keys from the WordPress Admin backend. For this, the admin will navigate to WooCommerce -> Settings as per the below image.

After that navigate to API -> Keys/Apps -> Add Key as per the below image.

The admin will be redirected to the Key Details page when the admin clicks on the Add Key button.

Here, the admin will:

• Add the Description.
• Select the WordPress admin User to generate the key for.
• For this REST API key, choose Read/Write Permission as the level of access.

After entering all the details, the admin will click the “Generate API Key” button. This will generate REST API keys for the selected user as per the below image.

You can import product data into Akeneo CSV Connector and Akeneo XLSX Connector. This will allow the Akeneo PIM to extract the data from the file and then convert it to the store in the PIM database.

For uploading the CSV or XLSX file, you can navigate to Imports>Create Import Profile after that enter Import Profile information such as Code and Label. In Job, select ‘Product import in CSV’ or ‘Product import in XLSX’ respectively then Save the profile.

You can also create a product in Akeneo. For this, navigate to Products then click to Create button. Now, you need to choose your action – as Product or Product Model as per the below image. You can either select-

• Product – if you want to create simple products.
• Product Model –  if you want to create a variable product with variations.

Now enter the SKU, choose a family,  then click the Save button as per the below image.

Product Family – This is a set of attributes that will be the same for all products belonging to a family. The product family represents product type, imposes product information structure, and defines the list of attributes for a product that it belongs to.

Add Product Details

After that, you need to provide information about the product. Enter the details like name, and collection, and upload the product image.

Select Attribute

For adding product information, select the attribute options you require. You can also create new options for the attribute. The following Attributes from Akeneo are supported for export:

• Text
• Text Area
• Number
• Date
• Boolean
• Select
• Price
• Metric
• Image
• Reference data select
• Reference data multi-select
• File

You can also add a product SKU, EAN, and price.

Upload Image

Click the upload picture section or use the drag and drop feature to add product images.

Please note all the image attributes present in an Akeneo product are added as Product Media gallery images in WooCommerce.

Multi-Lingual Information

Add information for other languages and store views.

Select Category

After entering all the product information, you can also select Categories for the created product.

To export the products, you first need to create the Export Profile. For this, navigate to Exports -> Create Export Profile as per the below image.

This will redirect you to the Export Profile page. Here, you will enter a unique code, the label then selects a job profile.

After that in the Job field, you need to select the WooCommerce Export Job after that click Save.

You can export the filtered data. For this, navigate to the Content section as per the below image.

You can filter the data as per-

• Select Credentials- In this you have to select the credentials in which you want to export the product.
• Channel – select the relevant channel of products to export.
• Locales – select multiple Locales depending as per your choice.
• Attributes – select the product attributes which you want to export. You can either select all attributes else click the Edit button to select the attributes.

You will be navigated to the “Attribute” page when clicking the Edit button as per the below image.
Here, click on the left side to select a specific attribute group. Then select the displayed attributes as per the choice.

Akeneo enables you to decide which products to export on WooCommerce.

Family

Select one or more product families to export to WooCommerce.

Status

You can also filter on the status of your products as per the below image.
All – export all products whatever their status is
Enabled (default option) – only export enabled products
Disabled – to only export enabled products

Completeness

This enables you to filter on the completeness of selected locales.
No condition on completeness – all products will be exported whatever their completeness is.
• Complete on at least one selected locale (default option) – products must be complete on at least one locale
• Complete on all selected locales – products must be complete on all locales (if you have selected more than
one locale).
• Not complete on all selected locales – products must not be complete on all locales (if you have selected
more than one locale).

Time Condition

You can now export your product on a specific time condition.

• No date condition (default option) – Products are not filtered using time conditions.
• Updated products over the last n days (e.g. 6) – To filter the products that were updated during the last six days, enter 6 value.
• Updated products since this date – To filter the products that were updated during a specific date, select a date.
• Updated products since last export – To filter the products that were updated during the last update.

Category

You can configure the categories you want to export.

By default, all categories are exported. To select a category, click n the Edit button the categories of the channel tree are displayed.

Identifier

You can select product identifiers to export the product. You can select multiple product identifiers that should be separated by comma, space, or line breaks.

After that click the Save button.

After creating the export profile, click on the Export button as per the below image.

Execution Process

After the execution of the export process, you can check the process summary and errors if present.

After the completion of the export process, you can check the products in the WooCommerce catalog. The admin can view the products and make any changes in the product edit form of WooCommerce as per the below image.

Stock Information

Since in WooCommerce, the products will not be available to add them to cart until they are In Stock status. So enter the Stock Quantity and change the stock status to In Stock.

Store View

Imported  Akeneo products will appear on the storefront as per the image.

Exported Categories:

The store owner can view the exported categories of Akeneo by navigating Products -> Categories as per the below image.

Exported Attributes:

The store owner can view the exported attributes of Akeneo by navigating Products -> Attributes as per the below image.

Now in the updated Akeneo Connector, you can now import your product catalog data from WooCommerce to Akeneo. There are various job profiles available for importing products, categories, attributes, attribute sets from Magento to Akeneo.

To do the import go to Imports>Create Import Profile, enter a code and label. Following job profiles are available:

WooCommerce Import -This will import everything from WooCommerce. All products, categories, attributes, and attribute sets.

Families Import – This will import all attribute sets of WooCommerce into Akeneo families.

Product Import – This will import all the products of WooCommerce.

Category Import – This will import all the WooCommerce categories to Akeneo.

Attribute Import – This will import all the attributes from WooCommerce to Akeneo.

Once you have selected the import job profile, from the Content section, you can select the channel and locales for import product data. You can also import multi-language data from WooCommerce to Akeneo.

Once everything is set up correctly, you just need to click the Import Now button.

After that, the import execution process will start. From the following screenshot, you can see the number of categories, attribute groups, attributes, etc are being imported to Akeneo.