The Store Manager Import Wizard will greatly facilitate the updating of your Store database, via a simplified, and efficient set of routines and applications.
Pay careful attention to each Wizard's page, to ensure correct importation of products into Magento. Magento import, depending upon the extent and number of operations to be performed, can be a rather complicated procedure. It may also be destructive, if performed incorrectly. Be sure to create a database backup before importing products, especially if this is the first time that you are performing this task.
Select 'Import', and click 'Next' ( > ), to continue.
*Note: You may select 'Load Settings', to recall a previously saved configuration.
To import an .xml file, select the 'Import/Export Wizard', and perform the following steps:
1) Transform the source .xml data, and output a .csv formatted file, by manually linking the XML nodes to CSV columns, or perform automatic conversion by pressing the 'Link Automatically' button.
2) Instantiate the .csv file import process:
After launching the 'Import/Export Wizard', the source file preview dialog shows the part of the .csv file that was selected for import. There are no options to set, but you should carefully review the contents of this page.
It is particularly important to verify that the field delimiter(s) and quote character(s), if used, are accurately specified.
If you carefully check the first line of the example, you'll notice that some words are enclosed in quotes ("), and are separated by a semicolon (;) symbol. These are important options you must pay particular attention to, as you will have to specify/configure these settings on the next page. Usually it is sufficient to review the first line, and it is not necessary to investigate the entire file. You may also enable and set the beginning point (row #) from which you want to start the import.process.
Generate new file name and upload as new image if image with current name already exists - if an image in the .csv file has the same name as an already existing image, it will not replace the existing image, but the image to be copied will be saved under a modified name.
Local directory with images - specifies the folder on the local PC which contains the images to be uploaded. Note that the images' names should be specified in the .csv file, being sure that when the columns containing the images' names are assigned, that the correct column structure is maintained, relative to the target database (see step 7).
Resize rule - allows you to resize the Images during the Import process.
At this step you can notice “Keep current categories associations” option. There sometimes occurs the necessity to update existing products (added previously) and they have the category assigned already.
Although you might need to place these products to other categories without removing them from the one, they are listed in at the moment.
In this case you should check the option - 'Keep current categories associations'.
As an example, product 'Funnel neck', in the file to import, is specified only in one category - 'Women', but in the target Store database it has previously been assigned to multiple categories.
To update the target database, additionally assigning the category 'Women', check 'Keep current categories association (s)', which allows to place to new category (indicated in the import file) but not removed from original
categories (it has been placed to formerly) .
File to import should contain the following information about categories :
Store Manager will place the items after importing based on the specified positions. If some categories are not existing in the store, they will be created by following the sequence indicated in the categories path .
Leave current option un-checked in this case:
and the program will identify products category path and allocate them to the correct positions after importing by the specified IDs .
The remaining option, in this step of the import process, 'Use ID as category path', allows the assigning of products to a category(ies), specified by the identifier, without providing an indication of the category path.
2. Select Store View.
3. The next step allows for the Linking of columns from the .csv file, to their relative, database fields.
Link columns from .csv file to appropriate database fields. The left pane "Database Fields" shows the list of fields in your database that can receive import data.
By default, the topmost option (First row) in the.csv file contains field names, and not values. It should be checked if the first row contains actual data, otherwise be sure that it remains unchecked.
Identify products by. The Magento Import Products Wizard will search for a product using the identification method selected in this field. The product will be modified, if found, If the selection does not previously exist, a new product will be added.
The Source .csv file may contain multiple records with identical Name values. These products will be considered as one - currently imported product(s) will overwrite previously imported product(s) that have the same key field values. Note that sometimes a key field may be blank (contain no User specified value). Blank fields contain the same value for all records. It is required that each key field within all .csv columns contain a valid assigned value .
'Database Fields' displays the list of fields in your database that are eligible to receive import data. It may contain columns (fields) such as:
To assign .csv columns to database fields, select a field in the left pane, and click the appropriate column in the right pane.
[Auto link all] button - If this choice is selected, the system will automatically try to determine, and set appropriate relationships between the fields and the underlying database columns. The Auto fill option will work only if the .csv column names are the same as the database field names ("translated").
[Unlink all] button - unlink all "csv col" values listed in the left pane
Click 'Next', if you're done.
Store Manager requires a specific formatting for product attributes. To view this format, export a few products (with attributes). You may also view an example format below. Please note that Excel can be used to merge attributes, in case they are in separate columns. Please contact your administrator for help, or perform a Google topical search, for additional information.
Also attributes may be imported from the columns of a .csv file. This is convenient if you are updating products from a supplier's .csv file. If you are importing products directly between stores, you can use the default attributes import system, in which product attributes are delimited by rows, rather than columns.
To import attributes from columns, create an additional field for each attribute. Once created, you will be presented with 4 additional options, 'Option, Value, Prefix, and Price'. You need to assign attribute value, prefix and price values for each attribute column of your file to appropriate attribute options of database in each additional field.
Pay attention to the 'Categories Path' field, during this step of the import process. To successfully import products, specify the full category path where the selected items are to be imported.
The path must include the root category, and its sub-categories, the '|' character serves as a directory separator.
As an example, refer to the screenshot below, which specifies the 'Categories' path as follows:
Default Category|Shoes, or Default Category|Clothing, or Default Category|Bags, etc, where Default Category is the root category in the categories tree:
If the default (root) category is not specified in your import file, it can be added by executing the following expression:
CONCAT('Default Category|',[CSV_COL(x)]) ,
where COL(x) refers to the column's number in the csv file that matches the category path:
4. The next import wizard page includes Base Formats and Separators The fields may already contain default values, which may be changed, if necessary.
5. The products, as of this stage of the process, have not yet been imported into your database. On the Import Preview page you may review how the .csv file will be processed, using the designated product import settings, which were specified in the prior steps.
Check whether all columns that you want to be imported are filled with data. If some of them are blank, it indicates that either you haven't assigned a .csv column, or the corresponding field in the source source (.csv) file is empty.
Columns that were not assigned will not be imported, and empty values will overwrite existing data values.
6. Import options page settings may affect the Import results. Please read and carefully verify your selection(s).
Default category. If a category name is specified in the .csv file, and a corresponding column is assigned to the database field, Store Manager will create the entire category tree for the product. If there's no "category name" column (in the .csv file), or it is not assigned, all products will be imported to a category specified as the Default. If a default category is not specified, and there's no other way to determine which category the products should be imported into, the program will create a Default category and place all of the new products within it.
The Default manufacturer is set almost the same way as the Default category, except that the product may not have a manufacturer specified at all, which is not important. Also, you can uncheck the option if you do not want to create a new manufacturer, and the currently import field does not exist in the underlying database.
Delete existing attributes when importing new - if checked, Magento Import will clear all current product attributes, and then add and assign new attributes. If unchecked, it will just add new attributes, which may lead to duplicate attributes being created.
Mark unlisted products as "Out of Stock" (This is specified in Magento as the 'In Stock' property of a product). All products that were not affected by Magento Import will be marked as unavailable, but will not be deleted.
Cache import data - this option may speed up the import process. Store Manager does a huge number of database operations while
importing products. There are many tables affected by the import, and a lot of data is processed. With a slow database connection it may take several hours, or even days, depending on the number of records, and the connection speed. If the cache option is checked, Store Manager will
generate a database backup file (the same as you may do, using the Backup/Restore wizard, with the 'Product related tables only' option selected. After
the backup is generated, the program restores it onto the local database.
All further import operations will be made locally, which is much faster than
over a remote connection. After the import is completed, another backup will be generated, of the updated local database, and subsequently this backup will be restored to your remote Store.
Note: The Cache import data option is ignored if you are currently connected to the Embedded database.
A special part on this step takes indexation import data. To improve performance online store Store Manager for Magento uses indexing - transform data (products, categories, product details, etc.). As the changes occurring at the store, the details should be transformed or updated (i.e. indexed). This stores’ specificity based on Magento platform, as they have a complex architecture of the database and all their data stored in the respective tables. To optimize current web store, Magento accumulates data in special tables by using indexes.For example, suppose you updated (changed) the prices and quantities of your product list during import process. Magento must re-index these changes to display them on your web store.
To perform this, check the appropriate field but note it takes some time to generates the data and may slow down the import procedure in general.
If you want to make imports faster - leave these fields un-checked, and after import run re-index process from your Admin panel.
Add and Modify - will add new product(s), if it is not already in the database, and modify existing products that are found.
If you want during the import process to clean up the relations for existing products - you should on this step of import procedure in 'Clean Relations' sector check the necessary products' type check-boxes.
Save Import Configuration
Attention! When the 'Import' button is pressed the process will proceed only if all settings are accurately made, otherwise, press the 'Back' button, and and verify the settings for correctness!
Also, you may specify that the computer is to shutdown, after the import process is complete.
7. The last window of the Magento 'Import Products' wizard, will display important information, such as any errors that may have occurred during the import process.
The most frequently occurring import errors involve date, time and number conversion issues, typically caused by invalid format settings (specified in previous pages), or improperly assigned columns.
Check your work! If you assign a column containing category ID's to a parent_category database field, Date/time conversion errors might be ignored, whereas other errors, such as 'Could not find image: image_name.gif' must be fixed!
If you cannot view your products in Magento, after the import process is complete, please check this related article:
You may also view these other related articles regarding the Magento Import process: