Import Open cart to Hikashop

-- url of the page with the problem -- : www.breister.nl
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.4.0
-- Error-message(debug-mod must be tuned on) -- : Opencart has not been found in the database you specified

I get the message "Opencart has not been found in the database you specified"
I have set the asked options correct

Hello,

I have set the asked options correct

Can you check again the values that you have set through the "Database's name where your Opencart's datas are hosted " and "Opencart's website root path" options ?
Thanks.

I have checked the values but it's not working.
The values i use are correct, i think. I use the correct name of the Open cart database and the full path where open cart is installed.

Any suggestions?

Hi,

Can you try to change the line:
$query = 'SHOW TABLES FROM '.$this->opencDatabase.' LIKE '.$database->Quote(substr(hikashop_table('oc_product',false),3)).';';

to:
$query = 'SHOW TABLES FROM '.$this->opencDatabase.' LIKE '.$database->Quote('oc_product').';';

in the file administrator/components/com_hikashop/helpers/import/openc.php and see if that helps ?

Sorry, this gives the same result.

"Opencart has not been found in the database you specified"

Is it possible that there is something changed in the database structure of open cart?
I use open cart version 1.5.6

Hi,

It's possible. Can you check the tables of the OpenCart database ? Do you have a table called oc_product ?

I have found the problem, the table prefix was not oc_ because i changed this during the installation of open cart in another prefix.
The import is now completed but without the images and incorrect prices. The categories and products are succesfully imported.

Thanx for your help so far.

Ah ok ! Thank you for the information. We didn't know that it was possible to change the prefix of the tables in OpenCart.
We'll have to do something handle that then !