You can import categories during the process of import products.
First of all, please prepare your file to import - verify if there are necessary fields with appropriate data. In the 'Category' column in the file check the correctness of category path. They should be separated by pipe "|".
See an example of a file to import below:
That means, that the product, for example, with SKU '13SBWM46' is placed in the category 'Display' and the sub-category 'Accessories' , the pipe symbol "|" serves as a separator, the product with SKU '13SB4660HDI'
is in the 'Display' main category and its sub-categories: 'Projectors' 2-nd level and 'Home Theatre' 3-rd level category. Such category tree in the Store Manager should look like this:
When the file to import is openable and ready for processing, go to Main Product Page of Store Manager and find in the top or context menu the appropriate option to launch the import/export products Wizard.
In the first page please choose the import variant and specify the corresponding file to import in the next. Use the browse button to facilitate the search of the desired file.
In the 'Options' page you can see the 'Categories Options' section, where you have an opportunity to choose the necessary identification method for import categories:
- if you have full category path in the file to import, you should check the first variant of this section;
- if your category path consists from Categories Names only (as in the example above), you should check the second variant;
- if you have the category ID in your file to import - check please the third one.
Please pay attention to the separator between the categories - it should be the same as your file to import. As in the example above, the "|" serves as a separator, in the appropriate field you should specify the similar
Also, you can choose the default category from the Store Manager's category tree, in which the products without categories will be transferred from the file.
Even provided that the category is not represented at your store, during the import process, it will be added automatically.
Please note, if you import categories with images, be sure to mark the appropriate box on the page "Options" as shown in the picture:
Do not forget to link the columns with categories name and categories images to the appropriate fields of the file, so that they could be imported correctly.
After this, you will pass to the page, where can view or edit the base date and time formats and values separators . You can leave this page by default.
On the 'Preview Import' page you will be able to see the fields, which were linked and should be imported.
In order to have an opportunity to use the current import configuration the next time, you may save it to a separate file as well as directly in the wizard, using the following options:
Click 'Import' to start the process.
In the last window of VirtueMart, Import Products Wizard will be shown if any errors occurred during import .