Resolved Import from XML file

Hello,

If there is not any field to select XML as kind of file, then can you please suggest us the correct way of adding an XML file to import Virtuemart products and Virtuemart categories?

Please have a look at import from XML file documentation to know on how to setup a XML import.

Also, we tried to create for example a template for Virtuemart Category info. When we go to add fields, we don't see virtuemart category name at drop down for example. We see other familiar fields but this specifically not (except if its a different import).

The field you are looking for is category_name, if you don't see the field in your template fields then try updating your available fields.

1) We read this instruction but we cannot see anywhere option:
Use file extension: XML

We have no option at all like this at the final version.

2) We updated available fields and all ok now. Just a question on this one. Is there a field to show the parent category id?

Hello,

1) We read this instruction but we cannot see anywhere option:
Use file extension: XML

We have no option at all like this at the final version.

You should see this option on File tab in your template settings. If you don't see this field click on Advanced button on top right corner.

Is there a field to show the parent category id?

We dont use id fields in CSVI as they are database unique fields. The parent - child relation of category is created using the path in category_path field. An example of using category_path is like Women/clothes. CSVI will insert/create the parent category Women first if not available in database and then inserts/create child category clothes and relates it to parent category Women.

Ok with advanced option we saw the option.

Regarding parent/child category perhaps we have an issue.

We have an XML file where we have category id as node and parent_id as node. How could we import categories like this (having the parent id of each category with no names at all?

-----

We found out that there is a virtuemart table called virtuemart_category_categories where there is a column called: category_parent_id and the parent category's id of each category is saved.

Also, the importing stops after some records because it cannot find some category_path value which is required for category import. Because we generate this file with php, its 100% that we have category_path to each category.

URL Path: https://goo.gl/8odxWg

We used virtuemart_category_id to connect it with a node from XML but in virtuemart it seems that it takes its own ID when created

Hello,
There is no direct way for doing this type of import as you have only id of parent and not its name. Try the below steps first on a test site and see how it goes before you do it on a live site.

1. You need to make sure that your category table auto increment value starts from 207734 which is as per your file. So you need to alter your VirtueMart category table auto increment to start from id 207734 using the below query and running it from phpmyadmin. Note that this can be done only with fresh install where your tables are empty.

ALTER TABLE #__virtuemart_categories AUTO_INCREMENT=207734;

2. Import only the categories, so the name and its ids are created. Leave the parent child relation for now, all parent ids for categories will be 0.
3. Empty all rows in #__virtuemart_category_categories table
3. Now do a custom table import for table #__virtuemart_category_categories and use only category_parent_id and category_child_id from your XML file.

This should solve your problem. Let me know how it goes.