Import from Virtuemart is not working

Hi,

It should be just "pp3_"

If you have a blank page when you try running the import, please activate the "debug" setting of the Joomla configuration page and try again to run the import. It should then display the error message on that blank page, allowing us to understand what's going on so that we can tell you what to do.

Hi,

1. I can't access your website backend:
i.imgur.com/E6XItCE.png
Also, it's the "debug" setting you need to activate. I didn't talk about the error reporting. So please try again.

2. The CSVI extension will generate a CSV with the columns of VirtueMart. If you want to import that CSV to HikaShop you need to either:
- use CSVI to do the import. It has a nice interface to match the column names from the CSV with the columns in HikaShop.
- open the CSV file in Excel, change the column names to the ones in HikaShop and then run the HikaShop import on the modified CSV.

Hi,

I checked your backend but I couldn't figure out why you get that blank page.
Could you provide a FTP access so that we can do some debugging to investigate the problem ?
Please go through our contact form to provide credentials privately:
www.hikashop.com/support/contact-us.html

Regarding CSVI, I've never used it myself. So it would be hard guiding you. You probably know it better than me. I would recommend contacting CSVI's support for help on it.

Hi,

Thanks. I found the issue.
Before the import starts, the system actually process the categories in VM to add a level information so that the import can be done more easily afterwards. However, the categories in your VM have incorrect data, which led to the import looping on the level calculations. However, it seems your hosting system has some protection for loops like this, which stops the process before the normal system of PHP would stop itself. However, this led to no error message being displayed, instead of the normal PHP error message which would have guided us to the issue.
I added some extra checks on the VirtueMart import so that even if categories in VirtueMart have incorrect data, it doesn't break the import.
Now this part of the process runs fine on your website. So please try again.
We'll add the patch on our end for the next version of HikaShop.

Hi,

I've added the fix on your website already. So there is nothing to do. You can just run the import from VM now.
I basically changed the line:

'WHERE category_parent_id IN ('."'".implode("','",$childs)."'".');';

'WHERE category_parent_id IN ('."'".implode("','",$childs)."'".') AND level < 1;';

Hi,

For images, you might need to copy the files manually from the folder where they are located to images/com_hikashop/upload/
For some reasons, in some cases the copy doesn't work in the import.

Also, I do see the description and images for most of the products imported. So this means there was probably some kind of plugin or custom mod of VirtueMart or a combination of settings for these products where it didn't work, where the data was not where the import system expects them to be. You'll have to add the data manually for these I'm afraid.

Hi,

Please note that we have a money back policy if you want to quit:
www.hikashop.com/money-back-policy.html

Importing "full and correct data" is difficult. Things change between versions of software, different settings, and extra plugins and customizations can change things up further. The issue you had with the categories level calculations is something no one else had so far. I believe you must have some strange things going on with the data of your VM, which is not standard.