start:pimguide:importproducts
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
start:pimguide:importproducts [2015/08/26 11:59] andre created |
start:pimguide:importproducts [2015/08/26 15:41] (current) andre |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| The CSV connector allows you to import product information from a CSV file in two ways : | The CSV connector allows you to import product information from a CSV file in two ways : | ||
| - | Directly from user interfaces | + | * Directly from user interfaces |
| - | From a path given in the configuration of the import profile. | + | * From a path given in the configuration of the import profile. |
| When importing products, the product database extracts data from your CSV file and integrates them into your Product Information Manager. | When importing products, the product database extracts data from your CSV file and integrates them into your Product Information Manager. | ||
| Line 36: | Line 36: | ||
| The identifier is the only mandatory attribute to import products. | The identifier is the only mandatory attribute to import products. | ||
| - | Example | + | === Example === |
| sku;family; | sku;family; | ||
| Line 49: | Line 49: | ||
| You can import products with different families in the same CSV file. | You can import products with different families in the same CSV file. | ||
| - | Families must exist in Akeneo. Use codes of families in CSV file. | + | Families must exist in the product database. Use codes of families in CSV file. |
| - | Example | + | === Example === |
| sku;family; | sku;family; | ||
| Line 57: | Line 57: | ||
| Sku-102;Mug; | Sku-102;Mug; | ||
| Sku-103;; | Sku-103;; | ||
| - | You can set or change the family of an existing product in Akeneo. Be carefull with the column family. | + | You can set or change the family of an existing product in the product database. Be careful with the column family. |
| ==== Categories ==== | ==== Categories ==== | ||
| The header of the field categories should be define in the import profile. | The header of the field categories should be define in the import profile. | ||
| - | Example | + | === Example === |
| sku;family;categories; | sku;family;categories; | ||
| Line 71: | Line 71: | ||
| You can classify products with different categories in the same CSV file. | You can classify products with different categories in the same CSV file. | ||
| - | Categories must exist in Akeneo. Use codes of categories in CSV file. | + | Categories must exist in the product database. Use codes of categories in CSV file. |
| ==== Enabled ==== | ==== Enabled ==== | ||
| Line 77: | Line 77: | ||
| You can also define the value of enabled for all product you will import in the configuration of the import profile. In this case, you don’t need to add the column ‘enabled’ in the CSV file. | You can also define the value of enabled for all product you will import in the configuration of the import profile. In this case, you don’t need to add the column ‘enabled’ in the CSV file. | ||
| - | Example | + | === Example === |
| sku;family;categories;enabled | sku;family;categories;enabled | ||
| Line 86: | Line 86: | ||
| The product information are linked to attributes. The header of fields for attributes are composed of the code of the attribute, and, if the attribute is localized, the code of the locale. | The product information are linked to attributes. The header of fields for attributes are composed of the code of the attribute, and, if the attribute is localized, the code of the locale. | ||
| - | Attributes must exist in Akeneo for importing product’s values. Akeneo CSV connector will not create attributes when importing products information. | + | Attributes must exist in the product database for importing product’s values. The CSV connector will not create attributes when importing products information. |
| If the product doesn’t exist, it will be created. If the product already exists, it will be updated with values in CSV file only. Other attributes existing in the product database will not be updated. | If the product doesn’t exist, it will be created. If the product already exists, it will be updated with values in CSV file only. Other attributes existing in the product database will not be updated. | ||
| Line 96: | Line 96: | ||
| For attribute type image or file, give the path and the name of the file. | For attribute type image or file, give the path and the name of the file. | ||
| - | Example | + | === Example === |
| sku;family;categories,short_description-en_US;short_description-fr_FR;color;name-en_US;name-fr_FR;size; | sku;family;categories,short_description-en_US;short_description-fr_FR;color;name-en_US;name-fr_FR;size; | ||
| Line 108: | Line 108: | ||
| In the column for the attributes prices, give the values only, without spaces, without commas, and without the code of the currency. | In the column for the attributes prices, give the values only, without spaces, without commas, and without the code of the currency. | ||
| - | Example | + | === Example === |
| sku;family;price-en_US-mobile-EUR;price-fr_FR-mobile-EUR;categories,short_description-en_US;short_description-fr_FR;color;name-en_US;name-fr_FR;size;image_example | sku;family;price-en_US-mobile-EUR;price-fr_FR-mobile-EUR;categories,short_description-en_US;short_description-fr_FR;color;name-en_US;name-fr_FR;size;image_example | ||
| Line 116: | Line 116: | ||
| ==== Images and Files ==== | ==== Images and Files ==== | ||
| - | You can upload an archive (zip) with files and images for different products in order to import them. In the column for the attributes images or files, give the path in the archive where Akeneo will upload images & files. | + | You can upload an archive (zip) with files and images for different products in order to import them. In the column for the attributes images or files, give the path in the archive where the product database will upload images & files. |
| - | Example | + | === Example === |
| sku;family;price-USD;categories,short_description-en_US;short_description-fr_FR;color;name-en_US;name-fr_FR;size;image_example | sku;family;price-USD;categories,short_description-en_US;short_description-fr_FR;color;name-en_US;name-fr_FR;size;image_example | ||
| Line 128: | Line 128: | ||
| To upload and run an import profile with CSV file : | To upload and run an import profile with CSV file : | ||
| - | Go to ‘Extract > Import profiles’ to display the import profiles grid. | + | * Go to ‘Extract > Import profiles’ to display the import profiles grid. |
| - | Select the import profile you want to use to import products with your CSV file by clicking the row. | + | * Select the import profile you want to use to import products with your CSV file by clicking the row. |
| - | The configuration page of the import profile opens. If the option is available, click the button ‘Upload and import‘. | + | * The configuration page of the import profile opens. If the option is available, click the button ‘Upload and import‘. |
| - | A space appears to drop a file. You can also click the area to open your device’s directory. | + | * A space appears to drop a file. You can also click the area to open your device’s directory. |
| - | Click ‘upload and import now‘. | + | * Click ‘upload and import now‘. |
| - | Akeneo displays a message to inform if the import is successful or failed. An email is sent to your mail box to give you details about the import process. | + | |
| + | The product database displays a message to inform if the import is successful or failed. | ||
| To run an import profile with a path to retrieve the CSV file : | To run an import profile with a path to retrieve the CSV file : | ||
| - | Go to ‘Extract > Import profiles’ to display the import profiles grid. | + | * Go to ‘Extract > Import profiles’ to display the import profiles grid. |
| - | Select the import profile you want to use to import products with your CSV file by clicking the row. | + | * Select the import profile you want to use to import products with your CSV file by clicking the row. |
| - | The configuration page of the import profile opens. Click the button ‘Import now‘. | + | * The configuration page of the import profile opens. Click the button ‘Import now‘. |
| - | Akeneo displays a message to inform if the import is successful or failed. An email is sent to your mail box to give you details about the import process. | + | |
| + | The product database displays a message to inform if the import is successful or failed. An email is sent to your mail box to give you details about the import process. | ||
start/pimguide/importproducts.1440615558.txt.gz · Last modified: 2015/08/26 11:59 by andre
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 3.0 Unported
