Resolved Hikashop import sucessful but cant find any products

Hello Gerald,
Can you post me your template XML to see on what you tried? I may be able to help you more looking at your template. To get your template XML file, in CSVI maintenance menu select CSVI Pro on first option, backup templates on second option, select your template and download the XML file. Post the XML file here.

Hi Thrauna
Attached is what I tried to do,
Thanks for having a look

Hello,
You need to add rules to your category_path field so the value 3 gets replaced with courses/prince2. I have added one replace rule, you can check it on CSVI Rules menu and the same is applied to category_path field in template fields. This is just a sample, you can create as many rules as you want and apply it on category_path field. Please check the attached modified template XML file. You can restore this template from CSVI maintenance menu, select CSVI Pro on first option, restore template on second option, select this modified template and click continue. Also to know more about replace rule check the documentation here.

csvi_templates_20161209_modified.xml

Hi Thrauna,

that sort of worked but it also imported all of the other courses that are not prince2, meaning that all of the other numbers that was not 3 was also imported.

Is there anything else to try?

Hello,

that sort of worked but it also imported all of the other courses that are not prince2, meaning that all of the other numbers that was not 3 was also imported.

That is because you had set default value for category_path to 3 in your template fields, default value will run for all the records.

Is there anything else to try?

You can remove the default value of 3 for category_path from template fields and category_path as a node in your import file and add its value only for the records needed. That way category_path wont be updated to all records.

I have removed the default value of 3 for category_path from template fields

but what do you mean by

category_path as a node in your import file and add its value only for the records needed.

do you mean in the rules?

Hello,
No, i mean is it possible to add category_path as a node in your courses.xml import file?

Oh! ok I think I unerstand now,
So I need to add a node in my xml file to say category_path which shows the categories like 3=prince2,
and in the import fields just add 3

Hello,

So I need to add a node in my xml file to say category_path which shows the categories like 3=prince2,
and in the import fields just add 3

Yes, add node for the records which has to be 3 like <category_path>3</category_path> in your XML file. In template fields let the replace rule which i created be there for category_path, so when CSVI finds the value 3 in category_path it will replace it with courses/prince2 because of the replace rule set and all other products will be added to default category courses. Try and see if it works.