Resolved Hikashop import sucessful but cant find any products

Hello,
Can you also post the debug log and sample import file of your import? To know how to get the debug log, check Where to get the debug information? section on top of this page.

Hi Tharuna,
it will not allow me to add the debug log as it is too large 2.4mb
here is a screen capture of the import

Hello,
The screen captures wont help me in finding the issue. It is always suggested to try the import with only a few records and once everything goes well, do the full import. This way you get a debug log smaller in size too. Please send a private message of the debug log or email it to tharuna@csvimproved.com. I would also need your import file to test.

Hi Tharuna
I have managed to zip the log, so it is 95k, here it is

Hello,
The debug log says that products have been updated. So the products are already in the database and are updated which looks good. In your first post, third screenshot you have clicked on category Root in HikaShop page, the products are imported into courses category, what if you click on courses category, do you see the products?. If not, Can you also post the sample import file?

Hi,
no this is the starnge thing, ther os no products in the courses category either

Hello,
Please send me your import file to test.

Hi Tharuna
I just had a look at my mysql database and the products are imported into the database files, but they are just not showing up in Hikashop in the back end

Hello,
How about #__hikashop_product_category table? is records in there?

Hi Tharuna
No there is nothing in there

That is the problem, category is not imported then. I need to check with your template and import file. Again, can you send me your sample XML import file?

Here it is
Would you also like to acces the website, I can give you access as it is still only in development

Hello,
I found the cause for the issue, the problem is with product_type field, in your import it is imported as 1 as per your XML file value but HikaShop default value is 'main' and so products are not showing on backend. In your template fields you can set default value to this field as main so it is not read from your import file and then do the import. Also your products are not assigned to any categories as you don't have a category_path field in your import. If you want your products to be assigned to courses category, you can add a template field category_path and set default value to courses. This way CSVI will assign all your products to courses category as default in import. Let me know if this fixes your issues.

ok, I will give this a try and see

Hi Tharuna
I have done as above but it is still not showing

Hello,
Please send me a private message on your site administrator and database access details to check.

Hello,
Please check now, your products are showing up on backend. I did few changes to your template fields to do the import.

Brilliant, thank you Tharuna,

one question can i actually import particular products in to particular categories?

ie all prince2 courses which have a unique course code of 3 in the category courses/prince2

Hello,

one question can i actually import particular products in to particular categories?

Yes you can, you need to add category_path into your XML import file along with other product fields and set the XML path in your template fields for category_path.

ie all prince2 courses which have a unique course code of 3 in the category courses/prince2

There is no direct way of doing this but can be done using CSVI replacement rules.

1.Copy the coursecode value to category_path field using field copy plugin. So now category_path value will be 3.
2. Create a replacement rule which would find 3 and replace it with courses/prince2. Apply this rule on category_path field so whenever CSVI finds the value 3 in category_path field it will replace it new value and same will be imported.

You may need to create as many replacement rules as you want according to the coursecode value and apply all to the category_path field. Try it and let me know if it helps.

Hi Tharuna,
I have tried to apply what you have sais but it does not seem to be working, maybe I am not following you correctly.

can you expand more on this for me.

Regards
Gerald